Job Description

Vision and Core Values

OMERS overall vision is to play a leadership role in the pension industry and be first of class, deliver superior services and to grow and attract investment partners. The core values are to be fair, have high integrity, respect for each other, provide superior service and work as a team.

The Corporate Objectives for OMERS is to provide secure pensions for all their constituents by:

Investing to earn outstanding returns with due regard for risk

Partnering with like-minded investment managers

Providing high quality service to our members and employers

Delivering value for money

Building a culture of excellence and pride in OMERS

OMERS Operating Principles are: Financial Strength, Accountability, Member Focus, Talent and Reporting.

Value Proposition

This is an opportunity to join a forward-looking team to progress a digital transformation that will enable OMERS Capital Markets businesses and supporting functions to deliver on our pension promise. Our team is at the early stages of defining a strategic roadmap, and the selected candidate will work with internal partners to understand their needs and deliver outcomes, with excellence. This role joins a team on a journey, with significant future potential in a global, sophisticated, and complex enterprise.

Scope of Position

Reporting to the Director, Data Integration & Performance Platform, the Senior Business Analyst will support and deliver a variety of change initiatives to mission critical data and investment performance platforms. The incumbent will ensure that platforms align to department objectives, and the needs of our internal partners by delivering high value solutions and resolving issues.

Responsibilities

Lead and participate in both Agile and Waterfall projects related to data and performance platform enhancements, system integrations, and process improvements that benefit OMERS investment teams, Corporate Finance and Capital Markets Finance

Ensure that project scope, objectives, deliverables, and timelines are clearly documented and communicated

Collaborate with cross-functional teams to gather and analyze requirements for projects impacting the OMERS investment data warehouse, and performance measurement platform (e.g. user stories, business requirements documents, BPMN, data flow diagrams, etc.)

Design and develop complex investment reporting (SQL, SSRS, OLAP, Power BI etc.)

Define and execute business test plans, including performance and integration tests

Ensure change management principles are considered throughout delivery, including the early capture of stakeholder impacts, end user training, and communications

Partner with technology teams to implement system enhancements, upgrades, and patches

Act as a subject matter expert for the data warehouse and performance measurement platforms

Develop and maintain support documentation, including troubleshooting guides and knowledge base articles

Ensure data accuracy, integrity and availability by monitoring and resolving production data and platform issues, ensuring minimal disruption to investment teams

Develop and maintain data documentation, including data dictionaries, data lineage, and metadata

Develop relationships among partners by supporting a culture of transparency, collaboration, and service excellence

Qualifications

Minimum 6 years experience in business analysis roles supporting data warehouse platforms, including production support, change initiatives and/or large transformation programs

Expert knowledge of business analysis strategies (requirements elicitation, business process modeling, user stories, source to target mapping etc.)

Expert knowledge of SQL and relational databases

Expert knowledge of ETL/ELT tools and design patterns

Knowledge of investment performance measurement and attribution methodologies for fixed income and equity strategies

Knowledge of the investment lifecycle and data domains for exchange traded and OTC products, including exotic instruments

Hands-on experience delivering complex data assets, and a proven ability to manage multiple projects

Experience implementing and delivering change to leading investment applications (e.g. Eagle, SimCorp, FactSet, Bloomberg)

Experience with the Azure cloud platform and/or Snowflake are nice to have

Excellence in all types of communication and facilitation with colleagues at all levels

Self-motivated with strong, proven, analytical and problem-solving skills

Thrives in highly collaborative environments with a focus on team success

Bachelor\xe2\x80\x99s Degree in a related field such as Computer Science, Engineering, Mathematics, Accounting, Finance, and Economics.

CBAP certification considered an asset

A sense of urgency, optimism, and a desire to deliver with excellence

Our story:

Founded in 1962, OMERS is one of Canada\xe2\x80\x99s largest defined benefit pension plans, with $124 billion in net assets as at December 31, 2022. 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