Senior Power BI Developer - PBIDEV 26-04660

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

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)