Skip to content
← Back to job listings

Senior PowerBI Consultant

Datavail Career Site · Canada

Senior LevelQuick applycontract5 days ago

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

This listing was posted by a verified recruiter at Datavail Career Site. Report this listing