Power BI Developer

Organization: Encorp Pacific (Canada)

Location: Burnaby, BC (Hybrid)

Job Title: Power BI Developer

Position Type: Full-Time (12-Month Contract)

About Us

Encorp Pacific (Canada), better known as Return-It, is a British Columbia based federally incorporated, not-for-profit, product stewardship corporation with beverage container management as our core business. Our mandate is to develop, manage and improve systems to recover used beverage containers and end-of-life products from consumers and ensure that they are properly recycled and not land-filled or incinerated. Encorp's evolving collection network consists of 180+ Return-It collection locations across BC.

Job Overview

Encorp is seeking a skilled and results-driven Power BI Developer (Contract) to support data visualization, reporting modernization, and business intelligence initiatives across Operations, Finance, Logistics, and Corporate Services.

Reporting to the Director of IT, the successful candidate will be responsible for designing, developing, and optimizing Power BI dashboards and reports, transforming complex data into meaningful insights that support operational and strategic decision-making. This role requires strong technical expertise in Power BI, data modeling, and stakeholder collaboration, along with the ability to translate business requirements into scalable reporting solutions. Your work will directly contribute to improved transparency, operational performance monitoring, and data-driven decision-making across Encorp’s province-wide recycling network.

This is a full-time, 12-month contract position.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports to support stakeholders across Operations, Finance, Logistics, and Executive leadership.
• Build and optimize robust data models using Power Query, DAX, and relational data modeling best practices.
• Connect to, extract, and transform data from SQL Server and a variety of structured and unstructured data sources.
• Integrate data from multiple systems, including CRM platforms, financial systems, SQL and MongoDB databases, Excel, and SharePoint.
• Write, optimize, and maintain SQL queries, views, and stored procedures to support reporting and analytics needs.
• Support and maintain data pipelines using AWS Glue to ensure reliable data preparation and delivery.
• Work with and interpret outputs from Amazon SageMaker and other machine learning models for reporting insights.
• Ensure data accuracy, integrity, and consistency across all reporting environments.
• Monitor and optimize dataset and report performance to ensure scalability and usability.
• Develop and maintain clear documentation for data models, dashboards, and reporting standards.
• Provide training, guidance, and ongoing support to internal users on Power BI tools and reporting solutions.

*Duties may evolve in response to organizational priorities.

Key Qualifications and Competencies

• Advanced proficiency in Power BI, including DAX, Power Query (M), and data modeling.
• Strong understanding of data visualization best practices and KPI development.
• Experience integrating data from multiple enterprise systems (CRM, ERP, financial systems).
• Hands-on experience with AWS Glue for building or supporting ETL and data preparation pipelines.
• Understanding of machine learning concepts and how model results are used in reporting and decision-making.
• Experience with Amazon SageMaker outputs and workflows is a strong asset.
• Experience or familiarity with machine learning techniques for data analysis, pattern recognition, and predictive insights is considered an asset.
• Strong analytical and problem-solving skills with high attention to detail.
• Strong organizational skills and ability to manage multiple priorities in a deadline-driven environment.
• Self-directed, proactive, and able to work independently.
• Collaborative team player with a customer-service mindset.
• Excellent communication skills with the ability to explain technical concepts to non-technical users.
• Interest in sustainability and environmental initiatives is an asset.

Education & Experience

• 3–5+ years of experience developing Power BI dashboards and reports in a business environment.
• Post-secondary education in Information Systems, Computer Science, Data Analytics, Business Intelligence, or a related field (or equivalent practical experience).
• Experience working with SQL and relational databases.
• Experience working with large or complex data sets and multiple data sources.
• Experience integrating and working across enterprise data environments