Job Description

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\xe2\x80\x99d be thrilled to have you join our team as we set up our Capital Markets Finance Data team for new and continued success! We\xe2\x80\x99ll 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 \xe2\x80\x93 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\xe2\x80\x99s largest pension funds having assets exceeding $120 Billion.

Please note we have identified a preferred candidate for this specific role within OMERS/Oxford. However, we firmly believe in fostering talent from within our organization and promoting an environment of growth, inclusivity, and equal opportunity. We are committed to providing a fair and transparent process for everyone and encourage qualified internal candidates to apply.

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\xe2\x80\x99s or master\xe2\x80\x99s 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

Our story:

Founded in 1962, OMERS is one of Canada\xe2\x80\x99s largest defined benefit pension plans, with $127.4 billion in net assets as at June 30, 2023. OMERS is a jointly-sponsored pension plan, with more than 1,000 participating employers ranging from large cities to local agencies, and over half a million active, deferred and retired members. OMERS members include union and non-union employees of municipalities, school boards, local boards, transit systems, electrical utilities, emergency services and children\xe2\x80\x99s aid societies across Ontario. Contributions to the Plan are funded equally by members and employers. OMERS teams work in Toronto, London, New York, Amsterdam, Luxembourg, Singapore, Sydney and other major cities across North America and Europe \xe2\x80\x93 serving members and employers and originating and managing a diversified portfolio of high-quality investments in public markets, private equity, infrastructure and real estate.

OMERS is committed to having a workforce that reflects the communities in which we live and work. We are an equal opportunity employer committed to a barrier-free recruitment and selection process. At OMERS inclusion and diversity means belonging. How we create a sense of belonging is through our employees and our vast network of Employee Resource Groups. Whether you are passionate about gender, pride, or visible minorities, we have groups that are focused on making a difference in all of our lives.

Omers