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.