Data Engineer

Department:

Manager, Data & Analytics

Hours Per Week:

35

Compensation Range:

$92,274.00 - $115,333.40

Closing Date:

September 25, 2026

Note: Posting comes off at 12:00 AM on Closing Date, with competition closing at 11:59 pm day prior.

Permanent, full-time (35 hours/week)

$92,274.00 - $115,333.40 per annum

At the City of Leduc, our mission is People. Building. Community. We offer a collaborative and dynamic workplace where our values of Teamwork, Service, Respect and Leadership guide our conduct and contribute to a healthy culture. If you would like to work as part of a progressive organization and enjoy a collaborative, complex, and evolving environment, then this may be the opportunity for you.

Come work with us!

At the City of Leduc, we are making intentional investments in modern technology and data maturity to better serve our growing municipality. With the recent establishment of our Data & Analytics division within Corporate Information Technology (CIT), we are transitioning from decentralized departmental reporting to a governed, modern data platform.

We are seeking a permanent, full-time Data Engineer to play a foundational role in building and evolving this platform. You will join an agile, collaborative team focused on establishing reliable data architecture from the ground up. If you are a technical professional who enjoys solving complex data integration challenges and translating raw data into meaningful analytics for decision-makers, we want to hear from you.

What is the Opportunity?

Reporting directly to the Manager, Data & Analytics, the Data Engineer is responsible for designing, building, and maintaining the City’s central data platform hosted on Microsoft Fabric. You will develop and operationalize data pipelines, integration processes, and Lakehouse structures that bring together information from more than 100 enterprise business applications.

In this role, you will connect hands-on data engineering with real-world business intelligence. Working closely with GIS and data analysts, CIT application teams, business stakeholders, and external technical partners, you will help ensure that organizational data is accurate, secure, reusable, and optimised for reporting. You will implement technical governance controls within the City’s established data governance framework, including identity-based access, data quality checks, lineage, cataloguing, and trusted semantic models that support dependable Power BI reporting.

What will you do?

In this pivotal platform-building role, you will shape our data architecture, pipeline reliability, and reporting capabilities. You will:

• Design, build, and maintain data pipelines and integration workflows using Microsoft Fabric components, including Data Factory and Dataflow Gen2, to ingest data from relational SQL databases, APIs, and flat files.

• Build, maintain, and evolve the Microsoft Fabric Lakehouse based on the City’s approved architecture and standards, implementing layered medallion architecture (Bronze, Silver, Gold) to support dependable, enterprise-wide analytics.

• Develop and optimize analytics-ready data models and support Power BI semantic models, including relationships, measures, performance considerations, and row-level security.

• Implement technical data governance and security controls using tools such as Microsoft Purview and Microsoft Entra ID, supporting the City’s standards for data lineage, cataloguing, classification, access, and permissions.

• Monitor and troubleshoot automated data workflows, applying root-cause analysis to resolve pipeline failures, address data quality discrepancies, and maintain operational continuity.

• Collaborate with cross-departmental stakeholders to understand business processes, clarify reporting requirements, and deliver