Data warehouse engineer Jobs in Ottawa, ON

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!