Power BI Developer

Saint Laurent Consulting; Vaughan; On-site; CAD 62,000 - 90,000; Full time

Job summary

Saint Laurent Consulting is seeking a hands-on Power BI Developer for a 3-month contract, onsite in Vaughan, Ontario. You will build and optimize Power BI dashboards, develop SQL queries, data models, and DAX measures, and troubleshoot data issues.

This is a technical development role focusing on Power BI Desktop and SQL Server, including data sources, transformation, and performance tuning. On-site daily with potential for extension based on project needs.

Qualifications

• Degree or diploma in Computer Science, IT, Data Science, BI or related field.
• Hands-on Power BI and SQL development experience required.
• On-site daily in Concord/Vaughan, Ontario.

Responsibilities

• Develop and maintain Power BI dashboards and reports end-to-end.
• Write, modify, and optimize SQL queries for data retrieval.
• Connect Power BI to SQL Server and other data sources.
• Build and maintain Power BI data models and semantic models.
• Create and modify DAX measures and calculations for reporting.
• Use Power Query for data transformation, cleansing, and prep.
• Develop KPI dashboards and operational reports for various functions.
• Troubleshoot reports, data refresh issues, and performance problems.
• Optimize reports and queries for performance and usability.
• Collaborate with users and tech teams to deliver BI solutions.
• Document data models, queries, and reporting solutions.

Skills

Power BI

SQL

DAX

Power Query / M

Data modeling

Performance optimization

Crystal Reports

Education

Bachelor's degree in Computer Science or related

Tools

Crystal Reports

Job description

Duration: 3-Month Contract, with possibility of extension

Employment Type: T4A Contract

About the Opportunity

We are hiring on behalf of our client, a global leader in emissions control solutions serving the off-highway, industrial, and specialized vehicle markets. The company partners with leading engine manufacturers, OEMs, and aftermarket customers to deliver innovative environmental solutions.

We are seeking a hands-on Power BI Developer who can independently develop, modify, troubleshoot, and maintain Power BI reports and dashboards, as well as write and optimize SQL queries to retrieve and prepare data.

This is a technical development role, not primarily a reporting coordination or business analyst position. The successful candidate should be comfortable working directly in Power BI Desktop and SQL Server, building reports from raw data, creating data models, writing DAX, and troubleshooting data and reporting issues.

Key Responsibilities

• Develop and maintain interactive Power BI dashboards and reports from start to finish.
• Write, modify, and optimize SQL queries to retrieve, join, filter, aggregate, and validate data from SQL Server and relational databases.
• Connect Power BI to SQL Server and other enterprise data sources.
• Build and maintain Power BI data models and semantic models.
• Create and modify DAX measures, calculated columns, and calculations required for reporting.
• Use Power Query for data transformation, cleansing, and preparation.
• Develop KPI dashboards and operational reports for different business functions.
• Troubleshoot Power BI reports, data refresh issues, incorrect results, and performance problems.
• Optimize Power BI reports and SQL queries for performance and usability.
• Work with existing datasets and reports and make enhancements based on business requirements.
• Support Power BI On-Premises environments, including data gateway troubleshooting and configuration.
• Work with Microsoft Fabric as part of the organization's BI environment.
• Develop, modify, and maintain Crystal Reports when required.
• Validate data and ensure reporting outputs are accurate and consistent.
• Document data models, queries, reports, and technical solutions.
• Collaborate with business users and technical teams to understand requirements and deliver reporting solutions.

Required Technical Skills

Power BI – Required

• Proven experience building Power BI dashboards and reports independently.
• Strong knowledge of Power BI Desktop.
• Hands-on experience with DAX.
• Hands-on experience with Power Query / M.
• Strong understanding of Power BI data modeling, including relationships and star schema concepts.
• Experience working with existing Power BI reports and modifying or troubleshooting them.
• Understanding of Power BI performance optimization.

SQL – Required

• Strong hands-on SQL experience.
• Ability to independently write SQL queries.
• Experience with SELECT, JOIN, WHERE, GROUP BY, subqueries, CTEs, and aggregations.
• Experience working with SQL Server and relational databases.
• Ability to troubleshoot and validate data using SQL.
• Ability to write SQL queries that support Power BI reporting and data models.

Additional Technical Skills

• Experience with Power BI Gateway / On-Premises environments.
• Familiarity with Microsoft Fabric.
• Experience with data integration and enterprise data sources.
• Crystal Reports experience is an asset, but not the primary focus of the role.

What We Are Looking For

The ideal candidate is someone who:

• Builds Power BI reports themselves, rather than only managing or consuming reports.
• Can write SQL queries independently without relying heavily on others.
• Can take a reporting requirement and turn it into a working Power BI solution.
• Is comfortable working with raw or imperfect data and troubleshooting data issues.
• Can explain their technical approach and walk through Power BI and SQL work they have personally completed.
• Is comfortable working independently in a fast-paced environment.

Education

• Degree or diploma in Computer Science, Information Technology, Data Science, Business Intelligence, or a related field, or equivalent practical experience.

Additional Information

• 3-month T4A contract, with possibility of extension.
• Fully on-site in Concord/Vaughan, Ontario – 5 days per week.
• Candidates must be comfortable working on-site every day.
• This position requires hands-on Power BI and SQL development experience.