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

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 engineers.

Define and execute business test plans, including integration, performance, and regression testing. Participate in defect triage, root‑cause analysis, and resolution across environments.

Write requirements and acceptance criteria that engineers build against and that vendors are held to, and review systems integrator deliverables against those criteria. Identify gaps and escalate where quality or completeness falls short—you will learn to do this with guidance.

Operate across both Agile and waterfall delivery models, and keep scope, deliverables, and timelines clearly documented and communicated.

Build a working understanding of the current investment data and platform environment, including the processes, calculations, and downstream consumers they support, and use that understanding to define what must be replicated, improved, or retired in the target state.

Support the current environment where doing so builds transition knowledge, including investigating data issues, tracing lineage through existing systems, and validating that behaviour is preserved through migration.

Become a subject‑matter expert on the platforms in your area across both current and target state over time, and be someone the business and delivery teams come to for how the data actually behaves—with senior team members backing you up.

Build and maintain data documentation including data dictionaries, lineage, metadata, and knowledge‑base articles. Institutional knowledge that lives only in one person's head is treated as a defect—and you will be expected to document everything you touch.

Certification. CBAP or CFA certification is an asset but is not a substitute for demonstrated delivery. For a new graduate, any cloud certification (Azure, Snowflake) or data‑related certification is a plus.

Communication. You can hold your own with a portfolio manager, an operations lead, and a data engineer in the same conversation—or you are eager to learn how. You write clearly enough that your requirements survive without you in the room.

Extracurricular. Leadership in student organizations, hackathon participation, tutoring, or open‑source contributions.

You have taken ownership of at least one small data capability or pipeline component, and stakeholders know your name—you are no longer just "the new grad."

You have contributed to at least one set of related requests that was consolidated into a single reusable solution instead of several point builds, with your senior team members' mentorship.

Anything you have delivered has a documented support model and can be operated without you—because you learned how to build operability from day one.

You can independently investigate a data discrepancy end‑to‑end, from the business question through to the source system, with minimal escalation—or you know exactly who to ask and what questions to ask when you get stuck.

You have built a working understanding of at least one investment data domain (positions, transactions, order lifecycle, performance, or accounting) and can explain it to a non‑technical stakeholder.

You have become the go‑to person on the team for at least one tool or technology (e.g., SQL optimisation, Python testing, documentation, or lineage tracking).

Mentorship. You will be paired with a senior data engineer who will guide you through your first projects, review your code, and help you grow into an independent contributor.

Real ownership. This is not a "shadowing" role. You will own real deliverables from week one—with the support you need to succeed.

Exposure to the full investment data lifecycle. You will work across conversion, integration, platform, and custom solutions—not just one narrow area.

Fast‑paced, high‑impact environment. What you build will be used by portfolio managers, traders, and operations teams. You will see your work in production quickly.

Path to senior. This is a contract role with extension and conversion potential. If you perform well, we will invest in your growth and you will have a clear path to a permanent Senior Data Engineer role over time.

You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans – details on these elements of compensation are included within OMERS & Oxford offer letters.

As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work — and the members we proudly serve.

From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. 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 programs.

Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision-making remain central to our candidate experience.