Lead Power BI Developer

ITC Infotech; Vancouver; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

ITC Infotech is seeking a Senior/Lead Power BI Developer to design, develop, and optimize enterprise-grade dashboards and semantic models in Canada. The role will partner with business stakeholders, BSAs, data engineering teams, and delivery leads to translate KPIs into scalable reporting solutions.

Strong hands-on Power BI, DAX, data modeling, and governance skills are required. The position is based in Vancouver with a hybrid work arrangement (3-4 days at client site).

Qualifications

• 10-12 years of IT / data analytics experience with significant hands-on Power BI development and enterprise reporting delivery.
• Strong expertise in Power BI Desktop, Power BI Service, Power Query, DAX, data modeling, semantic model design, and report visualization standards.
• Advanced DAX skills with experience creating complex measures, calculation groups, time intelligence, KPI logic, and reusable metrics.
• Strong SQL skills for data analysis, validation, performance tuning, and working with relational or cloud data platforms.
• Experience implementing RLS, workspace governance, deployment pipelines, report certification/endorsement, and access management.
• Experience using Tabular Editor, DAX Studio, Performance Analyzer, and Power BI monitoring / optimization techniques.
• Good understanding of data warehouse concepts, star schema, slowly changing dimensions, incremental refresh, and data quality validation.
• Experience working in Agile delivery environments with Azure DevOps or similar tools for backlog, sprint, release, and defect tracking.
• Strong communication skills with the ability to work with business stakeholders, BSAs, data engineers, QA teams, and leadership stakeholders.

Responsibilities

• Design, develop, and maintain Power BI datasets, semantic models, dashboards, paginated reports, and interactive reports aligned to business KPIs.
• Translate business requirements and KPI definitions into optimized reporting solutions in partnership with BSAs, product owners, and data teams.
• Build and optimize data models using star schema principles, calculated columns, measures, relationships, aggregations, and composite models as needed.
• Develop, review, and tune advanced DAX measures for performance, accuracy, maintainability, and reusability.
• Implement and maintain Row‑Level Security (RLS), object‑level security where applicable, workspace access, and Power BI governance standards.
• Publish, manage, and monitor reports and datasets in Power BI Service, including refresh schedules, gateways, deployment pipelines, subscriptions, and usage metrics.
• Collaborate with data engineering teams on source data validation, SQL queries, data quality issues, lineage, and integration dependencies.
• Perform report performance analysis using Performance Analyzer, Tabular Editor, DAX Studio, and Power BI best practices.
• Support release management activities including version control, peer reviews, deployment readiness, defect resolution, and production support.
• Mentor junior Power BI developers and provide technical guidance on design, development, testing, and documentation standards.

Skills

Power BI development

DAX

SQL

Data modeling

RLS

Governance

Deployment pipelines

Azure DevOps

Communication

Tools

Tabular Editor

DAX Studio

Performance Analyzer

Job description

ITC Infotech is lookin for Power BI Developer to join our team in Canada.

Location : Vancouver, Canada (Hybrid – You’ll have to be there at client location for 3-4 days)

About Us:

ITC Infotech is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specific alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. We provide technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.

Role

We are looking for a Senior / Lead Power BI Developer to design, develop, and optimize enterprise-grade dashboards and semantic models. The candidate will partner with business stakeholders, BSAs, data engineering teams, and delivery leads to translate KPIs and business requirements into scalable reporting solutions. The role requires strong hands‑on Power BI development, advanced DAX, performance tuning, governance, security, and the ability to mentor junior developers while ensuring delivery quality and consistency.

Key Responsibilities:

• Design, develop, and maintain Power BI datasets, semantic models, dashboards, paginated reports, and interactive reports aligned to business KPIs.
• Translate business requirements and KPI definitions into optimized reporting solutions in partnership with BSAs, product owners, and data teams.
• Build and optimize data models using star schema principles, calculated columns, measures, relationships, aggregations, and composite models as needed.
• Develop, review, and tune advanced DAX measures for performance, accuracy, maintainability, and reusability.
• Implement and maintain Row‑Level Security (RLS), object‑level security where applicable, workspace access, and Power BI governance standards.
• Publish, manage, and monitor reports and datasets in Power BI Service, including refresh schedules, gateways, deployment pipelines, subscriptions, and usage metrics.
• Collaborate with data engineering teams on source data validation, SQL queries, data quality issues, lineage, and integration dependencies.
• Perform report performance analysis using Performance Analyzer, Tabular Editor, DAX Studio, and Power BI best practices.
• Support release management activities including version control, peer reviews, deployment readiness, defect resolution, and production support.
• Mentor junior Power BI developers and provide technical guidance on design, development, testing, and documentation standards.

Qualifications & Experience:

• 10-12 years of overall IT / data analytics experience with significant hands‑on experience in Power BI development and enterprise reporting delivery.
• Strong expertise in Power BI Desktop, Power BI Service, Power Query, DAX, data modeling, semantic model design, and report visualization standards.
• Advanced DAX skills with experience creating complex measures, calculation groups, time intelligence, KPI logic, and reusable business metrics.
• Strong SQL skills for data analysis, validation, performance tuning, and working with relational or cloud data platforms.
• Experience implementing RLS, workspace governance, deployment pipelines, report certification / endorsement, and access management.
• Experience using Tabular Editor, DAX Studio, Performance Analyzer, and Power BI monitoring / optimization techniques.
• Good understanding of data warehouse concepts, star schema, slowly changing dimensions, incremental refresh, and data quality validation.
• Experience working in Agile delivery environments with Azure DevOps or similar tools for backlog, sprint, release, and defect tracking.
• Strong communication skills with the ability to work with business stakeholders, BSAs, data engineers, QA teams, and leadership stakeholders.

Preferred / Nice-to-Have Skills

• Experience with Microsoft Fabric, Lakehouse / Warehouse, Direct Lake, or Fabric data pipelines.
• Experience with Snowflake, Databricks, Azure Synapse, or other enterprise cloud data platforms.
• Experience creating executive dashboards, operational KPI dashboards, and self‑service analytics solutions.
• Exposure to Power BI tenant governance, capacity management, premium features, and usage adoption reporting.

ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.