Bilingual Data Engineer

Canada Mortgage and Housing Corporation; Ottawa; Hybrid; CAD 104,000 - 130,000; Full time

Benefits offered by this job

Annual Paid Vacation

Performance incentive

Group insurance plan

Training & mentorship

Job summary

Canada Mortgage and Housing Corporation (CMHC) is hiring a Bilingual Data Engineer to design, build and support reliable data pipelines on Azure Databricks. You will create reusable data assets and models to support Canadians' housing affordability goals, while mentoring teams and improving engineering practices.

The role combines hands-on delivery with technical guidance, requiring collaboration with data scientists, architects and stakeholders across CMHC.

Qualifications

• An undergraduate degree in computer science, software engineering or related field.
• A minimum of seven (7) years of IT experience in data engineering, analytics engineering, or related fields.
• Experience programming in Python using PySpark and SQL in production.
• Experience with Git, automated testing and CI/CD with controlled releases.
• Experience in secure, structured IT environments with policy adherence.
• Experience processing large datasets, data lakes and data warehouses.
• Hands-on experience with Azure and Databricks data pipelines and orchestration.

Responsibilities

• Design, build, test and document scalable data pipelines using Python, PySpark, SQL, Azure Databricks, Azure Data Factory and Azure SQL.
• Develop reusable, curated datasets and dimensional data models for analytics.
• Monitor pipeline health, data freshness and quality; provide second-level support and incidents resolution.
• Provide technical leadership through design reviews, mentoring and reusable patterns.
• Optimize pipeline/query performance and cloud resource costs; identify risks and improve patterns.
• Develop maintainable code and configure using Git, tests and CI/CD across environments.
• Understand stakeholder requirements and enterprise architecture for long-term scalability.
• Collaborate with data architects and other stakeholders to deliver scalable data pipelines and products.

Skills

PySpark

SQL

Git

CI/CD

Azure Databricks

Data pipelines

Data engineering

Education

Bachelor’s degree in computer science or software engineering

Master’s degree in related field

Tools

Git

CI/CD tools

Job description

Select how often (in days) to receive an alert:

Travel Requirement:Limited

Language Skill Levels (Read/Write/Speak):BBB

Security Requirement: Secret

Salary:Our salaries generally range from $104180.28to $130225.36and are based on qualifications and experience.

About CMHC

The work you do and the work we do together matters. We come to work every day with a common purpose: to contribute to a well-functioning housing system.

At CMHC, we hold ourselves accountable for our results and support our colleagues in their achievements. We thrive on collaboration, connecting across CMHC and involving the right people to get our work done. Our leadership style is guided by trust, where our leaders favour an adaptive approach based on the needs of their teams.

Join us and be part of a team that's committed to making a real difference and be part of something meaningful.

Our commitment to diversity, equity, and inclusion

We're committed to advancing employment equity and fostering an inclusive workplace. To reflect the diversity of Canada’s population, we encourage applications from women, Indigenous Peoples, persons with disabilities, 2SLGBTQI+ individuals, veterans, and racialized peoples. We also welcome applications from all individuals eligible to work in Canada.

We are also committed to advancing reconciliation with Indigenous Peoples and supporting the meaningful inclusion of First Nations, Inuit, and Métis voices and priorities. While this position is hybrid requiring some in-office presence, a work from home arrangement may be considered for First Nations candidates on reserve or Indigenous candidates that reside further than 125KM from a CMHC office.

We’ve got the purpose, the people and the perks you need for a fulfilling career. Here’s the comprehensive and generous benefits you get when you’re a permanent employee:

• Annual Paid vacation.
• Annual individual performance incentive.
• Comprehensive group insurance plan to support your well-being from day one.
• Support towards your personal and professional growth with training, mentorship and more.
• While positions at CMHC require some in-office presence, alternative work arrangements may be considered for Indigenous candidates.

About the role

Join CMHC’s Information Technology team, in the Bilingual Data Engineer position. You will design, build and support reliable data pipelines and reusable data assets on Azure and Databricks, helping teams use trusted data to support housing affordability for Canadians. As a Data Engineer, you will combine hands‑on delivery with technical guidance, mentoring and continuous improvement of engineering practices.

What you'll do:

• Design, build, test and document scalable data pipelines using Python, PySpark, SQL, Azure Databricks, Azure Data Factory and Azure SQL, integrating cloud and legacy sources, including DB2.
• Develop reusable, curated datasets and dimensional data models for analytics.
• Monitor pipeline health, data freshness and quality; provide second‑level support and resolve incidents. Perform root cause analysis, implement lasting fixes and maintain runbooks, including safe restart and reprocessing procedures.
• Provide technical leadership through design and code reviews, mentoring and reusable engineering patterns. Where relevant review vendor deliverables for quality, maintainability and support readiness, and explain technical trade‑offs to stakeholders.
• Optimize pipeline and query performance, scalability and cloud resource costs. Identify technical risks and improve engineering patterns within approved architecture, security and operational standards.
• Develop maintainable, reusable code and configuration using Git, peer review, automated tests and CI/CD. Follow controlled deployment practices across development, test and production environments.
• Understand stakeholder business requirements, enterprise architecture, policies, and standards to build data pipelines for long‑term compatibility, scalability, and maintainability.
• Partner with CMHC business lines and collaborate with cross‑functional stakeholders, including data architects, data stewards, data scientists, and enterprise architects, to deliver scalable data pipelines and products that support business objectives.

What you should have:

• An undergraduate degree or a bachelor’s degree in computer science, software engineering or in a related field.
• A minimum of seven (7) years of IT experience in data engineering, analytics engineering, or related fields.
• A strong ability to program in Python using PySpark and SQL as demonstrated by your delivery of multiple data processing projects in production.Experience developing maintainable code using Git, peer review, automated testing and CI/CD, with controlled releases across environments.
• Experience working in a secure, structured, and controlled IT environment with separation of duties, adherence to policy and architecture.
• An extensive experience with processing large datasets from multiple sources using data engineering as well as ingesting data into data lakes and data warehouses.
• A hands‑on experience building and operating data pipelines on Azure and Databricks, including orchestration and integration with relational data sources. Relevant Certification is an asset.
• Strong analytical and problem‑solving skills, with the ability to clarify business needs, explain design choices to technical and business audiences, collaborate across teams and guide colleagues and delivery partners.

It would be great if you also had:

• A master’s degree in a related field.
• Experience delivering shared data assets or semantic layers with consistent business definitions and reusable measures across analytics use cases.
• Experience automating cloud environment configuration and deployment through infrastructure as code.
• Experience building and operating data pipelines that prepare and deliver trusted data for AI and machine learning use cases, including retrieval‑augmented generation (RAG).

Posting closing date: Note, the competition will remain active until filled.

Standby and Call Back duties are a requirement of this position and will be subject to CMHC policies, including the Standby and Call Back Pay Procedure.