Senior Business Analyst, Data Integration & Performance Platform – Omers

Title of the Job: Senior Business Analyst, Data Integration & Performance Platform

Location: Toronto, ON

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 to 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, support the communities 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.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 flexible hybrid work guideline requires teams to come to the office a minimum of 3+ days per week.Scope of PositionReporting 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.ResponsibilitiesLead 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 FinanceEnsure that project scope, objectives, deliverables, and timelines are clearly documented and communicatedCollaborate 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 testsEnsure change management principles are considered throughout delivery, including the early capture of stakeholder impacts, end user training, and communicationsPartner with technology teams to implement system enhancements, upgrades, and patchesAct as a subject matter expert for the data warehouse and performance measurement platformsDevelop and maintain support documentation, including troubleshooting guides and knowledge base articlesEnsure data accuracy, integrity and availability by monitoring and resolving production data and platform issues, ensuring minimal disruption to investment teamsDevelop and maintain data documentation, including data dictionaries, data lineage, and metadataDevelop relationships among partners by supporting a culture of transparency, collaboration, and service excellenceQualificationsMinimum 6 years experience in business analysis roles supporting data warehouse platforms, including production support, change initiatives and/or large transformation programsExpert knowledge of business analysis strategies (requirements elicitation, business process modeling, user stories, source to target mapping etc.)Expert knowledge of SQL and relational databasesExpert knowledge of ETL/ELT tools and design patternsKnowledge of investment performance measurement and attribution methodologies for fixed income and equity strategiesKnowledge of the investment lifecycle and data domains for exchange traded and OTC products, including exotic instrumentsHands-on experience delivering complex data assets, and a proven ability to manage multiple projectsExperience 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 haveExcellence in all types of communication and facilitation with colleagues at all levelsSelf-motivated with strong, proven, analytical and problem-solving skillsThrives in highly collaborative environments with a focus on team successBachelor’s Degree in a related field such as Computer Science, Engineering, Mathematics, Accounting, Finance, and Economics.CBAP certification considered an assetPossesses drive, optimism, and a desire to deliver with excellence and continuously improveExperience with using generative AI tools and prompt engineering a nice to haveAs 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 — 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 Purpose@Work committee and employee recognition programs.

Company Name: Omers

Salary:

Apply for the job!