Technical Advisor, Application Development

Discover the possible

Anything is possible at the NRC, named in 2026 one of Canada’s Top Employers for Young People, Top Employer in the National Capital Region and Forbes Canada’s Best Employers!

As Canada’s largest research and innovation organization, our world-renowned research pushes the boundaries of science and engineering to make the impossible, possible. Every day we explore new ideas through innovative research and help companies discover possibilities that impact Canada’s future and the world.

At the NRC, you’ll also discover new possibilities. Our supportive workplace fosters a culture of creativity, welcoming fresh perspectives and innovation at all levels. We value teamwork. You’ll collaborate across multiple fields and with the brightest minds to find creative solutions. Most importantly, you’ll discover what’s possible within you as you grow, make valuable contributions and progress in your professional journey. From ground-breaking discoveries to a life-changing career, discover your possible at the NRC.

The role

We are looking for a Technical Advisor, Application Development to support our Chief Information Officer Branch (CIOB). The Technical Advisor, Application Development would be someone who shares our core values of Integrity, Excellence, Respect and Creativity.

If you love data, then we need you! We have 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, Microsoft Portals, MS Power BI) with various third-party add-ons.

We are looking to hire a Technical Advisor that brings an enthusiasm for building Business Intelligence (BI) solutions that are forward thinking with considerations for re-use, maintainability and extensibility. The incumbent is someone to provide expert advice, research, analysis, development and design of BI applications and related strategies.

Key activities:

• Provide specialized advice to internal project teams and work units on technical solutions and standards to adapt and support the design, development, testing, implementation, integration, maintenance and support of BI solutions;
• Advise and guide business clients on technical applications issues, and provides expertise and analysis to facilitate client understanding, involvement and acceptance of the design, development, testing and delivery, installation, integration and maintenance of BI applications;
• Conduct feasibility studies, develops and designs research, recommends various alternatives for BI applications development and presents options to support decision making and to address client requirements;
• Work with team to support data ingestion, transformation, data integration and data aggregations, providing technical expertise to BI developers and technical teams;
• Design, develop and support BI solutions within Microsoft Platform (SQL Server, Power BI, and Azure Data Platform) and associated technologies;
• Continuously evaluate and recommend new technologies and tools to improve data architecture, data management, and data integration processes.

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:

Education

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

Experience

• Minimum five (5) years of significant and recent experience conducting architectural evaluation, solution design, technical analysis, and providing technical advice within an enterprise Data Warehouse, Data Analytics, and Business Intelligence environment using the Microsoft technology stack;
• Experience designing, implementing, and supporting enterprise data and analytics solutions using the Microsoft Azure Data Platform and Microsoft Fabric, including technologies such as Azure Data Lake, Azure Data Factory, Azure SQL Database, OneLake, Lakehouse, Warehouse, Data Factory/Data Pipelines, and Dataflows Gen2;
• Experience providing technical and architectural advice for Microsoft Fabric adoption and implementation, including assessing existing data and analytics environments, defining target-state architecture, identifying modernization or migration opportunities, and recommending appropriate Fabric workloads and implementation approaches;
• Minimum two (2) years of recent experience designing and developing ETL/ELT, data ingestion, integration, transformation, and orchestration solutions, including scalable data pipelines using Microsoft Fabric and/or Azure data services;
• Experience designing, developing, and maintaining Power BI reports, dashboards, semantic models, and datasets, including experience with Power Query, Data Analysis Expressions (DAX), and integration with Microsoft Fabric;
• Experience with enterprise data architecture, data modelling, data governance, data quality, security, and access-control concepts within Microsoft Fabric, OneLake, Azure, and/or other enterprise data environments;
• Experience implementing or supporting CI/CD and source-control practices for data and analytics solutions using technologies such as Git/GitHub and Azure DevOps, including deployment practices for Microsoft Fabric, Power BI, and/or Azure data solutions;
• Experience working in an Agile environment, including the use of Azure DevOps for work-item management, technical documentation, source control, and collaboration with multidisciplinary business and technical teams;
• Experience working in a Technical Advisor, Technical Lead, Solution Architect, or similar senior technical capacity, including providing architectural guidance, conducting technical assessments, evaluating solution options, identifying technical risks and dependencies, and providing recommendations to technical teams, business stakeholders, and management.

Asset qualifications: experience and/or certification in Microsoft data and analytics technologies, with preference given to candidates possessing one or more of the following:
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600);
• Microsoft Certified: Fabric Data Engineer Associate (DP-700);
• Microsoft Certified: Power BI Data Analyst Associate (PL-300);
• Microsoft Azure Data Engineering certification or equivalent;
• Other relevant Microsoft certifications related to Microsoft Fabric, Azure Data Platform, Power BI, data engineering, data architecture or analytics.

Condition of employment

Reliability Status

For a Reliability Status, verification of background information over a period of 5 years is required.

Language requirements

English

Information on language requirements and self-assessment tests

Assessment criteria

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

Technical competencies

• Solid knowledge in designing and implementing enterprise-wide data warehouse infrastructure;
• Knowledge of Microsoft Power BI including administration, architecture and development;
• Knowledge of Azure Data Platform;
• Solid ability to write SQL queries.

Behavioural competencies

Competency Profile(s)

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

View all competency profiles

Compensation

From $103,911 to $130,061 per annum.

NRC employees enjoy a wide-range of competitive benefits including a robust pension plan, comprehensive health and dental coverage, disability and life insurance, office closure at the end of December, and additional supports to enhance your well-being throughout your career and beyond.

Notes

• In 2026, the NRC was chosen as one of Canada’s Top Employers for Young People, a National Capital Region Top Employer and Forbes Canada’s Best Employer.
• Relocation assistance will be determined in accordance with the NRC's directives.
• 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.