Data Engineer

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

Location: Exeter, St. Marys or Watford, ON

Delta Power Equipment is hiring a full-time Data Engineer to build the data pipelines, reports and automation our 16 locations run on. You'll turn ideas into working tools. Your work reaches every department, from Parts and Service to Sales and Accounting.

We work on a modern Microsoft stack: Azure SQL, Power BI (Service and on-premises Report Server), Power Platform and Python.

SUMMARY OF POSITION:

• Build and maintain data pipelines that move data from our dealer management system into our Azure SQL database
• Write SQL tables and views that feed reporting across the company
• Build Power BI data models, DAX measures and reports (.pbix), and publish them to Power BI Service and Power BI Report Server
• Run our on-premises Power BI Report Server: deploy reports, manage data sources, scheduled refresh, subscriptions and folder security for front-line staff
• Build Power Automate flows and Power Apps that cut manual work in Service, Parts, Sales and Accounting
• Write Python scripts for data loads, integrations and automation, developed in PyCharm
• Keep scripts, SQL and report files in version control (Git / Azure DevOps) and follow our change process
• Support our Microsoft environment (Active Directory / Entra ID, Windows Server, Microsoft 365) as the escalation point for our support team, about 20% of your time
• Document what you build: runbooks, a data dictionary and how-to guides .

WHAT WE ARE LOOKING FOR:

• 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 and 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
• Diploma or degree in computer science, IT, data or a related field, or equivalent experience
• Excellent communication skills and ability to work independently

WHAT WE OFFER:

• Competitive compensation ($85,000.00-$115,000.00)
• Group Registered Retirement Savings Plan (GRSP)
• Extended health benefits
• Real projects with visible results across 16 locations
• A modern Microsoft data stack and room to learn new tools

Delta Power Equipment is an equal opportunity employer and will make accommodations available, upon request, throughout the entire recruitment process.