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-b