Senior Power BI Technical Consultant

HSO

. Design, develop, and deploy Power BI reports, dashboards, and enterprise reporting solutions that transform complex data into actionable business insights .

Posted 11/4/2026full-timeRemote • New York • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and deploying Power BI reports and dashboards, utilizing DAX, SQL, and Power Query M for data transformation and modeling. Proficient in collaborating with stakeholders to translate business requirements into effective analytics solutions using Microsoft Fabric and Azure Synapse.

Highest-signal resume keywords

Power BI Report DevelopmentDAX and SQL ProficiencyMicrosoft Fabric ImplementationData Modeling and TransformationStakeholder Collaboration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BIDAXSQLPower Query MData ModelingData TransformationAzure SynapseETLPaginated ReportsDynamics 365 Integration

Soft Skills

CollaborationRequirements GatheringMentorshipCommunicationProblem Solving

Tools & Technologies

Microsoft FabricOneLakeDataflowsAzure DevOpsVisual StudioGit

Industry Keywords

Enterprise ReportingAnalytics SolutionsFinancial ReportingProject OperationsAccounts Receivable

Tech Stack

Tools & technologies

AzureETLSQL

About the role

Key responsibilities & impact

Design, develop, and deploy Power BI reports, dashboards, and enterprise reporting solutions that transform complex data into actionable business insights
Build and customize scalable semantic models that enable consistent metrics, accurate analysis, and self-service reporting
Translate business and functional requirements into effective technical designs, data models, calculations, and intuitive reporting experiences
Design and implement modern analytics solutions using Microsoft Fabric, OneLake, Dataflows, Azure Synapse, and related Microsoft data services
Develop reporting solutions integrating Dynamics 365 Finance & Operations, Dynamics 365 Project Operations, Dataverse, and other enterprise data sources
Create advanced calculations, data transformations, and reporting logic using DAX, SQL, and Power Query M
Lead requirements-gathering sessions and collaborate with business stakeholders, functional consultants, and technical teams throughout the delivery lifecycle
Support user acceptance testing, deployment validation, go-live readiness, knowledge transfer, and post-go-live activities
Develop paginated and operational reporting solutions for financial, billing, project, accounts receivable, and general ledger reporting needs
Establish and promote best practices for report development, semantic modeling, documentation, quality, performance, and maintainability
Provide technical guidance and mentorship to other consultants

Requirements

What you’ll need

Strong hands-on experience developing Microsoft Power BI reports, dashboards, and semantic models in enterprise environments
Advanced experience with DAX, SQL, Power Query M, data modeling, and data transformation concepts
Experience gathering business requirements and translating them into technical reporting and analytics solutions
Experience supporting solutions throughout the delivery lifecycle, including requirements, development, testing, user acceptance testing, deployment, and go-live
Experience working directly with clients and collaborating with both business and technical stakeholders
Experience with Microsoft Fabric capabilities such as OneLake, Dataflows, or Fabric semantic models
Experience with Azure Synapse, data warehousing, ETL, or modern analytics architecture
Experience integrating Power BI with Dynamics 365 Finance & Operations, Dynamics 365 Project Operations, Dataverse, or comparable enterprise applications
Experience with paginated reports or SSRS is preferred
Familiarity with Azure DevOps, Visual Studio, Git, and modern development or deployment practices is preferred
Experience with financial, project, billing, accounts receivable, or general ledger reporting is a plus
A bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field, or equivalent practical experience

Benefits

Comp & perks

Competitive pay with a performance-based bonus
Unlimited paid time off
Flexible and affordable benefits program
Medical coverage
Dental coverage
Vision coverage
Flexible spending accounts
Health reimbursement account
401(k) plan with a company match