Senior Power BI Technical Consultant

As a Senior Technical Consultant, Power BI you can expect to...

• 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 that integrate 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 that support 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 while providing technical guidance and mentorship to other consultants.

You’re great at...

• Turning complex business questions into clear, intuitive reporting and analytics solutions.
• Balancing hands-on Power BI development with client engagement, requirements discovery, and solution design.
• Designing scalable semantic models and creating accurate, maintainable DAX calculations.
• Connecting data across business applications, cloud platforms, and operational systems.
• Communicating technical concepts clearly to business stakeholders, technical teams, and project leadership.
• Troubleshooting data, model, performance, and reporting issues using a structured, analytical approach.
• Collaborating across functional and technical teams to deliver complete, high-quality solutions.
• Managing multiple priorities while maintaining focus on deadlines, quality, and client outcomes.
• Guiding and mentoring other consultants, sharing practical standards, and thoughtfully applying new Microsoft data capabilities to client needs.

Sound interesting? If so, you’ll have...

• 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 also 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.

The Perks

We offer competitive pay with a performance-based bonus. Our employees also enjoy unlimited paid time off and a flexible and affordable benefits program designed to help you be and stay well, including: medical, dental & vision coverage, flexible spending accounts, health reimbursement account, and a 401(k) plan with a company match. Additionally, you’ll have the benefit of working alongside enthusiastic and energetic teammates in a dynamic and thriving environment.

HSO is an Equal Opportunity Employer.