Power BI Developer

AXIATA DIGITAL ADVERTISING SDN BHD; Burnaby; On-site; CAD 65,000 - 75,000; Full time

Benefits offered by this job

3 weeks paid vacation

Hybrid work (Mon-Wed in-office; Thu-F人

Job summary

Encorp Pacific (Canada) is seeking a Power BI Developer (12-Month Contract) to design, develop, and optimize dashboards across Operations, Finance, Logistics, and Corporate Services. You will translate business requirements into scalable reporting solutions and collaborate with stakeholders to improve data-driven decision-making across BC's province-wide network.

The role emphasizes Power BI expertise, data modeling, and experience with SQL Server, AWS Glue, and various data sources.

Qualifications

• 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 related field.
• Experience working with SQL and relational databases.
• Experience with cloud-based data platforms and services, including AWS.
• Experience with MongoDB is a plus.
• Knowledge of machine learning concepts and how model results are used in reporting.
• Experience working with enterprise data environments and multiple data sources.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports for Operations, Finance, Logistics, and Executive leadership.
• Build and optimize data models using Power Query, DAX, and relational modeling best practices.
• Connect to and transform data from SQL Server and diverse data sources.
• Integrate data from CRM, ERP, financial systems, SQL and MongoDB databases, Excel, and SharePoint.
• Write and optimize SQL queries, views, and stored procedures for reporting needs.
• Support Data Pipelines using AWS Glue to ensure reliable data preparation and delivery.
• Work with outputs from Amazon SageMaker and other ML models for reporting insights.
• Ensure data accuracy, integrity, and consistency across reporting environments.
• Monitor and optimize dataset and report performance for scalability.
• Develop and maintain documentation for data models, dashboards, and standards.
• Provide training and ongoing support on Power BI tools.

Skills

Power BI

DAX

Power Query

Data modeling

SQL

Stakeholder collaboration

Data visualization

Machine learning concepts

Education

Post-secondary in Information Systems/CS/Data Analytics/BI

Tools

SQL Server

AWS Glue

MongoDB

SageMaker

SharePoint

Job description

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

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, together, we can create a more sustainable future while fostering an inclusive and empowering work environment.