Data Engineer, Finance Data

at  OMERS

Why join us?
Are you looking to join a dynamic pension plan that embodies the strong values of its 500,000 members and is an industry leading global investor? If so, we would love to tell you our story.
At OMERS we put our people first and are proud to embrace the diversity of thought and leadership that comes from having locations in Toronto, London, New York, Singapore, Sydney and other major cities across North America and Europe. Our culture is truly one of a kind. We get stuff done, and have fun doing it! We take great pride in contributing to the communities where we live with an ever-constant eye to the global investment markets.
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.

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

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