Business Data Analyst (12-month contract)

at  Healthcare of Ontario Pension Plan HOOPP

Why you’ll love working here:

• high-performance, people-focused culture
• our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves
• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth
• membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security
• competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team’s diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, and newly extended maternity/parental leave top of 26 weeks)
• optional post-retirement health and dental benefits subsidized at 50%
• yoga classes, meditation workshops, nutritional consultations, and wellness seminars
• access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees
• the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary:
Reporting to the Senior manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on projects. End to end knowledge of trading workflows will be leveraged support the activities of all stakeholders involved in the trading process.
The incumbent will also be an integral part of data operations that ensures investment applications have complete information for business users daily. This includes operational activities such as setting up securities, portfolios and maintaining data in trade and book of record systems. The incumbent will further contribute to monitoring and responding to the daily cycle of events, ensure data integrity and availability within investment applications, data reconciliation, pricing integrity, security master, integrity of reference data, market data and straight-through trade capture. The Business Data Analyst will assist in the design and implementation of data quality best practices. Data governance practices ensures the integrity, usability and transparency of investment data. Business Data Analyst will be involved in reviewing data governance processes and practices keeping current on industry standards in the data governance space. The Business Data Analyst will assist in the design, build, support and use data quality checks in support of governance process and integrity of investment data across multiple systems.
The position requires strong problem solving and analytical skills coupled with experience in the capital market space. The candidate should have solid investment operations knowledge, securities modelling, managing reference data, market data and systems testing experience. The candidate should be SQL literate and comfortable navigating databases. This position requires the individual to be on support during some holidays depending on investment market activity. There may also be the occasional weekend work for system testing or implementations.

What you will do:

• Create and maintain trade support data in investment systems.
• Resolve data integrity issues on a timely basis, escalate as needed and work cross team to resolve issues. Candidate should be able to contribute to finding root causes and resolutions for improving controls and efficiency.
• Review data integrity checks to assess potential data issues resident in the various investment applications. Create, develop, implement and test data quality checks, processes and procedures to manage data, content quality and reconciliation requirements.
• For Production systems the Business Data Analyst is responsible for security master, reference data, maintaining tables and data translations. The controls must be executed for static data, pricing, market data and automated trade capture on an ongoing basis.
• Participate in daily operational support scrums to ensure solid support of clients that support HOOPP’s investment activities.
• Where changes to application functions are identified, the Business Data Analyst is responsible to work with IT by assisting in the preparation of specifications, providing test cases, testing finished product and signing off.
• Document operational processes, data flows, controls and test cases and results.
• Develop effective working relationships with HOOPP’s investment management teams, operational teams, custodians, auditors, IT and external vendors and business partners.
• Develop a detailed understanding of HOOPP’s investment business and the various systems and operation processes used to support it.
• Respond timely, accurately and clearly to questions and problems that arise in the availability, integrity or completeness of Investment Data.
• Primary back up and support for Senior Analysts as required.

What you bring:

• Knowledge of investment management principles and practices with solid knowledge of marketable securities, derivatives, private placements, infrastructure and real estate.
• Experience in the capital market space. Your experience in investment operations, fund valuations or data operations will be especially valuable.
• Highly analytical with strong consulting and problem-solving skills.
• Solid communication skills verbal and written. Ability to understand and articulate complex topics.
• Experience working with databases and knowledge of report development concepts.
• Competency in SQL language.
• Competency in Python a definite asset.
• Advanced Excel knowledge using macros, pivot tables and lookup functions.
• Proactive and results oriented with proven time management skills and the ability to work well under pressure and manage multiple tasks concurrently.
• Post-secondary training in finance such as the Canadian Securities Course or equivalent experience.
• Completion of professional training (CFA, BABOK) is not required though will be an asset.
• 3 to 5 years in investment and financial systems administration, implementation and reporting.
• A team player. Must be able to work cross team.
• Comprehensive understanding of middle and back-office processes and technical applications.
• Competence with database report writers and software tools in the data quality and data governance space.
• An understanding of the accounting and performance reporting requirements will be an asset to this position.
• Experience with or proficiency with systems being utilized for the Investment business (SAP HANA, SIMCORP Dimension, Bloomberg and SQL query analyzer).
• This position requires an above average, technically inclined individual who is a self-starter and highly motivated to manage financial data/systems in an integrated environment.

• Create and maintain trade support data in investment systems.
• Resolve data integrity issues on a timely basis, escalate as needed and work cross team to resolve issues. Candidate should be able to contribute to finding root causes and resolutions for improving controls and efficiency.
• Review data integrity checks to assess potential data issues resident in the various investment applications. Create, develop, implement and test data quality checks, processes and procedures to manage data, content quality and reconciliation requirements.
• For Production systems the Business Data Analyst is responsible for security master, reference data, maintaining tables and data translations. The controls must be executed for static data, pricing, market data and automated trade capture on an ongoing basis.
• Participate in daily operational support scrums to ensure solid support of clients that support HOOPP’s investment activities.
• Where changes to application functions are identified, the Business Data Analyst is responsible to work with IT by assisting in the preparation of specifications, providing test cases, testing finished product and signing off.
• Document operational processes, data flows, controls and test cases and results.
• Develop effective working relationships with HOOPP’s investment management teams, operational teams, custodians, auditors, IT and external vendors and business partners.
• Develop a detailed understanding of HOOPP’s investment business and the various systems and operation processes used to support it.
• Respond timely, accurately and clearly to questions and problems that arise in the availability, integrity or completeness of Investment Data.
• Primary back up and support for Senior Analysts as required