Senior PowerBI Consultant

Datavail Career Site Open

Remote Toronto Full-time Senior Data Analysis & BI

At a glance

Senior Data Analysis & BI role at Datavail Career Site. Remote, Canada · full-time · no salary stated · we estimate CA$99,750–CA$117,900.

Estimated pay

Datavail Career Site has not published a salary for this role. The figure below is our estimate, not theirs.

CA$99,750 – CA$117,900

What the middle half of senior data analysis & BI roles in Toronto paid, among postings that did state a salary.

Worked out from 40 postings that stated pay, median CA$107,250. Last updated Oct 29, 2026.

RoleData Analysis & BI

SenioritySenior

LocationToronto

WorkplaceRemote

EmploymentFull-time

PostedOct 6, 2026

Role brief

remoteroles summary, based on the employer's posting.

What you'll do

Build Power BI reports and dashboards in PBIP, including interactive visuals, drill-through, bookmarks and navigation
Recreate legacy reports while preserving their calculation logic and presentation, then check results against new reports
Use certified shared models through Live Connections and develop reusable DAX measures and KPIs
Reconcile totals and calculations with business users, resolve mismatches and support user testing and signoff
Follow Git and release workflows, document report decisions and contribute to sprint planning and design reviews

What you bring

At least five years developing Power BI solutions, including enterprise reporting work
A bachelor's degree in computer science, information systems, data analytics, engineering or a related field
Strong DAX and semantic modeling skills, with experience using Power BI Service, PBIP and certified models through Live Connections
SQL skills for checking and reconciling report data, plus experience with Git-based source control

Who this fits

This senior role suits a Power BI developer comfortable with complex calculations, legacy report modernization and reconciliation. You'll collaborate with architects, engineers, analysts and business stakeholders on a large-scale analytics modernization effort. The role is remote in Toronto.

From the employer

5+ years of hands-on experience developing enterprise Power BI solutions
3+ years working with Power BI Service, Semantic Models, and enterprise deployment practices
Experience building reports using PBIP (Power BI Project) format and source-controlled development methodologies
Experience developing complex DAX measures, KPIs, calculated tables, and advanced calculations
Experience working with certified/shared semantic models using Live Connection and DirectQuery approaches
Experience migrating and modernizing legacy BI platforms (SSRS, Cognos, Business Objects, Tableau, or legacy Power BI reports)
Experience working in Agile delivery teams and collaborating with Data Architects, Data Engineers, and Business Analysts. Experience with Git-based version control and deployment processes
Experience supporting large-scale reporting programs from pilot through enterprise rollout
Required
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field
5+ years of Power BI development experience
Strong understanding of Semantic Modeling concepts
Advanced DAX development skills
Experience with Power BI Service and Workspace administration
Experience developing reports using PBIP / Power BI Projects
Experience consuming Enterprise Semantic Models using Live Connections
Strong SQL skills for validation and reconciliation activities
Experience with Git repositories and source control workflows
Microsoft Power BI Data Analyst Associate (PL-300)
Experience with TMDL (Tabular Model Definition Language).
Experience with XMLA endpoints and Tabular Editor
Experience with SSRS/Paginated Reports (RDL)
Experience with Fabric Semantic Models and Databricks
Experience supporting Finance, ERP, or Enterprise Data Warehouse reporting solutions
Experience working with Azure DevOps
Power BI Development Power BI Desktop
Power BI Service
PBIP (Power BI Projects)
Power Query (M)
Report Optimization
Dashboard Design
Drill-through Reporting
Bookmarks
Tooltips
Dynamic Visualizations
Semantic Modeling
Semantic Models
Certified Datasets
Shared Datasets
Live Connections
Composite Models
Star Schema Concepts
Relationship Management
Calculation Groups
TMDL
XMLA Endpoints
DAX & Analytics
Advanced DAX Measures
Filter Context
Row Context
Time Intelligence
KPI Design
Calculation Validation
Data Reconciliation
Reporting & Modernization
Legacy Report Conversion
Report Parity Validation
Financial Reporting
Operational Reporting
Report Standardization
Self-Service Analytics
DevOps & Collaboration
Git
Azure DevOps
Source Control
Release Management
Agile/Scrum
Stakeholder Management
This role will work closely with Data
Architects, Data Engineers, Business Analysts, and business stakeholders throughout the lifecycle of a large-scale analytics modernization initiative
The developer will build report deliverables on top of certified semantic models, support measure development, perform report reconciliation activities, and help deliver reporting capabilities across multiple business domains
Key Responsibilities
Report Development
Design and develop Power BI reports and dashboards using PBIP project format
Build interactive visualizations, drill-through functionality, 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 consistency
Semantic Model Consumption
Consume shared and certified semantic models using Live Connections
Collaborate with semantic model architects to identify reporting requirements
Assist in creation and maintenance of measures under senior technical guidance
Validate model usability and performance for reporting workload
DAX Development
Develop and optimize complex DAX calculations and KPIs
Create reusable calculations and reporting standards
Troubleshoot DAX performance issues
Ensure accurate implementation of business calculation logic
Validation & Reconciliation
Perform detailed reconciliation between legacy reports and new Power BI deliverables
Validate measures, calculations, totals, subtotals, and KPIs
Work with business users to resolve discrepancies
Support UAT and business signoff activities
Follow version control, branching, and deployment standards
Document development processes and report design decisions
Support release management activities
Collaboration
Work closely with architects, engineers, QA analysts, and business stakeholders
Participate in sprint planning, design reviews, and project governance meetings
Provide technical guidance for reporting best practices and standards
Success Metrics
Delivery of high-quality Power BI reports on schedule
100% reconciliation accuracy against legacy reporting systems
Reduced report maintenance through reusable measures and standardized design
Adherence to governance, source-control, and deployment standards
Successful rollout of domain reporting packages from pilot through enterprise deployment