Senior Power BI Developer 26-04660

Job Title: Senior Power BI Developer
Location: Mississauga ON (Hybrid 3 days onsite)

Note: Pay rates are listed in Canadian Dollars (CAD) not USD.

Position Overview

We are seeking an experienced Power BI Developer with strong expertise in SQL data warehousing and enterprise analytics. The ideal candidate will be responsible for designing developing and optimizing dashboards and reporting solutions while collaborating closely with business stakeholders to deliver actionable insights.

This role also requires exposure to scripting REST APIs and DevOps practices to support automation deployment and system reliability.

Key Responsibilities

BI Development & Reporting

• Design develop and maintain interactive Power BI dashboards reports and ad-hoc queries
• Build and optimize data models using Power Query Power Pivot and related modeling techniques
• Develop advanced DAX measures and calculated columns for analytical reporting
• Create and maintain paginated reports using reporting tools (e.g. Power BI Report Builder)

Data & Database Management

• Work with SQL Server or other relational databases to extract transform and analyze data
• Optimize SQL queries for performance and efficiency
• Support data warehousing and analytical data structures

Business Collaboration

• Gather requirements from business users and translate them into scalable data solutions
• Work closely with stakeholders to deliver accurate and actionable insights
• Participate in full project lifecycle from requirements gathering to deployment

Automation & Integration

• Support scripting and automation workflows using REST APIs and related tools
• Assist with integration of data systems and automated processes
• Troubleshoot data and system issues to ensure reliability and performance

DevOps & Deployment Support

• Support deployment activities using CI/CD tools and version control systems (e.g. Git Azure DevOps)
• Assist with pipeline execution and release processes (conceptual understanding acceptable)

Required Qualifications

Experience

• 10 years of experience in Business Intelligence Data Warehousing Analytics or Reporting
• 3 years of experience in relational and OLAP data modeling

Technical Skills

• Strong experience in Power BI (Power Query Power Pivot DAX)
• Advanced SQL skills including query optimization and database design
• Experience building enterprise-grade dashboards and reporting solutions
• Familiarity with REST APIs and scripting for automation
• Basic understanding of DevOps practices CI/CD pipelines and version control (Git/Azure Repos)

For more details reach at