Power BI Developer

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

Job Description

We are hiring a Power BI Data Analyst / Developer to support a strategic reporting modernization initiative within a Capital Markets technology organization. This individual will be responsible for transforming static reports into dynamic, executive-ready dashboards that deliver meaningful business insights and support informed decision-making. The ideal candidate will combine strong Power BI development expertise with exceptional communication and presentation skills, with a focus on storytelling and business-facing reporting.

Key Responsibilities

• Design and develop visually compelling, executive-ready dashboards that communicate clear narratives, not just data.
• Build and maintain robust semantic models following star schema and 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 Git-integrated 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Strong expertise in data modeling, including star schema, snowflake, and normalization.
• Advanced DAX and Power Query (M) proficiency.
• Experience with semantic modeling, calculation groups, and performance optimization.
• Solid understanding of DirectQuery, Import, and Composite models.
• Proficiency with RLS and OLS for enterprise data security.
• Experience with Power BI Service, workspace management, and deployment pipelines.
• Git-based version control for Power BI projects, including PBIP format and CI/CD integration.
• Familiarity with Copilot in Power BI and AI-powered visuals.
• Proficiency with Tabular Editor, Best Practice Analyzer, DAX Studio, and Performance Analyzer.
• Strong presentation and data storytelling skills.
• Up to date with the latest Power BI and Microsoft Fabric capabilities. - Ability to present a sample dashboard during the interview to demonstrate storytelling, design quality, and communication skills.
• Experience using PowerPoint to present dashboards and insights to business stakeholders.
• Capital Markets, Corporate Banking, or broader Financial Services experience.
• Experience supporting executive, client, finance, or profitability reporting.
• Experience partnering with data engineering teams to ensure datasets are appropriately modeled for Power BI reporting.
• Experience supporting the modernization and migration of static reports into Power BI.