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


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 the NRC, we know that diversity enables excellence in research and innovation. We are committed to a diverse and representative workforce, a safe and respectful work environment, and contributing to a more inclusive Canadian innovation system.  We welcome all qualified applicants and encourage you to complete the employment equity self-declaration questions during the job application process.


Please let us know of any accommodation measures required to help you to be assessed in a fair and equitable manner. Please note that the information you provide will be treated 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:

  • Act as a Microsoft 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. Minimum 5 years of significant experience within the last 7 years conducting architectural evaluation, design and analysis with enterprise Data Warehouse/Business Intelligence solutions in Microsoft technology stack;
  2. Minimum 5 years of significant experience within the last 7 years in data management, data design and database architecture in an Agile environment.
  3. Minimum 2 years of significant experience within the last 5 years of experience creating reports, datasets, creating reports and dashboards using Power BI;
  4. Experience with Extract Transform Load (ETL) or Extract Load Transform (ELT) development.
  5. Experience writing complex SQL queries;
  6. 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.


  • 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.
  • A pre-qualified list may be established for similar positions for a one year period.
  • 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: 343-548-9537 

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.