Investment Application Support Analyst

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.

Report to Manager of Capital Market Operation and Technology, the Investments Application Analyst is responsible for supporting Application Systems, Databases, Automated workflow processes and Integrations used in OMERS Capital Markets and Investments Operations & Applications.

As a part of the technical team, Investment Application Analyst will participate in business initiatives and projects related to core investment application upgrades, database administration and integration activities, as well as supporting automated workflows part of the overnight processing.

Excellent client service, interaction, and communication skills and the ability to perform in a high-paced, deadline-driven environment is necessary.

Job Details : Investment Application Support Analyst

Perform Database Administration duties across database servers dedicated to Investment Systems (including MS SQL Server, Azure SQL Server, and Oracle instances)

Installing and configuring various Investment systems (Calypso, Eagle Pace, CRD, Frontier), as well as providing direct support, monitoring, and troubleshooting

Develop scripts and automations for data retrieval from 3rd party vendors and integration between the systems

Analyze existing programmatic solutions and workflows and recognize opportunities for automation, improvement, and optimization

Maintain and administer application and architecture security standards for Investment applications.

Manage and support overnight investment process, including all data flow solutions and enterprise scheduling.

Manage all problem and enterprise change management processes representing investment requirements as well as maintain the change management system in timely manner.

Work cross functionally with both technical and business teams as appropriate to facilitate roll-out and ongoing support of major infrastructure and solution enhancements for investments users

Ability to multitask and deal with projects with aggressive timelines.

Demonstrate high personal and ethical standards with the ability to collaborate across the organization.

Develop and maintain strong relationships with clients and external vendors with specific focus around managing OMERS Capital Markets production environment

Build and maintain documentation for all supported technology platforms and applications

Works constantly to broaden knowledge, learn new things and adapts to a multifaceted and evolving technical and business investment environment

PLEASE NOTE : This role may require some work to be performed outside regular business hours including evenings, nights and weekends for troubleshooting and implementation purposes pag

To succeed in this role :

University or College degree, Computer Science, Information Technology, Engineering or Mathematics is a plus, other programs will be considered

3+ years of relevant experience in position tied to database administration, scripting and work related to maintaining business systems preferably related to investment industry

Solid grasp of database technologies with the emphasize on SQL Server and Oracle, DBA knowledge of SQL Server or Oracle or both is a strong plus

Familiarity with investments industry terminology

Knowledge of programming principles and comfort with using common development platforms and languages (PowerShell, Python, VB, Java).

Familiarity with modern cloud-based technologies such as modern Microsoft Workplace, analytical tools, and platforms (Power Apps, Power Automate, Power BI, Azure, etc.)

Strong knowledge of Windows and Microsoft Office products

Analytical and problem-solving skills to resolve technical issues and recommend solutions

Excellent team player with interpersonal and communication (oral and written) skills to take

care of users of varying levels of technology expertise

Organizational skills to prioritize work and track the status of multiple activities

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 3 days per week.

Our story :

Founded in 1962, OMERS is one of Canada’s largest defined benefit pension plans, with $128.6 CAD billion in net assets as of December 31, 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’s 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 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.