Senior Specialist, Analytics

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.

This is a temporary position for a duration of 12 months. 

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.
   

What you should have:

• An undergraduate degree in a quantitative field, such as Statistics, Economics, Commerce, Computer Science, or Engineering.
• A minimum of 7 years of advanced experience in analytics or data engineering with hands‑on experience in Spark or PySpark and Databricks in production environments.
• An expert knowledge of Azure Databricks, Big Data technologies (e.g., Hadoop, Spark), relational databases, programming (Python and/R with Spark), data preparation tools and data visualization (e.g., Power BI, R, Python).
• Strong Python and Spark SQL or Delta Lake skills, with the ability to profile and tune Spark jobs to improve reliability and performance.
• Practical experience migrating SAS workloads to Python or PySpark at scale, with a strong understanding of common SAS patterns and how to translate them.
• Experience designing and delivering enablement programs, including workshops, documentation, and reusable learning assets.
• Strong communication, presentation and influencing skills (written, verbal and cross-cultural communication skills), including the ability to speak and write clearly and succinctly in a variety of settings and styles as well as communicating messages at multiple levels in the organization.
• Strong analytical and problem-solving capabilities.
• Expert skills in identifying and analyzing trends, patterns, or connections between issues, forecasting impacts of changes, and recommending solutions.
   

It would be great if you also had:

• CMHC/Financial business knowledge.
• Azure Databricks certifications.
• Agile & DevOps knowledge.

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

Our commitment to diversity, equity, and inclusion 

We’re committed to employment equity and encourage women, Indigenous Peoples, persons with disabilities, veterans and persons of all races, ethnicities, religions, abilities, sexual orientations, and gender identities and expressions to apply. We also welcome applications from non-Canadians who are eligible to work in Canada.

CMHC is an inclusive workplace where diversity of thought – and of people – are recognized, valued, and considered essential to achieving our mission.

Learn more about our commitment to diversity and inclusion 

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!