Data Engineer

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 600,000+ members, placing their best interests at the heart of everything we do.

Join us to accelerate your growth & development, prioritize wellness, build connections, support the communities 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.

Why Join Us?

The Data Engineer will join a team, part of Software Engineering, that leads the delivery of the products and platforms that enable OMERS Global Investments (GI) to analyze opportunities, action investment decisions and optimize the OMERS investment portfolio. The Software Engineering team works across investment teams including Capital Markets, Infrastructure Investment, Private Equity, Growth Equity and Ventures, and in close collaboration with Finance, Risk & Compliance teams.

The Data Engineer is instrumental in improving data & analytics capabilities by championing industry best practices and delivering high quality data assets to support investment decision making.

The Data Engineer will operationalize and maintain data pipelines deployed to the OMERS investment entities and cultivate a business relationship that assists in meeting business demands. The individual must also support and collaborate with Power BI developers, data scientists and investment professionals and engage in technical support, research and integration as part of 1 or more project team(s).

As a member of this team, you will be responsible for:

Technical

· Translating requirements into solutions

· Defining and executing technical test plans, performing unit, performance and integration tests and automating regression tests

· Deploying ETL/ELT pipelines to achieve a high level of reliability, scalability and security

· Sourcing, transforming and delivering structured and unstructured assets for analytical use

· Optimizing performance of ETL pipelines and data sources

· Participating in solution build, delivery, support and troubleshooting

· Provisioning and managing Azure resources, including security and cost

· Monitoring pipelines. Improving reliability. Automating audit

Organizational

· Operating in an Agile development environment

· Communicating effectively with other engineers and various other partners such as product managers, data & business analysts, IT infrastructure specialists, security specialists, enterprise architects and members of senior management

· Leading change and communicating impacts to partners and fellow team members

· Identifying, defining and implementing opportunities for improving existing processes

· Exhibiting the ability to work on multiple projects simultaneously and ensuring timely delivery

· Participating in establishing sound data management practices for the team and the organization

· helping shape and scale the future of our development and production infrastructure

Qualifications:

Professional

· Experience. 3+ years solving sophisticated technical data projects using the Microsoft Azure data stack or equivalent work experience. Financial industry application is preferred.

· A Bachelor’s Degree in a scientific or engineering field of study or equivalent work experience

· Microsoft Data engineer associate level certificate will be considered as an asset

· Industry Knowledge of best practices. Previous experience in developing and deploying operational procedures, tuning guides and best practices documentation

· Relationship Building. Consistent track record of building deep technical relationships. Experience in aligning expectations across various partners

· Problem-Solving. The ability to trace data lineage / workflows and resolve technical issues with minimal direction

· Teamwork. Motivated and keen to work in a collaborative environment with a focus on team success

Technical

· Enterprise-scale technical experience with cloud and hybrid infrastructures, architecture designs, and technology management

· Experience with data architecture, modeling, data warehousing

· Breadth of technical experience and knowledge across the Azure Data Platform, with depth/Subject Matter Expertise in two or more of the following Data Platform resources:

o Azure Databricks, experience with Python

o Azure Functions and/or Web Apps using C#.Net or Python

o Azure SQL

o Azure Data Factory

· Proven experience automating CI/CD pipelines using GitHub Enterprise or equivalent work experience

· Experience with containerization and container deployment to Kubernetes

· Experience developing star schema reporting pipelines using Kimball or Data Vault v2.0 methodologies

We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 3 days per week. 

As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities 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.