Back to jobs

BI Report Developer

Pay
Pay not listed
Work setting
Hybrid — work setting source
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.
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
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Design and develop Power BI reports, dashboards and datasets

  • Build data models with star schemas, DAX measures and KPIs

  • Extract and transform data from multiple sources using Power Query, SQL and dataflows

  • Publish BI assets in Power BI Service and manage refresh schedules

  • Provide second and third-tier support to resolve report and data issues

From the employer’s posting
Designing and developing Power BI reports, dashboards, and datasets to meet business needs
Developing and maintaining data models (e.g., star schemas), including creation of measures, KPIs, and calculated columns using DAX
Performing data extraction, transformation, and integration (ETL) from multiple data sources (e.g., SQL Server, Oracle, ERP systems) using Power Query, SQL, and dataflows.
Publishing and managing BI assets within Power BI Service, including workspace configuration, dataset refresh scheduling, and report distribution.
Providing second and third-tier support to diagnose and resolve BI report, data, and performance issues.

What you’ll bring

All qualifications

Core 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.
Qualification wording
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.
Apply at Cnlltd

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,020 similar postings that came down. Coming down is not always a hire.

Cnlltd is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Oracle
  • Power BI
  • Power Query
  • SQL Server
Where the posting names them
- 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.
- 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.
- 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.
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.
- 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.
- 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.
- 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.

Your next step

Complete your application on tre.tbe.taleo.net. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

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 Secretariat's “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 

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Location not supplied.

- 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).
More source context
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

More relevant text appears in the full description.

Work authorization
- 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 Secretariat's “Standard on Security Screening” and the “Policy on Government Security.” Working Conditions:

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.