Job Description

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



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



As a key member of the Software Engineering team, 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 and general management.



The Data Engineer will operationalize and maintain data pipelines deployed to the OMERS investment entities and Corporate, 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 application 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 data 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 project 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 . 5+ years solving sophisticated technical data projects using the Microsoft Azure infrastructure 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



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 data platforms, with depth / Subject Matter Expertise in two or more of the following Data Platform resources:



Azure Data Factory and / or SSIS



Azure Databricks /Spark



Azure Functions and/or Web Apps using C#, PoSH or PythonPython



Azure SQL Database

Data Orchestration (ex.:

Prefect, Dagster, Airflow)



Snowflake



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



Experience with the Microsoft Power Platform is preferred



Experience with on-premise SQL Server Data ToolsExperience with containerization and container deployment to a container orchestration service



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