Senior Business Analyst, Data Integration Specialist

Empower Your Impact

At OMERS, we're committed to creating a workplace where employees thrive. Join a global team that values diversity, expertise, and experience. Personalize your employee journey to be your best and deliver exceptional results.

We're a purpose-driven, dynamic, and sustainable pension plan, leading the way in global investing. Our teams in Toronto, London, New York, Singapore, and Sydney work together to deliver exceptional results for our 600,000+ members.

Accelerate your growth and development, prioritize wellness, build connections, and support the communities we live and work in. Join us to build tomorrow together.

Be Part of a Forward-Looking Team

This is an exciting opportunity to join a team driving digital transformation in OMERS Capital Markets businesses and supporting functions. As a Senior Business Analyst, you'll work with internal partners to understand their needs and deliver outcomes with excellence.

We believe in the importance of time together in the office for our employees, OMERS, and Oxford. Our flexible hybrid work guideline requires teams to come to the office a minimum of 3+ days per week.

Scope of Position

Reporting to the Director, Data Integration & Performance Platform, you'll support and deliver change initiatives to mission-critical data and investment performance platforms. Ensure platforms align with department objectives and internal partner needs by delivering high-value solutions and resolving issues.

Responsibilities

• Lead and participate in Agile and Waterfall projects related to data and performance platform enhancements, system integrations, and process improvements.
• Ensure 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.
• 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 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 of 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 is a plus.
• 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's Degree in a related field such as Computer Science, Engineering, Mathematics, Accounting, Finance, and Economics.
• CBAP certification is considered an asset.
• Possesses drive, optimism, and a desire to deliver with excellence and continuously improve.
• Experience with using generative AI tools and prompt engineering is a plus.

At OMERS, we're committed to creating a workplace where employees thrive. Join a global team that values diversity, expertise, and experience. Personalize your employee journey to be your best and deliver exceptional results.

We're a purpose-driven, dynamic, and sustainable pension plan, leading the way in global investing. Our teams in Toronto, London, New York, Singapore, and Sydney work together to deliver exceptional results for our 600,000+ members.

Accelerate your growth and development, prioritize wellness, build connections, and support the communities we live and work in. Join us to build tomorrow together.

Be Part of a Forward-Looking Team

This is an exciting opportunity to join a team driving digital transformation in OMERS Capital Markets businesses and supporting functions. As a Senior Business Analyst, you'll work with internal partners to understand their needs and deliver outcomes with excellence.

We believe in the importance of time together in the office for our employees, OMERS, and Oxford. Our flexible hybrid work guideline requires teams to come to the office a minimum of 3+ days per week.

Scope of Position

Reporting to the Director, Data Integration & Performance Platform, you'll support and deliver change initiatives to mission-critical data and investment performance platforms. Ensure platforms align with department objectives and internal partner needs by delivering high-value solutions and resolving issues.

Responsibilities

• Lead and participate in Agile and Waterfall projects related to data and performance platform enhancements, system integrations, and process improvements.
• Ensure 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.
• 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 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 of 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 is a plus.
• 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's Degree in a related field such as Computer Science, Engineering, Mathematics, Accounting, Finance, and Economics.
• CBAP certification is considered an asset.
• Possesses drive, optimism, and a desire to deliver with excellence and continuously improve.
• Experience with using generative AI tools and prompt engineering is a plus.

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 in 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 committee and employee recognition programs.