BI Report Developer

Canadian Nuclear Laboratories LTD • Chalk River, ON

1d • Hybrid

About The Position

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!

Requirements

• 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.
• 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).
• 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.”

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree