Share this Job

Specialist, Power BI Solutions Developer (Position can be located anywhere in Canada)

Sector: Information Technology 

Language Designation: English Essential 

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

Salary Range: $76087.66 to $95109.58

Position Status: Permanent Full Time 

We’re not your typical government agency
Canada Mortgage and Housing Corporation (CMHC) exists for a single reason: to make housing affordable for everyone in Canada. We’re mobilizing the expertise and energy of governments, non-profits, lenders, developers, social entrepreneurs and co-ops to create the future of housing. At CMHC, we believe that everyone in Canada should have a place to call home.
Experience a Results-Only Work Environment™ (ROWE™)
At CMHC, we trust you to get the job done. We’ve shifted from managing people to managing work. Each employee is 100% autonomous and 100% accountable. You can choose where you need to be and when you need to be there to meet your objectives. You’re in control of your time and are trusted to make the right decisions.

This position reports to the Analytics team in our Analytics and Chief Data Office (CDO)   within the Chief Information Officer (CIO) sector. This sector leads our digital transformation to accelerate housing affordability.

About the role
Housing matters – to all.  At CMHC, we’re constantly evolving to build an inclusive housing system through research, design, innovation, partnerships, and analytics. We believe in the power of data and our analytics experts to continue to grow and foster a data-driven approach to help us to achieve our ambitious goal: by 2030, everyone in Canada has a home they can afford and that meets their needs.


We are looking for a Power BI Solutions expert with strong analytical and technical skills and big ideas to join our team to support the growth and maturity of Business Intelligence at CMHC.  The Analytics team leverages the wealth of data available to improve and provide valuable insights in support of decision-making in support of achieving our ambitious goal.


In this role, you will be responsible for the design and implementation of Power BI solutions from back-end components (requirements, semantic model, ETL, etc.) to front-end user interaction / experience. This includes selecting, blueprinting, gathering requirements, designing, developing, rolling out BI solutions as well as completing knowledge transfer sessions to end users.  You will be working closely with the leadership and business teams as well as other partners, turning data into insights and maturing our data-driven decision making environment while helping us make housing affordable for everyone in Canada.
If you are passionate about the power of analytics, bringing people together, and are looking for a new challenge, we want to chat with you!

What you will need
• Bachelor’s degree in Statistics, Mathematics, Computer Science, Economics, Engineering, Physics or any other related quantitative field. Master degree will be preferred.
• Minimum of five years of experience 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.    
• Minimum two years of demonstrated hands-on work experience with Microsoft Power BI in designing, developing, implementing and optimizing dashboard and reporting solutions with a focus on usability, user experience and performance.     
• Experience with Power BI security methodologies; aligning business use cases with security solutions. 
• Advanced proficiency in Data Analysis Expression (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization. Knowledge of R/Python and ability to learn new tools as needed. Advanced critical thinking and problem solving skills, out of box thinking, drive for innovation and ability to execute ideas.
• Knowledge of AI, Machine Learning and Predictive / Prescriptive Analytics is a definite asset.
• Power BI certifications is a definite asset.     
• Strong ability to work on several initiatives simultaneously and work within tight deadlines.  
• Ability to communicate clearly in conversation and in presentations to both technical and non-technical staff and to provide updates to all levels of management and stakeholders.


What you will be doing    
• Supports and/or co-leads the scoping of Business Intelligence solution sessions with business lines to capture business objectives and prioritize opportunities.
• Translates business objectives to develop and implement Power BI Solutions that facilitates decision-making and supports the business lines in support of their self-service Power BI development.
• Develops Power BI data models that aggregate data from multiple data sources to meet requirements, configure, and setup application gateway refreshes.
• Supports the analytical cycle by working with Business SMEs to:
a. Lead the discovery process to clarify business requirements and outcomes.
b. Perform data understanding, including understanding data available, influencing the addition of additional data sources, and the selection of the most relevant sources of information.
c. Creates mock-up reports for proof of concept reviews.
d. Design and develop complex BI solutions, from back-end components and processes to front-end user interaction/experience components/requirements.
e. Write functional/non-functional and integration test cases and test scripts from Power BI business requirements and technical design documents Troubleshoots/tests the solution and ensures the solution performs / performance-tune these solutions as necessary and documenting results.
f. Document business expected outcomes, baselines and value-add framework.   

• Designs and delivers Knowledge transfer sessions including support live BI processes: a) creating/changing BI process schedules, and b) monitoring and troubleshooting BI processes, such as data loads, transformations, etc.     
• Presents and communicates the Power BI solutions in an efficient and easily understandable way to a wide variety of audiences (internal and external), including senior management.    
• Documents progress, finalizes model build books, leads knowledge transfer sessions, and applies visualization techniques that is easily comprehended and simplified for non-technical stakeholder audiences.     
• Supports the Community of Practice by a) acts as evangelist for Power BI utilization and benefits across the company, b) mentors and/or provides leadership to the Community of Practice members.  

Does this sound like you?
Click the “apply now” button and create an account (it should take about 30 seconds). We’re excited to hear from you! 


Posting closing date:  June 1, 2020 weeks @ 11:59 pm EST (Note, the competition may remain active until filled)


Job Requisition ID: 4705  

Primary Location: OttawaOntario  

Other Location(s):  

Security Requirement: Reliability Status 

Travel Requirement: Travel not required 


We sincerely thank all candidates for their interest, however, please note that only those applicants selected for further consideration will be contacted.
CMHC is an employer that values diversity and encourages the learning and use of both Canada's official languages. CMHC is committed to employment equity and actively encourages application from women, Indigenous people, persons with disabilities and visible minorities
*If selected for an interview or testing, please advise us if you require an accommodation.

Learn more below about CMHC and how we help Canadians meet their housing needs.