Senior Power BI Designer – Enterprise Semantic Layer

KData AI; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

KData AI is seeking a Senior Power BI Designer to design and build an enterprise semantic layer for consistent, trusted reporting across the client's organization. This hands-on role combines solution design, development, documentation, and coaching for a client resource who will help support the solution.

The ideal candidate has 7+ years in business intelligence and at least 5 years of Power BI delivery, with strong capabilities in dimensional modelling, DAX, and governance.

Qualifications

• 7+ years in BI and data modelling.
• Hands-on Power BI delivery in enterprise settings.
• Ability to define reusable business measures for consistency.
• Ability to translate requirements to model design and explain decisions.

Responsibilities

• Assess current reporting environment and requirements.
• Design enterprise semantic layer with reusable measures and clear definitions.
• Build and test Power BI semantic models using DAX, Power Query, and modelling best practices.
• Collaborate with stakeholders to align metrics and translate needs into model design.
• Document model, calculations, decisions, and support procedures.
• Coach client resources to maintain and extend the solution.

Skills

Power BI

DAX

Power Query

Data modelling

Stakeholder mgmt

Tools

SQL Server

Azure SQL

Power BI Admin

Job description

Senior Power BI Designer – Enterprise Semantic Layer

About the role

We are seeking a Senior Power BI Designer to design and build an enterprise semantic layer that enables consistent, trusted reporting across the client’s organization. This is a hands-on role combining solution design, development, documentation, and coaching for a client resource who will help support the solution.

The project has an urgent start. A key client resource is leaving this week, so the successful candidate must be available to interview promptly and participate in knowledge transfer.

Key responsibilities

• Assess the current reporting environment, data sources, existing Power BI assets, and business requirements.
• Design an enterprise semantic layer with reusable measures, clear business definitions, consistent relationships, and a structure that supports reporting across teams.
• Build, test, and refine Power BI semantic models using Power Query, DAX, and appropriate data modelling practices.
• Work with business and technical stakeholders to resolve differences in metric definitions and translate reporting needs into model design.
• Consider performance, refresh, security, maintainability, and appropriate access controls in the solution.
• Document the model, key calculations, design decisions, and support procedures.
• Coach a designated client resource through hands-on knowledge sharing so they can maintain and extend the solution.
• Participate in the time-sensitive knowledge transfer from the departing client resource.

Required qualifications

• At least 7 years of experience in business intelligence and data modelling, including at least 5 years of hands-on Power BI experience and proven delivery of enterprise semantic models.
• Senior-level, hands-on experience designing and delivering Power BI semantic models for enterprise reporting.
• Strong knowledge of dimensional data modelling, DAX, Power Query, and Power BI model performance.
• Experience defining reusable business measures and bringing consistency to reporting across multiple users or teams.
• Ability to work with stakeholders to clarify requirements and explain technical decisions in plain language.
• Experience documenting solutions and coaching or mentoring other team members.
• Ability to work independently in a remote client environment and move quickly through discovery and delivery.

Preferred qualifications

• Experience with shared semantic models used by multiple reports or business areas.
• Familiarity with Power BI governance, deployment practices, and row-level security.
• Experience taking over an existing reporting environment and conducting structured knowledge transfer.