Report Engineer

TEEMA; Markham; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading IT consultancy is looking for a Report Engineer (BI Developer) to design and maintain high-quality reporting solutions. The ideal candidate will have strong hands-on experience in developing Power BI dashboards and familiarity with Azure Synapse Analytics. You'll collaborate with stakeholders, implement data governance, and ensure data quality across all BI deliverables. This is a hybrid role based in Toronto, with an hourly rate of $50.00 - $55.00. If selected, you will be contacted directly.

Qualifications

• Strong hands-on experience developing Power BI dashboards and DAX calculations.
• Intermediate-level experience with Azure Synapse Analytics.
• Strong SQL skills and familiarity with data warehousing concepts.

Responsibilities

• Collaborate with business stakeholders to gather reporting requirements.
• Design and optimize Power BI dashboards and reports.
• Implement Row Level Security and ensure data quality across BI solutions.

Skills

Power BI dashboards development

Data modeling

SQL

Data ingestion

Analytical skills

Problem-solving

Communication skills

Tools

Azure Synapse Analytics

Power Query

Azure Data Factory

Tableau

Job description

Job Title: Report Engineer
Job ID: 85418
Location: Toronto, Ontario – Hybrid

Overview

The Report Engineer (BI Developer) is responsible for designing, developing, and maintaining high‑quality reporting solutions that transform raw data into meaningful insights. This role requires strong hands‑on Power BI capabilities and intermediate experience with Azure Synapse Analytics to support modern BI and analytics workflows.

What you will be doing

• Collaborate with business stakeholders to gather and document reporting requirements.
• Design, build, and optimize Power BI dashboards, datasets, and paginated reports.
• Develop data models using best practices aligned with performance and usability standards.
• Use Azure Synapse Analytics (SQL pools, pipelines) to support data ingestion, transformation, and analysis.
• Write and optimize SQL queries and transformations for reporting purposes.
• Ensure data accuracy, consistency, and quality across all BI deliverables.
• Implement Row Level Security (RLS) and follow governance standards for data access.
• Troubleshoot report issues and provide enhancements to existing BI solutions.
• Document data flows, logic, models, and dashboards for internal and external stakeholders.

What you must have

• Strong hands on experience developing Power BI dashboards, datasets, and DAX calculations.
• Proficiency in Power Query (M), data modeling, and report performance optimization.
• Intermediate-level experience with Azure Synapse Analytics (SQL pools, pipelines, transformations).
• Strong SQL skills and familiarity with data warehousing concepts (ETL/ELT, dimensional modeling).
• Experience pulling data from multiple sources (databases, APIs, cloud storage, files, etc.).
• Strong analytical, problem‑solving, and communication skills.
• Ability to work independently and collaborate effectively with technical and non‑technical teams.

Nice to have

• Experience with Azure Data Factory or Databricks.
• Exposure to CI/CD pipelines for BI assets (Git, DevOps).
• Familiarity with other BI tools (Tableau, Looker, MicroStrategy).
• Azure or Power BI certifications.
• Experience with enterprise data governance and security best practices.

Salary/Rate Range

$50.00 -$55.00/ hour

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com