Senior Power BI Solutions Architect

Datavail Infotech; Toronto; On-site; CAD 95,000 - 135,000; Full time

Job summary

Datavail Infotech is seeking a senior Power BI specialist to lead enterprise reporting modernization in Toronto. You will design, develop, and optimize Power BI reports and dashboards using PBIP, while consuming shared semantic models via Live Connections.

You will collaborate with data architects, engineers, and analysts, delivering high‑quality BI solutions and ensuring governance, test validation, and deployment alignment across large-scale programs.

Qualifications

• 5+ years of Power BI development experience.
• Experience with Power BI Service, Semantic Models, and enterprise deployment practices.
• Experience building reports using PBIP format and source-controlled development.
• Experience developing complex DAX measures, KPIs, calculated tables, and advanced calculations.
• Experience with Live Connections and DirectQuery semantic models.
• Experience migrating legacy BI platforms (SSRS, Cognos, BI, Tableau, or legacy Power BI reports).
• Experience in Agile delivery teams and Git-based version control and deployment processes.
• Experience supporting large-scale reporting programs from pilot through enterprise rollout.
• Microsoft Power BI Data Analyst Associate (PL-300).
• Experience with Fabric Semantic Models and Databricks.

Responsibilities

• Design and develop Power BI reports and dashboards using PBIP project format.
• Build interactive visualizations, drill-through, bookmarks, and navigation experiences.
• Deliver reporting solutions aligned with business requirements and enterprise standards.
• Recreate and modernize legacy reports while preserving business logic and formatting.
• Consume shared and certified semantic models using Live Connections.
• Collaborate with semantic model architects to identify reporting requirements.
• Develop and optimize complex DAX calculations and KPIs.
• Validate model usability and performance for reporting workloads.
• Perform detailed reconciliation between legacy reports and new Power BI deliverables.
• Follow version control, branching, and deployment standards.

Skills

Power BI Development

DAX Development

Semantic Modeling

PBIP / Power BI Projects

Live Connections / DirectQuery

Agile / Scrum

Data Visualization

SQL Skills

Education

Bachelor's degree in CS/IS/Analytics/Engineering

Tools

Power BI Desktop

Power BI Service

PBIP

Tabular Editor

XMLA Endpoints

Git

Azure DevOps

SSRS / Paginated Reports

Job description

Datavail Infotech is seeking a senior Power BI specialist to lead enterprise reporting modernization in Toronto. You will design, develop, and optimize Power BI reports and dashboards using PBIP, while consuming shared semantic models via Live Connections.

You will collaborate with data architects, engineers, and analysts, delivering high‑quality BI solutions and ensuring governance, test validation, and deployment alignment across large-scale programs.