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.