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.
Location: HybridLocated 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.
#LI-HYBRID 
