Data Engineer, Finance Data

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.

We’d be thrilled to have you join our team as we set up our Capital Markets Finance Data team for new and continued success! We’ll focus equally on expertise and excellence, paired with culture and community. We will serve OMERS teams primarily in Capital Markets, Total Portfolio Management, and the Corporate function through understanding their needs, delivering against their expectations, and contributing our proficiencies – to achieve collective wins. This role joins a team on a journey, with much future potential in a global, sophisticated, complex enterprise.

Scope of Position: Support investment teams by enabling robust and reliable investment data, analytics, and reporting through investment technology and change management at one of Canada’s largest pension funds having assets exceeding $120 Billion.

Responsibilities:

• Design, develop, and help maintain data assets to extract, transform, and load data from various data files, APIs, and databases, and to make them accessible to various client-facing applications as well as investment data warehouse and internal tools
• Implement data strategies that prepare, transform, combine and manage structured and unstructured data (e.g. internal investment accounting systems as well as external third-party investment feeds) to integrate the data into an investment data warehouse and BI solutions
• Develop and operate highly scalable data pipelines and infrastructure that enable investment analytics, and investment reporting use cases
• Automate manual processes and optimize data delivery
• Utilize modern technologies for designing and building data solutions to meet business needs
• Partner with business analysts and reporting analysts to develop reports and PowerBI dashboards
• Support and troubleshoot existing investment data applications and BI reporting solutions as needed
• Work as part of a cross-functional agile team responsible for end-to-end delivery of business needs
• Collaborate and work effectively with business analysts and reporting analysts team members, and other investment professionals and leaders in solutioning and support

Qualifications:

• Track of record working in a fast-paced environment and multi-faceted role that intersects with business and technical analysts to support existing solutions, solution delivery, and contributions as a project resource for investment system implementations and upgrades
• Strong experience with data management, investment systems, business intelligence, and other reporting technologies
• Experience with Microsoft based BI/ETL tools (e.g. SQL Server, SSRS, SSIS, data factory or similar
• Experience with Cloud based data and analytics platforms (e.g. Snowflake, DataBricks, Azure Synapse)
• Deep proficiency in SQL, Python, and similar languages
• Good understanding of investment products
• Demonstrated ability to handle multiple projects and tasks at the same time to support daily production issues
• Critical thinking skills with the ability to independently solve problems with data and/or reference documents
• Investment data modeling experience using the Kimball method is an asset
• Experience with BNY Eagle PACE, Calypso, and Charles River is an asset
• Data governance experience is an asset
• Bachelor’s or master’s degree in Computer Science, Engineering, Finance, or a related field

And you demonstrate:

• A people-first focus with a desire to develop meaningful, positive relationships across all levels of the organization
• A teammate mentality coupled with servant leadership
• A sense of urgency, optimism, and a desire to deliver excellence
• A desire to drive debate, to speak candidly, and to listen empathetically
• Strong orientation towards strategy, change, and results
• A continuous improvement mindset

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.