Job Requisition ID: 11359
Position Status: Temporary Full Time
Position Type: Hybrid
Office Location: Ottawa (ON); Montreal (QC); Toronto (ON)
Travel Requirement: Travel not required
Language Designation: English Essential
Language Skill Levels (Read/Write/Speak): ZZZ
Security Requirement: Reliability Status
Salary: Our salaries generally range from $ 101639.3 to $ 127049.13 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.
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 contract employee:

• Accrued vacation.
• Annual individual performance bonus.
• Support towards your personal and professional growth with training, mentorship and more.
• An inclusive workplace culture and environment.

About the role
Join the Data & Analytics team as a Senior Specialist, Analytics. In this role, you will support the migration of legacy SAS workloads to the Databricks platform (Python and PySpark). As the primary point of contact for handling the capability enablement by designing and delivering structured training, facilitating open office hours, and developing reusable documentation and code assets that enable SAS users to maintain migrated pipelines and develop new features on Databricks.

WHAT YOU’LL DO:

• Lead enablement for the SAS‑to‑Databricks migration by defining repeatable patterns to translate SAS logic (macros/PROCs) into PySpark, Spark SQL, and Delta, and by coaching teams through adoption.
• Design and deliver workshops and office hours (e.g., SAS to PySpark, Python essentials, PySpark data engineering, Databricks best practices) and run ongoing drop‑in clinics.
• Create playbooks, starter repositories, and code templates—covering style guides, folder structures, and unit tests—to help SAS users maintain migrated code.
• Pair‑program and review code with SAS analysts and developers to confirm business equivalence and improve the performance of migrated pipelines.
• Advise on orchestration, CI/CD, and version control, including Databricks Workflows/Jobs, Git branching, package management, and automated tests.
• Promote governance, security, and reliability—including data access patterns, secrets management, and lineage—and optimize Spark performance through partitioning, caching, and efficient joins.
• Facilitate change management and adoption by measuring enablement outcomes, collecting feedback, and iterating training materials and patterns.
• Work closely with line of business, data stewards, project/program managers, enterprise architecture, analytics architect, and other IT teams, including partners, to share AA technology information, gather business knowledge, and implement internal operation process.
• Partner with the Community of Practice lead to provide subject matter expertise and influence the adoption of infrastructure and technology choices that support the maturity of the AA capacity at CMHC.

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 contract employee:

• Accrued vacation.
• Annual individual performance bonus.
• Support towards your personal and professional growth with training, mentorship and more.
• An inclusive workplace culture and environment