About the role

Power BI Developer at Encorp Pacific (Canada) designing dashboards and optimizing reporting solutions. Contributing to data-driven decision-making for recycling initiatives across British Columbia.

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.

3–5+ years of experience developing Power BI dashboards and reports in a business environment
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
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.