Senior PowerBI Consultant
Datavail Infotech•Canada
Full-time3-7
👁️ 0 views•📝 0 applications•Posted 7/17/2026•Expires 8/16/2026
Get alerts for roles like this
More Senior PowerBI Consultant roles in Canada — straight to your inbox. No account needed.
Applying to this role? Tailor your résumé to this job description in one click, then download it clean — no watermark, no subscription.
Job Description
Description
• 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