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 an entry‑level 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 looking for someone to simply complete tickets. We are looking for a future senior engineer -someone who wants to learn how enterprise data platforms are built, operated, and scaled, and who is willing to do the hard work of understanding both the data and the business that depends on it.

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. Assist in building and testing data pipelines that convert holdings, transactions, and reference data from legacy platforms into Aladdin, including reconciliation and break resolution through parallel run.
• Data Integration. Help design and maintain system and vendor integrations into and out of Aladdin across order management, treasury, private markets, and market data providers.
• Data Platform. Contribute to the build‑out of our Snowflake‑based Integrated Data Platform using a medallion pattern, including data modelling, data quality controls, and lineage.
• Custom Solutions. Support the design and implementation of data capabilities 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 significant 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 behaviours must be preserved through the transition. That current‑state knowledge is a deliberate part of the role, not a distraction from it.

Adaptability and curiosity are the single most important attributes here. You should expect to move between delivery areas as priorities shift, and you should be excited by the opportunity to learn across the entire investment data lifecycle-not just one narrow silo.

What You Will Own (with Mentorship and Support)

Analysis and Requirements (Foundation Building)

Work alongside senior data engineers and business analysts to understand business and data requirements. You will learn to read and interpret business requirements documents, user stories, acceptance criteria, business process models, data flow diagrams, and source‑to‑target mapping specifications.

Perform hands‑on data analysis under guidance. You will query source and target systems to profile data, investigate reconciliation breaks, validate transformations, and prove that what was built is correct-learning to do this independently over time.

Participate in design sessions and workshops with investment, operations, risk, performance, and finance stakeholders, and learn how to translate between business intent and technical design in both directions.

Capability and Solution Ownership (Growing into It)

Own a small data capability end‑to‑end with close mentorship. You will help define the problem, shape the solution with engineers and architects, see it into production, and stay accountable for whether it works.

Learn to turn multiple similar‑looking requests into one extensible capability. Where stakeholders ask for a specific instrument or report, you will be expected to identify the underlying capability gap and design for the general case-so the next request is an extension, not a new build-with coaching from senior team members.

Design for operability from day one. Every capability you deliver must have a defined support model, monitoring, controls, and documentation so it can be run by an operations team rather than remaining with the engineers who built it. You will learn how to build these from senior enginee