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 technic