Bilingual Data Engineer

Job summary

Design, build, and maintain scalable data pipelines and reusable data assets using Azure and Databricks. Provide technical leadership, mentor team members, and ensure data quality and pipeline performance.

Job details

Job Requisition ID: 12558 Position Status: Permanent Full Time Position Type: Hybrid Office Location: Ottawa (ON); Montreal (QC) Travel Requirement: Limited Language Designation: Bilingual Language Skill Levels (Read/Write/Speak): BBB Security Requirement: Secret Salary: Our salaries generally range from $ 104180.28 to $ 130225.36 and 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. Learn more about our commitment to diversity and inclusion What’s in it for you 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. Defined benefit pension plan. 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. What happens after you apply We know that applying for a new job can be both exciting and daunting, and we appreciate your effort. Learn more about our hiring process. If you are selected for an interview or testing, please advise us if you require an accommodation. If you applied before and you were not successful don’t worry – we're always posting new positions, so don’t hesitate to give it another shot. We’re excited to see what you bring to the table this time around!

What you’ll do

Design, build, and maintain scalable data pipelines and reusable data assets using Azure and Databricks. Provide technical leadership, mentor team members, and ensure data quality and pipeline performance.

Requirements

Requires a bachelor's degree in computer science or a related field and at least seven years of IT experience in data engineering. Candidates must demonstrate strong proficiency in Python, PySpark, SQL, and cloud-based data integration.

Benefits

• Annual paid vacation
• Annual individual performance incentive
• Defined benefit pension plan
• Comprehensive group insurance plan
• Training and mentorship

Listed skills

• SQL · Preferred
• CI/CD · Preferred
• Git · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Python
• PySpark
• SQL
• Azure Databricks
• Azure Data Factory
• Azure SQL
• Data Engineering
• Data Pipelines
• Git
• CI/CD
• Data Modeling
• Cloud Computing
• Technical Leadership
• Mentoring
• Performance Optimization
• Employment Equity
• Data Lakes
• Workplace Inclusivity
• Business Objectives
• Git (Version Control System)
• Retrieval Augmented Generation
• Infrastructure as Code (IaC)
• Query Performance
• Peer Review
• Automation
• Test Automation
• Microsoft Azure
• Reconciliation
• Multilingualism
• Business Requirements
• Code Review
• Computer Science
• Data Processing
• Information Technology
• Continuous Improvement Process
• Data Governance
• Data Sharing
• Data Warehousing
• IBM DB2
• Relational Databases
• Development Testing
• Leadership
• Scalability
• Enterprise Architecture
• Problem Solving
• Python (Programming Language)
• Machine Learning
• Mentorship
• SQL Azure
• Software Engineering

Job areas

• Data & Analytics
• Technology
• Software
• Engineering
• Government & Public Sector
• Data Engineer
• Software Developers
• Database Administrators

More jobs from Canada Mortgage and Housing Corporation (CMHC) Société canadienne d'hypothèques et de logement(SCHL)