ETL jobs in Vancouver, BC

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.
• Experience working with cloud-based data platforms and services, including AWS.
• Demonstrated experience working with analytical, predictive, or machine learning–based datasets within AWS environments.
• Practical experience with data integration or ETL tools such as AWS Glue is considered a strong asset.
• Experience working in an Enterprise Data Warehouse environment (e.g., hybrid AWS and Azure data lakes) is a strong advantage.
• Experience working with MongoDB is a plus.
• Minimum of 3 years’ experience in software development is a plus.
• Minimum of 3 years’ experience in a business analyst role is a plus.
• Experience with Microsoft 365 environments, including SharePoint and Teams.
• Experience working in cross-functional environments with both technical and non-technical stakeholders.

Compensation

• Salary Range: $65,000 - $75,000 per year
• 3 weeks paid vacation

Work Schedule

• 12-month contract with possibility of extension
• 37.5 hours a week
• Monday – Friday 8am – 4pm
• In-office Monday – Wednesday and option to work from home Thursday – Friday

If you have any questions or concerns or if you require any reasonable accommodation during the recruitment process, feel free to send an email to encorprecruiting@returnit.ca.

At Encorp, we are dedicated to fostering a workplace that celebrates diversity and inclusion, where every voice is heard and valued. As we strive to make a positive impact on our natural environment, we believe that a diverse team brings forth fresh perspectives, innovative solutions, and a collective strength that enables us to achieve our mission of used beverage container and waste diversion. If you are passionate about sustainability, eager to lead a team in driving impactful change, and believe in the power of diversity, we invite you to apply for this important position to join our team. Together, we can create a more sustainable future while fostering an inclusive and empowering work environment. Apply today and be a part of our transformative journey at Encorp.