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.

Skills Required