Job Description

Job Requisition ID: 9243

Language Designation: English Essential

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

Position Status: Permanent Full Time

Travel Requirement: Limited

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

Salary: Our salaries generally range from $ 97692.52 to $ 122115.65 and are based on qualifications and experience.

At CMHC, we trust you to get the job done. We empower our employees to be fully autonomous and accountable in achieving their results.

Here are some of the reasons why we were chosen as one of Canada\'s top employers:

• Enjoy 5 weeks of vacation;
• An annual individual performance bonus;
• Defined benefit pension plan;
• Comprehensive group insurance to support your well-being from day one;
• Access to a catalogue of courses for individual learning;
• An inclusive workplace culture and environment with multiple Employee Resource Groups and much more!

Help make a difference for Canadians. CMHC\'s is that by 2030, everyone in Canada has a home that they can afford and that meets their needs. All of our programs and activities support this singular goal.

Be part of an inclusive workplace. guides everything we do at CMHC. We\'re taking to eradicate racism and advance equity within CMHC and the housing system.

Join the Business Transformation team, as a Data Architect, where we plan, implement and improve how CMHC analyses and models data to solve housing related challenges. Your skills and passion for data architecture, using cloud-based technology, data analysis, learning and innovation will support the evolution of CMHC\'s data platform as well as its flagship applications. The role will provide direction for how data is best structured and used while tackling challenging projects and business needs for our clients.

Responsibilities:

• Act as principal designer and reviewer for new data models and provide coaching on data modelling and process design.
• Work with technology & IT teams across housing, financial and educational industries to build technology solutions in support of corporate housing affordability and financial-stability strategies.
• Design, build and manage additional data ecosystems (databases & data marts) including developing effective Extract Transform Loads (ETLs) and data management best practices to move large volumes of data from various operational systems to data models for analytics consumption.
• Provide thought leadership while actively participating in the design, implementation and roll-out efforts of the data exchange platform which links the CMHC data and analytics ecosystem with external stakeholders\'/partner\'s ecosystems and data holdings (e.g. financial, education, social, etc.).
• Understand stakeholder business requirements and envisions IT structures that encourage long-term compatibility, scaleability and maintainability of platforms (innovation and evolution of our IT solutions).
• Expand and grow existing data platform capabilities to solve new data problems and challenges while looking for innovative solutions, including emerging technologies, etc.).
• Work closely with housing and finance data professionals within the business (i.e. data and analytics architects, data stewards, scientists) to build data solutions for data concepts that fuel a host of analytic models to support solutions.
• Design and manage how data is stored and organized across CMHC\'s various data platforms (e.g. Cloud vs the on-site, data lake, SQL server, DB2, PowerBI and SAS).

Minimum Qualifications:

• Undergraduate degree in computer science or software engineering or in a related field. An equivalent combination of education and/or experience would also be considered.
• Minimum of seven years of advanced experience in data implementations, including functional leadership experience.
• Extensive experience with processing large datasets from multiple sources. Examples include using: relational databases, data lakes, data warehouses, statistical analysis (R, Python, PySpark, etc.), data science, modelling, machine learning, deep learning.
• Experience working with cloud technologies (ex. Azure, AWS DataBricks).
• Experience as a designer of complex data models for analytics services.
• Solid understanding of data warehousing principles, architecture and its implementation in complex environments.
• Experience with optimization and tuning of large data extracts for visualization purposes.
• Extensive experience with various testing methodologies and user acceptance testing.
• Expert ability to communicate information about complex data environments and data models to senior level stakeholders effectively.
• Advanced demonstration of identifying, assessing and managing risk to ensure excellent outcomes are achieved.

Preferred Qualifications:

• Master\'s degree.
• Azure or other cloud certification.
• Other data or security-related certifications.

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

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

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

We sincerely thank all candidates for their interest, however, please note that only applicants selected for further consideration will be contacted. If selected for an interview or testing, please advise us if you require an accommodation.

Canada Mortgage and Housing