Logo for HSO

Senior Power BI Technical Consultant

Role overview

Qualifications

  • 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.
  • A bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field, or equivalent practical experience.

Responsibilities

  • Design, develop, and deploy Power BI reports, dashboards, and enterprise reporting solutions.
  • Build and customize scalable semantic models for consistent metrics and self-service reporting.
  • Lead requirements-gathering sessions and collaborate with stakeholders and technical teams.
  • Promote best practices for report development, semantic modeling, and provide technical guidance.

Key facts

Hard skills

Other skills

  • Communication
  • Collaboration
  • Problem Solving
  • Analytical Thinking

About the company

HSO logo

HSO

  • IT Services & Consulting
  • Large
  • 1,001–5,000
We help companies modernize business operations, adopt intelligent automation, deliver real-time performance insights and connect the enterprise – accelerating the impact of digital transformation. Founded in 1987 and recognized as a trusted advisor, HSO is one of the world’s top business solution and implementation partners, large enough to serve, small enough to care. Our Global Footprint and Delivery Capabilities HSO is 100% dedicated to Microsoft technology, with practices that offer our clients a complete set of Microsoft cloud solutions from a single global partner. HSO is a proven global leader with unique delivery capabilities offered from our dedicated Microsoft practices in more than 33 offices across the Americas, Europe, and Asia. Worldwide 24/7 Global Support International customers who are rolling out Microsoft (Dynamics) solutions want support from a partner equipped for the task. HSO International is our team of experts specialized in worldwide implementations. HSO Global Managed Services provides worldwide support and maintenance services focused on proactively supporting business applications for companies that operate internationally. Contact us to discuss your business needs with one of our Microsoft Dynamics experts. We would love to have the opportunity to learn how HSO can help you accelerate the impact of digital transformation.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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.

Related jobs

See all Technical Consultant jobs

Other jobs at HSO