Specialist, Business Intelligence Full Time

Specialist, Business Intelligence
Job Requisition ID: 10128
Position Status: Permanent Full Time
Position Type: Hybrid
Office Location: Ottawa (ON); Toronto (ON)
Travel Requirement: Travel not required
Language Designation: English Essential
Language Skill Levels (Read/Write/Speak): ZZZ
Salary: Our salaries generally range from $ 83038.35 to $ 103797.93 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 permanent employee:
5 weeks of vacation.
Annual individual performance bonus.
Defined benefit pension plan.
Comprehensive group insurance plan to support your well-being from day one.
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 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.
What you’ll do:
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.
What you should have:
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.
Advanced critical thinking and problem-solving skills, out-of-the-box thinking, a drive for innovation, and the ability to execute ideas.
A strong ability to work on several initiatives simultaneously and work within tight deadlines.
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.
It would be great if you also had:
CMHC business knowledge.
Predictive/Prescriptive Analytics experience.
Power BI/ Databricks certifications.
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!