Analyst, Business Systems

Canada Mortgage and Housing Corporation; Ottawa; On-site; CAD 62,393 - 77,992; Full time

Benefits offered by this job

Annual Paid vacation

Annual performance incentive

Comprehensive group insurance

Professional growth & mentorship

Inclusive workplace culture

Job summary

Canada Mortgage and Housing Corporation is seeking an Analyst, Business Systems to deliver data services and products for internal and external clients. You will analyze data, design systems, and transform legacy data sources using modern tools.

Strong programming, analytics, and communication skills are essential for success. The role emphasizes collaboration across the Data team, with opportunities to automate processes and improve data quality while supporting housing sector initiatives.

Qualifications

• Minimum 3 years of relevant programming and quantitative analysis experience.
• Advanced Excel skills required.
• Proficiency in Python with Pandas and NumPy.
• Strong SQL skills with complex joins and subqueries.
• Experience with Spark and/or PySpark; familiarity with Azure Databricks.

Responsibilities

• Support BAU production of data products and reports (Excel tables, Power BI dashboards, flat files).
• Perform programming and quantitative analyses for research or policy issues.
• Identify automation opportunities and improve data processes in end-user systems.
• Maintain data definitions and documentation; ensure data quality.
• Assist with data transformation projects, migrating large datasets to Azure Databricks and modernizing ingestion.

Skills

Programming

Excel (advanced)

Python (Pandas/NumPy)

SQL (JOINs/subqueries)

Spark/PySpark

Azure Databricks

Azure DevOps

Teamwork/communication

Education

Master's degree (asset)

Tools

Azure Databricks

Azure DevOps

SAS (asset)

Job description

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

Office Location:Ottawa (ON); Calgary (AB); Halifax (NS); Montreal (QC); Toronto (ON); Vancouver (BC)

Travel Requirement:Travel not required

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

Security Requirement: Reliability Status

Salary:Our salaries generally range from $62393.27to $77991.59and 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 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.
• An inclusive workplace culture and environment.
• While positions at CMHC require some in-office presence, alternative work arrangements may be considered for Indigenous candidates.

About the role

Join the Data team, in the Analyst, Business Systems position. The role involves the delivery of data services and products to both internal and external clients through effective systems analysis and design, modeling, programming and data manipulation. The ideal candidate will have solid programming and analytical skills and can also understand client needs and translate this into useful data. This is a challenging and exciting role for someone who is passionate about data and wants to make a difference in the housing sector.

What you’ll do:

• Support business-as-usual production of various data products and reports (includes production of static data tables in Excel, Power BI dashboards, and flat files for website applications such as the Housing Market Information Portal).
• Perform programming and quantitative analysis services on research or policy issues by accessing internal and external data sources, integrating and reconciling data from alternate sources, analyzing and disseminating results in order to respond to client custom data requests.
• Identify where automation could create more efficient data related processes and implementing those efficiencies in end-user systems.
• Introduce new and follow existing quality assurance processes to ensure that all disseminated products contain accurate data and are of high quality.
• Maintain definitions and descriptions of data produced, stored and used by Data Division; ensure good process documentation.
• Assist with Data Division technology and data transformation projects: this involves migrating large data sets from legacy systems (Mainframe, SAS datasets) to Azure Databricks platform as well as modernizing and automating data ingestion, processing, quality assurance and dissemination.
• Assist in transforming legacy SAS code to other programming languages and data processing frameworks, including Python and PySpark.

What you should have:

• A minimum 3 years of relevant programming and quantitative analysis experience.
• Advanced skills in Excel.
• Intermediate to advanced programming skills in Python, including Pandas and NumPy.
• Intermediate to advanced skills in SQL: ability to write complex queries, including JOINs and subqueries.
• The ability to work with Apache Spark and/or PySpark.
• Familiar with Azure Databricks and Azure DevOps.
• Collaborative team player with strong customer service, interpersonal and written/verbal communication skills.

It would be great if you also had:

• Intermediate to advanced skills in SAS (experience working with SAS statistical software suite to perform programming tasks is considered an asset).
• Working knowledge of AI tools (e.g., Microsoft Copilot, GitHub Copilot, Databricks Genie) to support data analysis, code development, reporting, and operational efficiency.
• Some project management experience/exposure acquired through being a subject matter expert on small to medium-sized technology projects.
• A master’s degree in the above disciplines is considered an asset.

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.

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!