Power BI Architect for Executive Dashboards

Insight Global; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

Insight Global in Toronto, Canada, is seeking a Power BI Data Analyst/Developer to modernize reporting within a Capital Markets technology organization. This role will transform static reports into dynamic, executive-ready dashboards that deliver meaningful insights and support informed decision-making.

The candidate will combine strong Power BI development with storytelling and business-facing reporting, creating semantic models, implementing security, and managing deployment pipelines while

Qualifications

• Solid expertise in data modeling with star and snowflake schemas.
• Advanced DAX and Power Query (M) proficiency.
• Experience with semantic modeling, calculation groups, and performance optimization.
• Knowledge of DirectQuery, Import, and Composite models.
• Proficient with RLS and OLS for data security.
• Experience with Power BI Service, datasets, workspaces, and CI/CD pipelines.
• Familiarity with PBIP format and Git-based version control for Power BI projects.
• Experience presenting dashboards to business stakeholders.

Responsibilities

• Design and develop executive-ready dashboards with clear narratives.
• Build and maintain robust semantic models following star/snowflake design principles.
• Write advanced DAX measures, calculation groups, and time-intelligence calculations.
• Develop efficient data transformation pipelines using Power Query (M).
• Implement Row-Level Security (RLS) and Object-Level Security (OLS) to enforce data access governance.
• Manage Power BI Service workspaces, datasets, and deployment pipelines.
• Maintain reports using PBIP format with CI/CD deployment pipelines.
• Collaborate with stakeholders to translate business questions into meaningful reports.
• Ensure reports meet usability, accessibility, and performance best practices.

Skills

Power BI development

DAX and time-intelligence

Power Query (M)

Semantic modeling

RLS/OLS

Git-based version control

Storytelling & presenting

Capital Markets domain

Tools

Power BI Service

PBIP format

Tabular Editor

DAX Studio

Performance Analyzer

Git

Microsoft Fabric

PowerPoint

Job description

Insight Global in Toronto, Canada, is seeking a Power BI Data Analyst/Developer to modernize reporting within a Capital Markets technology organization. This role will transform static reports into dynamic, executive-ready dashboards that deliver meaningful insights and support informed decision-making.

The candidate will combine strong Power BI development with storytelling and business-facing reporting, creating semantic models, implementing security, and managing deployment pipelines while