Share this job

Business Intelligence (BI) Technical Advisor

City: Ottawa; Within a National Research Council Office across Canada 

Organizational Unit: Knowledge, Information and Technology Services 

Classification: CS-3 

Tenure: Continuing 

Language Requirements: English


On October 6, 2021, the Government of Canada announced the launch of a mandatory vaccination policy across the federal public service.


The Policy on COVID-19 Vaccination for the National Research Council requires you to be fully vaccinated against COVID-19, and that you attest to your vaccination status prior to the date of your appointment unless accommodated based on a medical contraindication, religion, or another prohibited ground of discrimination as defined under the Canadian Human Rights Act.  You can find more specific information on the collection and use of your personal information when you submit your attestation.

The NRC Advantage

Great Minds. One Goal. Canada's Success.


The National Research Council of Canada (NRC) is the Government of Canada's largest research organization supporting industrial innovation, the advancement of knowledge and technology development. We collaborate with over 70 colleges, universities and hospitals annually, work with 800 companies on their projects, and provide advice or funding to over 8000 Small and Medium-sized Enterprises (SMEs) each year.


We bring together the brightest minds to deliver tangible impacts on the lives of Canadians and people around the world. And now, we want to partner with you.  Let your expertise and inspirations make an impact by joining the NRC.


At NRC, we know diversity enables excellence in research and innovation. We are committed to a diverse and representative workforce, an open and inclusive work environment, and contributing to a more inclusive Canadian innovation system. 


NRC welcomes all qualified applicants and encourages candidates to self-declare as members of the following designated employment equity groups: women, visible minorities, Aboriginal peoples and persons with disabilities.


Please advise of any accommodation measures required to enable you to be assessed in a fair and equitable manner. They are available to all candidates for further assessment. Related information received will be addressed confidentially.

Your Challenge

Help bring research to life and drive your career forward with the National Research Council of Canada (NRC), Canada's largest research and technology organization.


We are looking for a Business Intelligence (BI) Technical Advisor to support our Knowledge, Information and Technologies Services (KITS). The incumbent would be someone who shares our core values of Integrity, Excellence, Respect and Creativity.

If you love data, then we need you!  We are looking for a Business Intelligence Technical Advisor to join the Data warehouse/Business Intelligence team. We’ve embarked on a multi-year initiative to consolidate multiple Sales, Grants & Contributions, and traditional Case Management applications into one enterprise CRM solution. This solution leverages the Microsoft Platform (D365, Power Apps, and Power BI) with various third-party add-ons.

The activities are:

  • Be a MS Power BI SME;
  • Extend our data platform by researching and applying new data technologies and modern databases moving from SAP BO solution to interactive and paginated MS Power BI reports;
  • Work with the team to determine the best technical solution and development process;
  • Support the team on ETL/ELT/data integration;
  • Be a back-up for the BI Team Lead when needed;
  • Manage the MS Power BI data gateway, data flow and data set.

Screening Criteria

Applicants must demonstrate within the content of their application that they meet the following screening criteria in order to be given further consideration as candidates:


Minimum of bachelor degree in Computer Science from a recognized University or related field. An equivalent combination of education and direct experience may be considered.


For information on certificates and diplomas issued abroad, please see Degree equivalency


  1. Significant experience conducting architectural evaluation, design and analysis with enterprise Data Warehouse/Business Intelligence solutions in Microsoft technology stack;
  2. Significant experience in data management, data design and database architecture in an Agile environment.
  3. Experience creating reports and dashboards using Power BI;
  4. Experience with Power BI data modeling using DataFlow and DataSet;
  5. Experience with Extract Transform Load (ETL) or Extract Load Transform (ELT) development.
  6. Basic experience writing complex SQL queries;
  7. Asset Microsoft Certification: Data Analyst Associate or Azure Data Engineer Associate or MCSA: SQL 2016 BI Development or MCSE: Data Management and Analytics or MCSA: SQL 2016 Database Development

Condition of Employment

Reliability Status


All employees of the National Research Council are required to be fully vaccinated against COVID-19 and attest to their vaccination status unless accommodated based on a medical contraindication, religion, or another prohibited ground of discrimination as defined under the Canadian Human Rights Act.

Assessment Criteria

Candidates will be assessed on the basis of the following criteria:

Technical Competencies

  1. Solid knowledge of software development methodologies, such as Agile, Scrum and/or LEAN.
  2. Solid knowledge of Microsoft Power BI including architecture and development.
  3. Solid knowledge in designing and implementing enterprise-wide data warehouse infrastructure.
  4. Solid ability to research and analyse requirements and recommend solutions.
  5. Ability to write SQL queries.

Behavioural Competencies

  • Technology support - Communication (Level 3)
  • Technology support - Results orientation (Level 3)
  • Technology support - Conceptual and analytical ability (Level 2)
  • Technology support - Teamwork (Level 2)
  • Technology support - Client focus (Level 2)

Competency Profile(s)

For this position, the NRC will evaluate candidates using the following competency profile(s): Technology Support

View all competency profiles


Relocation assistance will be determined in accordance with the NRC's directives.


From $89,548 to $112,660 per annum. 

An incumbent occupying a position within the CS Group is currently entitled to receive a terminable allowance of $212 per month.


NRC employees enjoy a wide-range of competitive benefits including comprehensive health and dental plans, pension and insurance plans, vacation and other leave entitlements.


  • A pre-qualified list may be established for similar positions for a one year period.
  • This position is being advertised internally and externally simultaneously, however first consideration will be given to internal NRC applicants.
  • Preference will be given to Canadian Citizens and Permanent Residents of Canada. Please include citizenship information in your application.
  • The incumbent must adhere to safe workplace practices at all times.
  • We thank all those who apply, however only those selected for further consideration will be contacted.



Please direct your questions, with the requisition number (15512) to:


Telephone: 613-990-4498 

Closing Date: Posted until filled



For more information on career tools and other resources, check out Career tools and resources


*If you are currently a term or continuing employee at NRC, please apply through the SuccessFactors Careers module from your NRC computer.


Report a problem                                                Date modified: This page is updated continuously.