Sr. Data Engineer

emergiTEL is hiring a Sr. Data Engineer — Schematic and Reporting Focus . This role is available as contract or perm both.

Compensation: $80 - $90/hour or $120-$130k/annum
Location: Montreal, QC or Toronto, ON

Job Description (English)

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.

You Will

- Design and implement the semantic layer over client Athena analytical tiers. Structure the model for the reporting patterns business users require and support analytical consumers in production.

- Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and configure user workspaces within the client Power BI environment.

- Deliver the agreed set of use case reports as production-quality Power BI solutions for confirmed business audiences, validated with client stakeholders throughout delivery.

- Refine visualization requirements with client business stakeholders within the agreed report scope while maintaining focus on reporting delivery and avoiding custom UI expansion.

- Contribute to client-owned data engineering and ETL work as a co-developer alongside the client technical lead, including data ingestion, transformation, and data gap handling.

- Author test specifications for the semantic layer, Power BI reports, and ETL contributions.

- Author and maintain automated tests that run within the client deployment pipeline and investigate and remediate defects related to your components.

- Participate as an embedded member of an integrated delivery team, including daily standups, sprint planning sessions, and joint reviews with client technical leads, data analysts, and business partners.

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.

Description du poste (Franais)

Description du rle

Concevoir et livrer la couche smantique ainsi que les capacits de rapports Power BI pour des plateformes de donnes gouvernes au sein dinstitutions financires rglementes. Assurer la responsabilit du modle smantique de la couche analytique, configurer la connectivit et les espaces de travail Power BI, livrer les rapports convenus utiliss par les utilisateurs daffaires et contribuer aux travaux dingnierie de donnes et dETL dtenus par le client. Rdiger et excuter les cas de tests validant les solutions livres.

Responsabilits

- Concevoir et mettre en uvre la couche smantique sur les environnements analytiques Athena du client afin de soutenir les besoins de production de rapports et les consommateurs analytiques.

- Configurer la connectivit Power BI la couche smantique, valider les modles de requtes de bout en bout et configurer les espaces de travail utilisateurs dans lenvironnement Power BI du client.

- Livrer les rapports convenus sous forme de solutions Power BI de qualit production pour les publics daffaires identifis et valids avec les parties prenantes du client.

- Collaborer avec les partenaires daffaires du client afin daffiner les exigences de visualisation tout en respectant la porte convenue des rapports.

- Contribuer aux travaux dingnierie de donnes et dETL du client en tant que co-dveloppeur aux cts du responsable technique du client, notamment pour lingestion, la transformation et la gestion des carts de donnes.

- Rdiger les spcifications de tests pour la couche smantique, les rapports Power BI et les contributions ETL.

- Concevoir et maintenir des tests automatiss intgrs au pipeline de dploiement du client et corriger les anomalies lies vos composantes.

- Participer activement aux activits Agile de lquipe intgre du client, y compris les rencontres quotidiennes, la planification des sprints et les revues conjointes.

Profil recherch

- Exprience dmontre dans la conception et la mise en production de couches smantiques sur des plateformes analytiques telles quAthena, BigQuery, Snowflake ou technologies comparables.

- Expertise pratique de Power BI incluant DAX, la connectivit aux plateformes analytiques infonuagiques, la configuration des espaces de travail et la scurit au niveau des lignes (RLS).

- Bonne matrise de la modlisation dimensionnelle et capacit appliquer des approches pragmatiques de normalisation et de dnormalisation.

- Exprience de travail dans lcosystme AWS, notamment avec S3, Athena, Iceberg ou formats comparables ainsi quAurora PostgreSQL.

- Capacit analyser et rsoudre les problmes de performance en suivant le parcours complet des requtes dans la pile de donnes.

- Approche axe sur la qualit comprenant les tests unitaires, les tests dintgration et les contrles de qualit des donnes.

- Exprience de contribution des projets ETL et dingnierie de donnes dans un contexte de co-dveloppement tout en assurant une transition efficace vers les quipes du client.

---
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 dcisions relatives l'valuation et la slection sont prises par nos recruteurs ; une intervention humaine est systmatiquement assure, et aucun candidat n'est valu ou rejet uniquement par des moyens automatiss.