Spécialiste SQL

Permanent Full Time


Office Location: Ottawa (ON); Language Designation: English Essential


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


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.


Here's what you get when you're a permanent employee:
~Annual individual performance bonus.
~ Defined benefit pension plan.
~ Support in your personal and professional growth with training, mentorship and more - because when you thrive, we thrive.
~ 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.

Join the Enterprise Architecture and Advanced Analytics Team in the Specialist, Business Intelligence position. In this role, you will be working with the Center of Enablement team to enhance our practices maturity as part of our Corporate Data Program and support BI/AA solution strategy and prioritization management. You will provide guidance on the strategic design and implementation of BI and Advanced Analytics solutions from back-end components to front-end user interaction/experience. You will also support our Analytics Community of Practice by assisting with community adoption and participation, providing subject matter expertise, and influencing the adoption of infrastructure and technology choices that support the maturity of the BI/AA capabilities at CMHC. You will work closely with stream leaders, business teams, data stewards, project/program managers, and other IT teams, and partners to turn data into insights and as such maturing our data-driven and decision-making environment.



Work within the Center of Enablement team to support the maturity of the analytics capability by developing solutions, as well as perform knowledge transfer to share principles/techniques utilized and develop/introduce best practices to drive organizational buy-in.
Maintain current operational processes and perform risk management assessments.
Support the scoping of Business Intelligence and Advanced Analytic solution sessions with business lines to capture business objectives and prioritize opportunities.
Support the analytical cycle by working with Business SMEs and develop BI/AA solutions that consistently meet or exceed stakeholder requirements.
Recommend ongoing/potential enhancements to solutions to continue to provide meaningful insights and lead business decisions.
Design and deliver knowledge transfer sessions, including the support of live BI/AA processes.
An undergraduate degree in Statistics, Mathematics, Computer Science, Economics, Engineering, Physics or any other related quantitative field.
A minimum of five years of relevant work experience developing and implementing BI/AA solutions, data mining and modeling, managing large and complex data sets, and ability to transform and prepare data to feed models.
A minimum of two years of hands-on work experience with Microsoft Power BI designing, developing, implementing, and optimizing dashboard and reporting solutions with a focus on usability, user experience, and performance.
An experience with Power BI security methodologies; aligning business use cases with security solutions.
An advanced proficiency in Data Analysis Expression (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools), and performance optimization, and a knowledge of R/Python/Spark with an ability to learn new tools as needed.
The ability to communicate clearly in conversation and presentations to both technical and non-technical staff, and to provide updates to all levels of management and stakeholders.
CMHC business knowledge.
Power BI/ Databricks certifications.
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. CMHC is an inclusive workplace where diversity of thought - and of people - are recognized, valued, and considered essential to achieving our mission.