Job title: Senior Analyst, Information Business Systems
Company: Canada Mortgage and Housing Corporation
Job description: Job Requisition ID: 9851
Position Status: Temporary Full Time
Position Type: Hybrid
Office Location: Montreal (QC); Calgary (AB); Halifax (NS); Ottawa (ON); Toronto (ON); Vancouver (BC)
Travel Requirement: Travel not required
Language Designation: English Essential
Language Skill Levels (Read/Write/Speak): ZZZ
Salary: Our salaries generally range from $ 68974.7 to $ 86218.38 and are based on qualifications and experience.
About CMHC
At CMHC, the work you do and the work we do together matters. We come to work every day with a common purpose: to realize a future where everyone in Canada has a home that they can afford and meets their needs.
Our people are second to none. We lean in with courage, band together as a community and try new things to make a lasting impact on housing from coast to coast to coast.
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 what you get when you’re a contract employee:
- 3 weeks of accrued vacation
- Annual individual performance bonus
- Support in your personal and professional growth with training, mentorship and more – because when you thrive, we thrive
- An inclusive workplace culture and environment with Employee Resource Groups and more
- A hybrid work model that lets you balance working from home and nurturing in-person connections by coming into your region’s office at a minimum of 4 times a month.
About the role
Join the Data Acquisition Team in the Policy sector, in the Senior Analyst, Information Business Systems position. In this role, you’ll provide data services to clients by translating data needs into actionable data requirements by using programming, data manipulation and data governance principles and techniques to store, curate and process data from various sources to make data available to clients.
This is a temporary position of a fixed duration until March 28,2025.
What you’ll do:
- Lead 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 following 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 HMI; 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, Cloudera) 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 including Python/PySpark and R.
- Provide advice and expertise to help improve operational processes and documentation.
What you should have:
- Undergraduate degree in a quantitative discipline: computer science, statistics, applied mathematics, data analysis/science, engineering, or related quantitative field.
- Minimum 3 years of relevant programming and quantitative analysis experience or an equivalent combination of education and related experience.
- Advanced skills in SAS combined with substantial experience working with SAS statistical software suite to perform programming tasks.
- Advanced skills in Excel.
- Familiar with Python or R programming language: worked on a few projects using it.
- Good communication (oral and written) and presentation skills; able to communicate complex subjects adapted to different audiences.
- Demonstrated interpersonal skills, always showing tact and diplomacy.
- Strong customer service skills: ability to understand and translate data needs into useable and user-friendly data output/products.
It would be great if you also had:
- Intermediate to advanced skills in SQL: ability to write complex queries, including JOINs and subqueries.
- Intermediate to advanced programming skills in Python including PySpark, Pandas, and NumPy.
- Intermediate to advanced programming skills in R including tidyverse, dplyr, and SparkR/Sparklyr.
- Familiar with Azure Databricks: currently working, or worked, on a few projects using it.
- Comfortable working with Azure DevOps or similar source code version control system and Apache Spark.
- Project management experience acquired through being a subject matter expert on small to medium-sized technology projects.
- Experience working with or analyzing housing or socioeconomic data to support decision-making.
- A master’s degree in the above disciplines (outlined in the minimum qualifications section).
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.
What happens after you apply
We know that applying for a new job can be both exciting and daunting, and we appreciate your effort. . 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!
Expected salary:
Location: Canada
Job date: Wed, 20 Dec 2023 07:42:23 GMT
