Senior Business Analyst, Data Integration & Performance Platform (12 month contract)

OMERS; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

Join a leading pension plan as a Senior Business Analyst, focusing on data integration and performance platforms. You will lead projects, collaborate with cross-functional teams, and ensure the delivery of high-value solutions. This hybrid role requires a minimum of 4 days in the office each week, supporting a culture of collaboration and service excellence.

Qualifications

• Minimum 6 years’ experience supporting data warehouse platforms.
• Expert knowledge of business analysis strategies and SQL.
• Experience with leading investment applications.

Responsibilities

• Lead Agile and Waterfall projects for data platform enhancements.
• Collaborate with teams to gather and analyze project requirements.
• Ensure data accuracy and integrity by monitoring production issues.

Skills

Business Analysis

Communication

Problem Solving

Collaboration

Education

Bachelor’s Degree in a related field

Tools

SQL

ETL/ELT tools

Azure

Snowflake

Power BI

Job description

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise, and experience. A place where you can personalize your employee journey to be — and deliver — your best.

We are a purpose-driven, dynamic, and sustainable pension plan. An industry-leading global investor with teams in Toronto, London, New York, Singapore, Sydney, and other major cities across North America and Europe. We embody the values of our 600,000+ members, placing their best interests at the heart of everything we do.

Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.

Don’t just work anywhere — come build tomorrow together with us.

Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.

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 initiatives to mission-critical data and investment performance platforms. The incumbent will ensure that platforms align with department objectives and the needs of our internal partners by delivering high-value solutions and resolving issues.

This is a 12-month fixed-term contract position.

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. Our hybrid work guideline requires teams to come to the office a minimum of 4 days per week.

Responsibilities

• Lead and participate in both Agile and Waterfall projects related to data and performance platform enhancements, system integrations, and process improvements benefiting 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 reports (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 stakeholder impact analysis, 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, troubleshooting guides, and knowledge base articles.
• Ensure data accuracy, integrity, and availability by monitoring and resolving production data and platform issues with minimal disruption.
• Develop and maintain data documentation, including data dictionaries, data lineage, and metadata.
• Support a culture of transparency, collaboration, and service excellence to develop relationships among partners.

Qualifications

• Minimum 6 years’ experience supporting data warehouse platforms, including production support, change initiatives, and 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 managing multiple projects.
• Experience with leading investment applications (e.g., Eagle, SimCorp, FactSet, Bloomberg, Aladdin).
• Experience with Azure cloud platform and/or Snowflake is a plus.
• Excellent communication and facilitation skills.
• Self-motivated with strong analytical and problem-solving skills.
• Thrives in collaborative environments focused on team success.
• Bachelor’s Degree in a related field (Computer Science, Engineering, Mathematics, Accounting, Finance, Economics).
• CFA and CBAP certifications are assets.
• Drive, optimism, and a commitment to continuous improvement.
• Experience with generative AI tools and prompt engineering is a plus.