14 open roles

Senior PowerBI Consultant

Open Posted 7 days ago

At a glance

Type
Full Time
Location
RemoteToronto, CA
Posted
Oct 6, 2026
Visa sponsorship
Datavail sponsorsFrom recent H-1B filings
Company size
Medium (501-5K)
Industry
Technology/Software

About the role

  • 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

About Datavail

Datavail
Technology/Software · Medium (501-5K)
Sponsors visas 14 open roles

Be first in line for the next Datavail role

Scoutify watches 70,000+ companies and alerts you the moment a matching job posts. It can even apply for you before the rush.

Get alerts, free