Power Query Jobs in New York (NOW HIRING)

UpClear provides software to growing Consumer Goods brands, helping them plan & analyze volumes, revenue and trade promotion.  Our software BluePlanner facilitates collaboration, efficiency, and holistic business analysis throughout the distribution process. We serve clients at various stages of growth across America, Europe and Asia.

Our growth is substantial and consistent; we have been on the Inc 5000 list of fastest growing private companies for nine consecutive years. UpClear's global headquarters is in New York City and we have offices in London, Paris, and Singapore.

Please note: We are not able to provide sponsorship for employment authorization at this time.
This role requires 4 days on site collaboration per week. You must be able to commute to our West 22nd Street office in New York.

POSITION OVERVIEW 

This role is also open to contractors. We are seeking a highly skilled Power BI Expert to design, develop, and maintain custom dashboards, reports, and data visualizations that deliver actionable insights for our clients. The ideal candidate brings strong expertise in business intelligence principles, including data modeling and SQL, and can translate complex data into intuitive, high-impact analytics. 

RESPONSIBILITIES 

• Collaborate with our product team to gather requirements and define metrics and data models 

• Design, develop, and deploy interactive Power BI dashboards and reports tailored to business needs 

• Create custom views and visualizations that clearly communicate KPIs, trends, and insights 

• Transform and prepare data using Power Query (M) and advanced shaping techniques 

• Develop calculations using DAX (measures, calculated columns, time intelligence) 

• Validate data accuracy and ensure consistency across fact tables and reporting layers 

• Ensure dashboards are optimized for performance, scalability, and usability 

• Maintain and enhance existing dashboards and datasets 

• Document reporting standards 

Requirements

• Proven experience with Microsoft Power BI (5+ years preferred) 

• Experience building custom, business-ready dashboards aligned to stakeholder needs 

• Deep understanding of data visualization best practices and UX principles 

• Strong expertise in DAX and Analysis Expressions), Power Query (M language) 

• Hands-on experience with business intelligence and data warehousing concepts 

• Strong SQL skills and experience with relational databases 

• Strong analytical, problem-solving, and critical thinking skills 

• Experience with Azure data ecosystem (data lake, Fabric) 

• Experience with large-scale datasets and performance optimization 

• Familiarity with real-time or near real-time reporting 

COMPETENCIES 

• Ability to translate business questions into structured BI models and insights 

• Strong communication and stakeholder management skills 

• Attention to detail with a focus on data integrity and metric consistency 

• Creative approach to data storytelling and dashboard design 

• Collaborative mindset across cross-functional teams and time zones 

Benefits

WHY UPCLEAR ?

• Be part of a growing global SaaS company, with offices in NYC, London, Paris, Singapore
• Work on latest Cloud technology and build architecture for fast-growing Tech
• Weekly happy hours, good office culture, global cross team collaboration, direct access to executive leadership for guidance.

UpClear employees have access to a range of competitive benefits, including

• Various Health Care Plans you can choose from to best fits your needs (Medical, Dental & Vision)
• Retirement Plan with company match (401k, IRA)
• Generous Paid Time Off package that grows with seniority (Vacation, Sick, and Public Holidays)
• Paid Maternity leave
• Paid Parental bonding leave
• One month paid sabbatical after five continuous years of work at UpClear
• Hybrid work model
• Competitive Salary ($120K - $145K)

The salary range listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future. When determining a team member's base salary several factors may be considered as applicable including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority.
For contractors, compensation will be offered as an hourly rate or fixed project fee, depending on the scope of work and experience level. The estimated pay range for this role is $58 to $69 per hour. Final compensation will be determined based on factors such as skills, experience, and agreed-upon deliverables.