Data Engineer - Power BI & Azure Data Pipelines

Delta Power Equipment Ltd.; St. Marys; On-site; CAD 85,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

GRSP

Extended health benefits

Real projects across 16 locations

Modern data stack

Job summary

Delta Power Equipment Ltd. is hiring a full-time Data Engineer to build data pipelines, reports and automation across 16 locations. The role uses a modern Microsoft stack including Azure SQL, Power BI Service, Power Platform and Python.

You will create data models and reports, deploy and manage Power BI Report Server content, and support the Microsoft environment. Strong communication and document-writing skills are essential.

Qualifications

• 3+ years in data engineering, BI development or a similar role.
• Strong SQL (T-SQL): tables, views, joins and performance tuning.
• Python for data work: database connections, data transformation, REST APIs.
• Power BI: data modelling, DAX, Power Query, and building/publishing .pbix reports.
• Experience with Microsoft Azure and Microsoft 365.
• Git or another version control tool.
• You document your work and explain technical topics in plain language.

Responsibilities

• Build and maintain data pipelines moving data from the dealer management system into Azure SQL.
• Write SQL tables and views feeding company reporting.
• Build Power BI data models, DAX measures, reports and publish to Service/Report Server.
• Run on-premises Power BI Report Server: deploy reports, manage data sources and scheduling.
• Build Power Automate flows and Power Apps to cut manual work across departments.
• Write Python scripts for data loads and automation with PyCharm.
• Keep scripts, SQL, and reports in Git/Azure DevOps with change control.
• Provide escalation support for Microsoft environment (~20% of time).
• Document runbooks, data dictionary and how-to guides.

Skills

SQL (T-SQL)

Python

Power BI

Azure

Communication

Documentation

Education

Diploma or degree in computer science / IT / data or related field

Tools

Git

Job description

Delta Power Equipment Ltd. is hiring a full-time Data Engineer to build data pipelines, reports and automation across 16 locations. The role uses a modern Microsoft stack including Azure SQL, Power BI Service, Power Platform and Python.

You will create data models and reports, deploy and manage Power BI Report Server content, and support the Microsoft environment. Strong communication and document-writing skills are essential.