Business Data Analyst (6-month Contract)

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 of Investment Data Management, the Business Data Analyst will support mission critical functions of data operations and data governance ensuring the timely availability of accurate investment data for HOOPP.

Data operations ensure investment applications have complete information for business users daily. This includes but is not limited to monitoring the daily cycle of events, ensure data integrity and availability within investment applications, data reconciliation, pricing integrity, security master, integrity of reference and 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 ensure the integrity, usability and transparency of investment data. Business Data Analyst will be involved in maintaining the investment data dictionary, reviewing data governance processes and practices keeping up to date on industry standards in the data governance space. The Business Data Analyst will assist in the design and implementation of the governance process and its systems.

The position requires strong problem solving and analytical skills coupled with investment operations knowledge, data loading and scheduling, managing reference and market data, and systems testing experience. The candidate should be SQL literate and comfortable navigating databases. This position requires the individual to be available at 7:00 a.m. to support the data management functions. Occasionally when supporting other team members, the individual may be required to stay as late as 6:00 p.m. or until all daily tasks are completed. There may also be the occasional weekend work for system testing or implementations.

What you will do:

• Ensure completeness of overnight data jobs. Work with IT in repairing failed jobs, re-running processes as required and optimizing scheduling.
• Resolve data integrity issues on a timely basis, escalate as needed and contribute to finding resolutions and 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 (SimCorp Dimension, SAP HANA, Eagle PACE, Bloomberg) 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.
• Where custom application function or report requirement is 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, test cases and results.
• Develop effective working relationships with HOOPP’s investment management teams, operational teams, custodians, auditors, system vendors and others within the industry.
• Develop a detailed understanding of HOOPP’s investment business and the various systems and operation processes used to support it; to respond quickly and accurately 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.
• The Business Data Analyst will work with the IT Specialists to ensure that the security reference manager, market data, pricing data feeds meet or exceed HOOPP Data Standards.
• Actively monitor and execute data governance controls, this includes the ongoing maintenance of HOOPP’s investment data dictionary. Contribute to the development of best practices and data governance standards.
• Proactively validates data using exception handling tools and procedures. Contributes to the development of the Data Quality checks and identify opportunities to leverage new business tools to meet business requirements.
• Work cross functionally as a contributing team player to ensure Investment applications have complete information for business users daily.
• Other duties as assigned.
  
  

What you bring:

• Knowledge of investment management principles and practices with exposure to marketable securities, derivatives, private placements, infrastructure and real estate.
• Highly analytical with strong consulting and problem-solving skills.
• Experience working with databases and advanced knowledge of report development concepts.
• Full competency in MS SQL Server Tools, SQL language and/or Transact-SQL language.
• Competency in Python a definite asset.
• Proactive and results oriented with good time management skills and the ability to work well under pressure and focus on multiple tasks concurrently.
• Post secondary training in finance or equivalent experience. Completion of Canadian Securities Course. Enrolment or completion of relation professional training (e.g. CFA) – is not required though may be an asset.
• Minimum experience: 5 years in investment and financial systems administration, implementation and reporting.
• A team player with excellent interpersonal and communication (written and verbal) skills are essential to deal with all levels of staff and outside contacts.
• Comprehensive understanding of middle and back-office processes and technical applications.
• Competence with database report writers and Windows based software with a strong proficiency in Excel.
• An understanding of the accounting and performance reporting requirements will be an asset to this position.
• Develop a strong proficiency with systems being utilized for the Investment business (SAP HANA, Eagle PACE, SimCorp Dimension, Bloomberg, SS&CNet)
• 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.
• Experience with Business Intelligence software and ETL tools a definite asset.