Data Engineer

CIPS; City of Leduc; On-site; CAD 92,000 - 115,000; Full time

Benefits offered by this job

Health and dental benefits

Pension (LAPP)

Work-life balance

Professional development

EFAP + recreation pass

Job summary

The City of Leduc is seeking a Data Engineer to design, build, and maintain the central data platform hosted on Microsoft Fabric. You will develop data pipelines, implement governance, and enable enterprise analytics with Power BI across 100+ applications.

You will collaborate with GIS, IT teams, and business stakeholders to ensure data accuracy, security, and scalable analytics. A strong foundation in SQL, Azure data services, and modern data architectures is essential.

Qualifications

• A bachelor/Bachelor's degree or two-year post-secondary diploma in Computer Science, Data Engineering, Information Systems, or related discipline.
• A minimum of three years of professional experience building data pipelines, ETL/ELT workflows, and integrations across disparate source systems, including SQL databases and REST APIs.
• Hands-on experience with modern cloud data platforms, such as Microsoft Fabric, Azure Data Factory, Azure Synapse, or comparable enterprise architectures.
• Strong SQL proficiency and experience with dimensional modelling, layered data storage patterns, and data transformation using SQL and Python/PySpark/notebooks/Dataflows.
• Working knowledge of cloud security and identity-based access models, including Microsoft Entra ID.
• Clear, proactive communication skills and documentation habits.
• Experience with Power BI semantic models and data governance tools is a plus.

Responsibilities

• Design, build, and maintain data pipelines and integration workflows using Microsoft Fabric components to ingest data from relational SQL databases, APIs, and flat files.
• Build, maintain, and evolve the Microsoft Fabric Lakehouse with Bronze/Silver/Gold architecture for enterprise analytics.
• Develop analytics-ready data models and support Power BI semantic models with proper relationships and security.
• Implement data governance and security controls using Purview and Entra ID.
• Monitor and troubleshoot automated data workflows and resolve data quality issues.
• Collaborate with cross-departmental stakeholders to deliver production-ready datasets.
• Establish and improve engineering practices: version control, testing, deployment, recovery, monitoring, and documentation.
• Provide guidance to analysts on trusted datasets and semantic models.

Skills

Data pipelines

ETL/ELT

SQL

Microsoft Fabric

Azure Data Factory

Azure Synapse

APIs

Python/PySpark

Data governance

Data modeling

Education

Bachelor's degree or diploma in CS/IS/Data Engineering

Tools

Microsoft Purview

Microsoft Entra ID

Power BI

Job description

Data Engineer

Permanent, full-time (35 hours/week)

$92,274.00 - $115,333.40 per annum

At the City of Leduc, our mission is Building a connected community for all people. 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.

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 production-ready datasets that solve operational challenges.
• Help establish and continuously improve foundational engineering practices, including version control, testing, deployment processes, recovery procedures, monitoring, and system documentation.
• Provide technical guidance to analysts and approved departmental report developers on the effective use of trusted datasets and semantic models, contributing to broader data literacy across the organization.

What do you bring?

You are an analytical, collaborative problem-solver who combines technical data engineering expertise with the ability to communicate effectively with both technical teams and non-technical business partners. You bring:

• A bachelor's degree or two-year post-secondary diploma in Computer Science, Data Engineering, Information Systems, or a related discipline; an equivalent combination of elevant education, certifications, and progressive technical experience may be considered.
• A minimum of three years of professional experience building data pipelines, ETL/ELT workflows, and integrations across disparate source systems, including SQL databases and REST APIs.
• Hands-on experience with modern cloud data platforms, such as Microsoft Fabric, Azure Data Factory, Azure Synapse, or comparable enterprise architectures.
• Strong SQL proficiency and practical experience with dimensional modelling, layered data storage patterns, and data transformation using SQL and one or more modern transformation technologies such as Python, PySpark, notebooks, or dataflows.
• Working knowledge of cloud security and identity-based access models, including Microsoft Entra ID, role-based access, and row-level security.
• Clear, proactive communication skills with the ability to listen actively, gather business requirements, and explain complex data concepts in simple, accessible language.
• High attention to detail and structured documentation habits to support maintainability, data lineage, and operational recovery.

Direct experience developing Power BI semantic models, including relationships, DAX measures, Power Query, performance optimisation, and row-level security; exposure to Microsoft Purview or enterprise data governance tools; Microsoft certifications such as DP-600 or DP-700; or experience working with spatial data and FME workflows will be considered strong assets.

What we Offer?

Joining our Corporate Information Technology team means entering a progressive, supportive environment where your technical contributions directly influence municipal modernization. In this role, we offer:

• Comprehensive Health and Dental Benefits from day one to support the well-being of you and your family.
• Participation in the Local Authorities Pension Plan (LAPP), ensuring secure, long-term retirement benefits.
• A workplace culture that genuinely values work-life balance through flexible thinking, sustainable workloads, and respectful teamwork.
• A competitive municipal compensation package with opportunities for ongoing professional development and technical certification support.
• Support for your health and wellness through our Employee and Family Assistance Program (EFAP) and a free annual pass to City of Leduc recreation facilities.

Important Notes!

• The successful candidate must provide a current Criminal Record Check at their own expense.
• Please submit a cover letter detailing your experience with modern data platforms, specifically Microsoft Fabric or Azure environments, pipeline engineering, and data modelling.

Ready to Join Us?

If you are an experienced data professional ready to build modern data capabilities for an innovative municipal organization, we want to hear from you.

Competition closes at 11:59 pm (MT) on October 7, 2026. Due to the high volume of resumes received, we are not able to respond to individual phone calls. This competition may be used to fill future vacancies at the same or lower classification level. We thank all applicants for their interest, however, only those selected for interviews will be contacted.

At the City of Leduc, we are committed to a workplace where diversity is valued, inclusion is intentional, and everyone feels a sense of belonging. We welcome applications from all qualified individuals and recognize the diverse backgrounds, perspectives, and experiences that strengthen our team. If you require assistance or accommodation during the recruitment process, please contact us at [e-mail].

Recruitment Privacy Notice

The personal information you provide through the recruitment process, including your application, resume, assessment material, reference information, is collected and used to assess your qualifications and suitability for employment with the City of Leduc. Should your application be selected for employment with the City, this information will become part of your employment file and will support hiring, onboarding activities and the administration and management of employment programs.

Your personal information will be accessed and disclosed only as authorized or required by law and may be shared with authorized City employees, hiring managers and service providers as necessary to administer recruitment and employment-related activities.

Information is collected in accordance with section 4(c) of the Protection of Privacy Act and may be subject to disclosure and access in accordance with the Access to Information Act. For information regarding the collection, use, and disclosure of information, you may contact the City’s Privacy Officer at [phone], #1 Alexandra Park, Leduc, AB, T9E 4C4.