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.
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.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.