Senior Data Engineer, Data Integration & Performance Platform (12-Month Contract)

Choose a workplace that empowers your impact. Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be — and deliver — your best. We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe.

We embody the values of our 665,000 members, placing their best interests at the heart of everything we do. Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work. Don’t just work anywhere — come build tomorrow together with us. Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first.

Then, watch for a unique link in your email to apply. This is a senior engineering role on a multi‑year investment platform transformation that is replacing our core investment book of record with BlackRock Aladdin and building a new cloud data platform on Snowflake. We are not staffing a ticket‑taking function. We are building a data capability that has to run reliably, scale efficiently, and remain operable long after go‑live.

You will sit inside the Investment Finance and Operations Platforms group and work across four delivery areas. The program is fast‑moving and priorities shift, so you should expect to move between these areas as the work demands: Conversion. Build and run data pipelines that convert holdings, transactions, and reference data from legacy platforms into Aladdin, including reconciliation logic and break resolution through parallel run.

Data Integration. Design and maintain system and vendor integrations into and out of Aladdin across order management, treasury, private markets, and market data providers. Data Platform. Own the build‑out of our Snowflake‑based Integrated Data Platform using a medallion pattern, including data modelling, pipeline orchestration, data quality controls, and end‑to‑end lineage. Custom Solutions. Engineer data services and APIs that close gaps between Aladdin native functionality and what our investment, risk, performance, and finance teams require.

This team also operates the current production investment data platforms, spanning performance, accounting, order management, and integration. You will spend time working in that environment, because you cannot design the target state without understanding what today’s platforms actually do, which business processes depend on them, and which data behaviours must be preserved through the transition.

That current‑state knowledge is a deliberate part of the role, not a distraction from it. Adaptability is the single most important attribute here, and you should expect to move between delivery areas as priorities shift. What You Will Own Data Engineering and Pipeline Development Design, build, and maintain robust, high‑performance data pipelines using  ELT/ETL patterns  – incremental loading, change data capture, historisation, and idempotent replay – to ingest, transform, and serve data from source systems (Aladdin, legacy platforms, vendors) into Snowflake.

Implement  medallion architecture  (bronze/silver/gold) with clear separation of raw, conformed, and business‑ready layers, ensuring data quality checks are embedded at each stage. Write production‑grade  SQL  and  Python/PySpark  code; optimise query performance, partition strategies, and warehouse sizing for cost and speed. Own the  orchestration layer  (e.g., Prefect, Azure Data Factory, or comparable tools) – schedule, monitor, retry, and alert on pipeline failures with clear SLIs and SLOs.

Data Modelling and Architecture Partner with architects and business analysts to translate business requirements into  relational and dimensional data models  that support investment analytic