Specialist, Business Intelligence

3 weeks ago


Ottawa, Canada Canada Mortgage and Housing Corporation Full time
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.

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 #J-18808-Ljbffr

  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

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


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

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


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

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


  • Ottawa, Canada CMHC Full time

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


  • Ottawa, Canada CMHC - SCHL Full time

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


  • Ottawa, ON, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, ON, Canada Canada Mortgage and Housing Corporation Full time

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


  • Ottawa, Canada Home and Community Care Support Services Full time

    Position Summary: The Business Intelligence Partner is responsible for obtaining, summarizing, analyzing, interpreting, and presenting organizational, program and patient data to support strategic objectives and facilitate efficient and effective service operations across the organization. To support this work, the Business Intelligence Partner...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 2 exciting student opportunity from May 6th, 2024 to August 23rd, 2024 within the Technology branch at CATSA Headquarters. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 1 exciting student opportunity from January 9th, 2023 to April 14th, 2023 within the Technology branch at CATSA. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference and...


  • Ottawa, Canada N12 Consulting Full time

    N12 Consulting is a leading Enterprise Performance Management (EPM) firm in Ottawa, with a team of experienced consultants who specialize in unifying Performance Management and Business Intelligence (BI). We accomplish this bysupporting a broad range of strategic, financial and operational management processes to provide a complete and integrated system...

  • Spécialiste SQL

    2 weeks ago


    Ottawa, ON, Canada Canada Mortgage and Housing Corporation Full time

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


  • Ottawa, Canada Advanced Business Interiors Full time

    The **AI Specialist** will be responsible for providing continuous service and support for clients throughout the duration of each project. The AI Specialist will also work closely with team members and sales representatives to ensure all client needs are met and exceeded. It is the responsibility of the AI Specialist to provide effective communication to...


  • Ottawa, Canada Canada Post Full time

    Job Description The Specialist, Data Analytics is responsible for the delivery of leading-edge analytical solutions. This key role will work closely with the Marketing team to understand the data needs of different customer segments and craft solutions to support information-based decisions. Leveraging knowledge in Business Intelligence (BI),...


  • Ottawa, Canada Assent Full time

    Company Description Assent is the supply chain sustainability management solution for the world’s most responsible, sustainability-focused complex manufacturers. The #1 business risk for complex manufacturers is hidden. Most supply chains were never built with sustainability in mind, and most manufacturers do not have deep visibility into their supply...


  • Ottawa, Canada Assent Full time

    Company Description Assent is the supply chain sustainability management solution for the world’s most responsible, sustainability-focused complex manufacturers. The #1 business risk for complex manufacturers is hidden. Most supply chains were never built with sustainability in mind, and most manufacturers do not have deep visibility into their supply...


  • Ottawa, Canada Canadian Medical Protective Association Full time

    **M**EDICAL** **LEGAL DATA** **SPECIALIST** **CONTRIBUTING TO THE CMPA** Physician Support and Wellness’ (PSW) departmental mission is to foster and champion physician wellbeing, while mitigating medico-legal risk, supporting the delivery of safe medical care, and promoting principles of equity, diversity and inclusion (EDI). Through collaboration with...