
Power BI Developer
Encorp Pacific (Canada) - Return-It
full-time
Posted on:
Location Type: Hybrid
Location: Burnaby • Canada
Visit company websiteExplore more
Salary
💰 CA$65,000 - CA$75,000 per year
About the role
- 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.
Requirements
- 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.
Benefits
- 3 weeks paid vacation
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Power BIDAXPower QuerySQLdata modelingAWS GlueETLAmazon SageMakerdata visualizationKPI development
Soft Skills
analytical skillsproblem-solving skillsattention to detailorganizational skillsself-directedproactivecollaborativecustomer-service mindsetcommunication skillsability to manage multiple priorities