Senior Data Engineer

Toronto, ON
On-site
Posted Oct 15, 2026
1 position

$80–$90 / hour

Opens an external site

Employment type: Contract
Experience level: Senior · 5+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Design and own the semantic model over the analytical data tier, configure Power BI connectivity and workspaces, and deliver reports for business users. Contribute to client data engineering and ETL work, develop and maintain lineage capabilities, and author and execute tests that validate the solution.

Job details

emergiTEL is hiring a Sr. Data Engineer — Schematic and Reporting Focus. This role is available as contract or perm both. Location: Montreal, QC or Toronto, ON Pay: $80 - $90/hour Role Description: Design and deliver the semantic layer and Power BI reporting capability for governed data platform engagements at regulated financial institutions. Own the semantic model over the analytical tier, configure Power BI connectivity and workspaces, deliver the agreed set of reports business users depend on, and contribute engineering capacity to client-owned data engineering and ETL work alongside client teams. Author and execute the test cases that prove your work. Who You Are Experienced designing and delivering semantic layers over analytical platforms such as Athena, BigQuery, Snowflake, or comparable technologies where downstream users depend on the layer in production. Hands-on Power BI expert with experience in DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security (RLS) design patterns. Strong understanding of dimensional modeling and the ability to apply practical design decisions regarding normalization, denormalization, and semantic model usability. Comfortable working within the AWS data ecosystem, including S3, Athena, Iceberg or similar table formats, and Aurora PostgreSQL. Able to troubleshoot performance issues by tracing queries through the full data stack. Committed to quality engineering through proactive testing, including unit testing, integration testing, and data quality validation. Experienced contributing to ETL and data engineering initiatives in collaborative co-development environments while cleanly transitioning ownership back to client teams. Additional Notes: Building a lineage framework rather than using Purview lineage features. Capturing lineage from ETL code (Glue, PySpark, SQL transformations). Storing lineage metadata in a graph database (Neo4j, Neptune, etc.). Automated lineage refresh integrated into CI/CD deployments. Developing lineage visualization/exploration capabilities. Agentic/LLM-based lineage generation. Explicit ownership of lineage architecture and framework design. Vacancy Status / Statut du poste This is an active position currently open for hiring. / Ce poste est activement ouvert au recrutement. Use of Artificial Intelligence / Utilisation de l'intelligence artificielle emergiTEL uses artificial intelligence to help identify and source candidates for this role. All assessment and selection decisions are made by our recruiters, a human is always involved, and no applicant is evaluated or rejected by automated means alone. / emergiTEL a recours à l'intelligence artificielle pour aider à identifier et à trouver des candidats pour ce poste. Toutes les décisions relatives à l'évaluation et à la sélection sont prises par nos recruteurs ; une intervention humaine est systématiquement assurée, et aucun candidat n'est évalué ou rejeté uniquement par des moyens automatisés.

What you’ll do

Requirements

The role requires experience delivering production semantic layers over analytical platforms and strong hands-on Power BI expertise, including DAX, cloud connectivity, workspace configuration, and row-level security. Candidates should understand dimensional modeling and AWS data technologies, be able to troubleshoot performance across the data stack, and have experience with testing and collaborative ETL and data engineering work.