OMERS
Data Engineer
Toronto, Ontario
Sponsorship not specified$72k-$108kDetected 42 days ago
PythonData StructuresGitSQLAzureCI/CDData EngineeringData VisualizationRecruitingHRISCollaboration
About the role
- Choose a workplace that empowers your impact.
- Join a global workplace where employees thrive.
- One that embraces diversity of thought, expertise and passion.
Responsibilities
- Design, build, and maintain end‑to‑end data pipelines using Microsoft Fabric (Data Pipelines, Lakehouse/Warehouse, Notebooks) and, where appropriate, Azure Data Factory patterns.
- Implement scalable data transformations aligned to a Medallion architecture, producing curated, analytics‑ready datasets.
- Support environment separation (Dev / UAT / Prod), Git‑enabled development, and CI/CD‑style deployment practices.
- PDFs, scanned documents, reports, agreements, and attachments
- Enable document understanding pipelines that support:
- Document classification and attribute extraction
- Integrate unstructured data outputs with structured datasets to create a unified, trusted analytical view.
- Design solutions with strong auditability, traceability, and exception handling, ensuring confidence in downstream insights.
- Translate business questions into well‑designed data structures that support analysis, comparison, and trend detection.
- Create curated datasets and models optimized for Power BI, semantic models, and AI consumption.
Requirements
- 4-7+ years of experience in data engineering or analytics engineering roles.
- Hands‑on experience with Microsoft Fabric and/or strong background in Azure Data Factory / Azure data platforms, with the ability to apply those skills in a Fabric‑first environment.
- Text extraction (including OCR where required)
Nice to have
- Deep hands‑on experience with Microsoft Fabric Lakehouse, Warehouse, Notebooks, and Pipelines.
- Experience with Git‑based development and CI/CD practices for data platforms.
- Experience working within enterprise governance, security, and compliance constraints.
- What Success Looks Like
- Reliable, well‑monitored data pipelines supporting both structured and unstructured sources.
- High‑trust, insight‑ready datasets that consistently power analytics and AI use cases.
- Clear, auditable data flows that enable confidence in decision‑making.
- Reusable patterns and documentation that help teams scale without friction.
Skills
- Strong SQL for transformation, modeling, and performance optimization.
- Strong Python experience (PySpark preferred).
- Proven experience implementing Medallion‑style data architectures for analytics.
- Experience delivering production‑grade, reliable, and maintainable data pipelines.
- Unstructured Data Experience (Must Have)
Compensation
- The expected salary range for this position is $72,000.00 - $108,000.00 per year.
Company info
- Our people-first culture is at its best when our workforce reflects the communities where we live and work - and the customers we proudly serve.
- From hire to retire, we are an
Equal opportunity
- equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience.
Visa & Work Authorization
- This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition p
This listing is sourced directly from OMERS's careers page and normalized into a canonical job model.