Data Engineer

Data Engineer

$96,000 - $110,000

Position Overview:

Ontario One Call is seeking a Data Engineer to support the Data Engineering and AI Enablement team in building, operating, and continuously improving reliable data pipelines and analytics foundations.

This role is hands-on and delivery focused. The Data Engineer designs and implements data pipelines, transformations, and data quality controls using Microsoft Fabric, SQL, and Python to support enterprise reporting, operational analytics, and data-driven decision-making.

The successful candidate demonstrates solid engineering fundamentals, attention to detail, and the ability to collaborate effectively with peers and stakeholders. The role works with guidance from the Manager and Senior Data Engineers, escalating risks and issues appropriately while contributing to reliable and auditable data operations.

This position is located at the Guelph office located at 104 Cooper Drive, Guelph. Ontario One Call has a hybrid work model with staff dividing their workweek between in-office and at-home work per company policy.

Candidates must be able to reliably commute to the workplace during scheduled hours. Either valid driver’s license or access to reliable transportation are required.

Primary Responsibilities

• Implement data pipelines, transformations, and curated datasets in Microsoft Fabric in alignment with approved enterprise architecture patterns and standards defined by the Senior Data & AI Architect.
• Translate architectural designs, data models, and technical standards into working, production ready implementations across ingestion, transformation, and serving layers.
• Build and maintain batch (and where applicable, near real time) data workflows using Fabric Lakehouse, Data Factory, Dataflows Gen2, and notebooks, ensuring consistency with enterprise integration principles.
• Develop SQL based transformations and data models that adhere to defined dimensional modeling standards (facts, dimensions, KPIs) and support analytics, reporting, and downstream AI use cases.
• Implement Python based data engineering logic for ingestion, validation, automation, and pipeline orchestration, following established coding and deployment standards.
• Apply and operationalize data quality, validation, and observability controls (e.g., reconciliation checks, logging, exception handling) in line with enterprise data governance and compliance expectations.
• Monitor and support pipeline executions, investigate failures or data quality issues, and escalate systemic or recurring risks to the Manager and Senior Data & AI Architect with clear technical context.
• Support implementation of semantic models and curated datasets used by Power BI and analytics teams, ensuring KPI logic and metric definitions are implemented consistently.
• Contribute to technical documentation, lineage notes, and operational runbooks, supporting audit readiness, knowledge transfer, and long term platform sustainability.
• Collaborate closely with the Senior Data & AI Architect, Manager, Data Analysts, and stakeholders during sprint planning and delivery to ensure solutions meet architectural intent, delivery timelines, and business requirements.
• Identify opportunities for incremental improvement in pipeline reliability, performance, and maintainability, and provide implementation level feedback to inform architectural and platform evolution.

For more information about this position, and to apply, please visit our website:

https://ontarioonecall.ca/about-us/careers/