Senior Specialist, Business Intelligence

Job Requisition ID: 10515

Position Status: Temporary Full Time

Position Type: Hybrid

Office Location: Ottawa (ON); Montreal (QC)

Travel Requirement: Limited

Language Designation: English Essential

Salary: Our salaries generally range from $99646.37 to $124557.97 and 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. We value flexibility, enabling you to choose where, when, and how you work, based on business needs and your role. 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 what you get when you're a contract employee:

1. 3 weeks of accrued vacation.
2. Annual individual performance bonus.
3. Group insurance coverage to support your well-being from day one.
4. Support towards your personal and professional growth with training, mentorship and more.
5. An inclusive workplace culture and environment.

About the role:
Join the Business Intelligence and Advanced Analytics Team, in the Senior Specialist, Business Intelligence position. In this role, you will be responsible for improving our BI practice, designing and implementing BI solutions, and supporting our BI Community of Practice. You will also collaborate with various stakeholders to turn data into insights. This is a temporary position of a duration of 15 months.

What you'll do:

1. Provide direction on the implementation and execution of Business Intelligence Solution Operation Strategy and CMHC's technological escalation on new initiatives, and advise internal and external clients, including members of management.
2. Conduct Business Intelligence intakes including value cases creation and demonstration of analytics capabilities.
3. Ensure quality control of all BI solution development projects throughout the delivery life cycle.
4. Lead divisional BI research activities including innovative, relevant, and timely publication, and BI technology integration and innovation.
5. Perform knowledge transfer to understand the principles/techniques utilization and develop/introduce best practices to drive organizational buy-in.
6. Handle complex and difficult Business Intelligence inquiries and escalate highly complex issues/barriers/findings to relevant stakeholders with advice and recommendations to improve decision-making and drive business performance.
7. Present and communicate Business Intelligence solutions in an efficient and easily understandable way to a wide variety of audiences (internal/external, technical/non-technical), including senior management.
8. Collaborate with various lines of business, IT partners and working groups to provide BI Solution subject matter expertise, gather business knowledge and influence the adoption and implementation of infrastructure and technology choices that support the maturity of the BI capability at CMHC.

What you should have:

1. An Undergraduate degree in Statistics, Mathematics, Computer Science, Engineering, or any other related quantitative field.
2. A minimum of seven years of relevant work experience in developing and implementing BI solutions, data mining and modelling, management of large and complex data sets and ability to transform and prepare data to feed models.
3. A demonstrated experience with Microsoft Power BI in designing, developing, implementing, and optimizing dashboard and reporting solutions with a focus on usability, user experience and performance.
4. A demonstrated experience in project management work experience in Business Intelligence area with cross-organization data volume. Strong ability to manage several projects and utilizing industry standards and best practices.
5. The expert ability to identify, assess and manage risk to ensure excellent outcomes are achieved for stakeholders including advanced proficiency with Power BI security methodologies, aligning business use cases with security solutions.
6. Strong communication skills to engage various levels of stakeholders (Senior management/technical/non-technical) effectively, and advanced ability to make a persuasive, clear presentation in training/knowledge sharing perspective.
7. Sound qualitative and quantitative analytical skills with demonstrated ability to capture and synthesize information to develop strategic business plans.
8. A highly developed proficiency in Data Analysis Expression (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization. Strong knowledge of R/Python and ability to learn new tools as needed.

It would be great if you also had:

1. CMHC business knowledge.
2. Predictive/Prescriptive Analytics Power BI certifications.
3. Knowledge of AI and Machine Learning.

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. 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!