BI Report Developer

Are you looking for a role that combines data, analytics, and problem-solving to drive better business decisions? Can you see yourself transforming complex data into meaningful insights and interactive dashboards? If so, our Chalk River location is looking for a BI Report Developer to design and deliver Power BI reports, dashboards, and data visualization solutions that empower informed decision-making across the organization. Apply today and help turn data into insight!

What will you be doing!

Working independently on assigned tasks and contributes to team discussions on reporting requirements transforming functional and technical specifications into BI solutions.

Designing and developing Power BI reports, dashboards, and datasets to meet business needs, ensuring alignment with data architecture, security standards, and organizational policies.

Developing and maintaining data models (e.g., star schemas), including creation of measures, KPIs, and calculated columns using DAX, to ensure consistent and accurate reporting.

Performing data extraction, transformation, and integration (ETL) from multiple data sources (e.g., SQL Server, Oracle, ERP systems) using Power Query, SQL, and dataflows.

Working with existing database objects and queries (e.g., tables, views, stored procedures) to support reporting and analytics requirements.

Ensuring BI solutions adhere to best practices in data visualization, usability, accessibility, and performance optimization.

Publishing and managing BI assets within Power BI Service, including workspace configuration, dataset refresh scheduling, and report distribution.

Implementing and maintaining data security and governance controls, including row-level security (RLS), access management, and compliance with organizational standards.

Providing second and third-tier support to diagnose and resolve BI report, data, and performance issues.

Monitoring report usage, performance, and data refresh processes, and implementing improvements to ensure reliability and scalability of BI solutions.

Documenting solutions, troubleshooting steps, and known issues in the organization's knowledge base, supporting ongoing maintenance and user self-service.

Validating and reconciling data across multiple sources to ensure accuracy, completeness, and consistency of reporting outputs.

Preparing and executing test plans and test cases for BI solutions, including validation of data transformations, calculations, and visual outputs.

Documenting test results, identifies discrepancies, and works with stakeholders to resolve data quality or logic issues.

Other duties as assigned by your manager.

What we are looking for:

Education

Graduation from a recognized educational institution in computer science, computer programming, software engineering or graduation from an equivalent formal education program and relevant IT experience.

Experience

Minimum two years of recent experience in business intelligence and reporting development.

Experience designing and delivering reports and dashboards (e.g., Microsoft Power BI).

Experience with data transformation (ETL) and integrating data from multiple sources.

Experience working within structured delivery frameworks (e.g., Agile, Iterative).

Experience with data extraction, transformation, and integration (ETL) across multiple data sources (e.g., ERP systems, flat files, cloud platforms).

Knowledge, Skills & Abilities

Strong understanding of business intelligence concepts, data modelling (e.g., star/snowflake schemas), and data warehousing principles, with the ability to design scalable reporting solutions.

Proficiency in BI tools, including Microsoft Power BI (Desktop and Service), Power Query, and DAX, for developing dashboards and semantic models.

Advanced knowledge of SQL and relational databases (e.g., MS SQL Server, Oracle), including query development, optimization, and troubleshooting.

Knowledge of performance tuning and optimization techniques for reports, queries, and data models.

Knowledge of data governance, data quality, and security practices, including row-level security and access management.

Ability to analyze business requirements and translate them into technical BI solutions aligned with business objectives.

Strong analytical and problem-solving skills, including diagnosing data issues and delivering actionable insights.

Effective verbal and written communication skills, with the ability to convey technical information to diverse audiences.

Proven ability to collaborate with cross-functional teams, including business stakeholders and technical partners.

Ability to document BI solutions and data definitions to support transparency, maintainability, and knowledge transfer.

Familiarity with data integration and ETL processes, including extracting and transforming data from ERP systems and other enterprise applications.

Understanding of cloud-based data and analytics platforms (e.g., Microsoft Azure, Data Factory, Synapse Analytics) supporting modern BI solutions.

Understanding of data visualization standards and best practices, including usability, accessibility, and storytelling with data.

Awareness of BI performance optimization techniques, including query tuning, indexing, and efficient DAX and dataset design.

Understanding of data integration patterns and connectivity, including APIs, gateways, DirectQuery vs. Import, and hybrid architectures.

Ability to estimate effort and assess complexity for BI development activities (e.g., reporting, data modelling, data preparation).

Understanding of data and analytics architecture, including pipelines, staging, semantic, and consumption layers.

Familiarity with project management principles and delivery frameworks (e.g., Agile, Scrum) within BI lifecycles.

Commitment to staying current with BI tools, product updates, and emerging technologies, identifying opportunities for improvement.

Security Clearance Eligibility Required

Reliability Status with Site Access Security Clearance (SASC), which has a minimum requirement of 3-5 years of verifiable history in Canada, Australia, New Zealand, the United States and/or the United Kingdom. CNL implements security screening in accordance with the Treasury Board of Canada Secretariats "Standard on Security Screening" and the "Policy on Government Security."

Working Conditions:

Working schedule: Five (5) days per week, seven and a half (7.5) hours per day for a thirty-seven and a half (37.5) hour work week.

Why CNL?

Does the idea of working with a dynamic team across Canada to advance nuclear science and technology for a clean and secure world excite you? At CNL, we're reinventing ourselves to be industry leaders-pioneering solutions to the problems that matter most.

From building the next generation of clean nuclear and hydrogen energy technologies, to developing targeted cancer treatments, to continuing our global leadership in environmental remediation-we are driven by impact, innovation, and purpose.

What We Offer: A Total Rewards Package

We believe in taking care of our people. Here's what you can expect as part of our team:

Paid time off: vacation, sick, personal, and floater days

Benefits effective Day One - no waiting period

Tuition support to help you keep learning and growing

A defined-benefit pension plan or a defined-contribution pension plan, depending on your employee group, to support your long‑term financial security

Do Our Priorities Resonate with You?

Delivering clean energy for today and tomorrow

Restoring and protecting the environment

Contributing to the health of Canadians

If so, you'll feel right at home at CNL!

Location: Hybrid

Located in the heart of the Ottawa Valley, our Chalk River site offers a beautiful natural setting with forests, lakes, and wildlife right at your doorstep. Surrounding communities such as Deep River, Petawawa, and Pembroke provide access to excellent recreation and a great quality of life.

Please note: This is a hybrid position, with a combination of remote work and onsite presence at our Chalk River Laboratory, Ontario.

Our Commitment to Equity, Diversity & Inclusion

At CNL, we are committed to fostering an environment that promotes equity, diversity, and inclusion. We celebrate and welcome employees, stakeholders, and partners of all backgrounds and identities. Click here to read all about it!

We are proud to uphold a workplace culture grounded in our Core Values:

Respect

Teamwork

Accountability

Safety

Integrity

Excellence

These values drive our employment practices and ensure meaningful career development opportunities and accommodations for all employees.

CNL is an equal opportunity employer. If you require accommodation during any phase of the hiring process, please let us know via jobs@cnl.ca. All requests will be handled with confidentiality.

CNL operates on sites located on the traditional lands, waterways and ceded and unceded territories of Indigenous peoples. CNL recognizes and affirms all First Nations, Métis communities and Inuit in this land we now know as Canada. We acknowledge, respect and seek to better understand Indigenous history, rights and title on the lands where we work and develop projects. We honour and respect the importance of the relationship between Indigenous peoples and their lands, waters and territories. #LI-HYBRID