Business Data Analyst

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 be part of an investment data operations team ensuring the timely availability of accurate investment data for HOOPP. 

Data operations ensures investment applications have complete information for business users daily.  This includes activities such as 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 ensures the integrity, usability and transparency of investment data.  Business Data Analyst will support resolving data issues, onboarding new data and assisting in the design and implementation of data processing and systems.

This position requires the individual to be available at 7:00 a.m. to support the data management functions.  There will also be the occasional holiday work to support the investment management division when markets are open.

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, test and implement data quality checks, processes and procedures to manage data, content quality and reconciliation requirements. Conduct root cause analysis to investigate issues and recommend solutions.

• 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. 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 and operational controls.

• Develop effective working relationships with HOOPP’s investment management teams, operational teams, auditors, IT, data 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 and completeness of Investment Data.

• 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 and contribute to the development of best practices and data governance standards.

• Proactively validates data using exception handling tools and procedures.

• Contribute 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.

• Act as subject matter experts on applicable industry and system projects.

What you bring:

• 3 + years of experience in investment and financial systems administration, implementation and reporting in the capital markets space.

• Knowledge of investment management principles and practices with exposure to marketable securities, derivatives, private placements, infrastructure and real estate.

• Ability to perform data analysis to identify trends, patterns, and correlations.

• Experience working with databases, database report writers and advanced knowledge of report development concepts.

• Ability to utilize analytical techniques to extract, clean, and analyze large datasets from multiple sources.

• Advanced competency in Excel, MS SQL Server Tools, and SQL language. Intermediate Transact-SQL language skills is also required for the role.

• Comprehensive understanding of middle and back office processes and technical applications combined with the ability to debug error messages.

• Understanding of Cloud, architectural concepts – data lake, data warehouse, relational databases, data ingestion, ETL etc.

• Good understanding of the Agile methodology and Change management.

• Results oriented with good time management skills and the ability to work well under pressure and focus on multiple tasks concurrently.

• Excellent interpersonal and communication skills (verbal and written) to facilitate interaction with other partners in Finance, Investment Management, IT, and external vendors

• Strong attention to detail and problem solving skills while maintaining quality on routine and repetitive tasks

• Self-motivated, willingness to take initiative while managing financial data/systems in an integrated environment. 

• Ability to work independently with minimal direction or in a team setting

• Experience using Business Intelligence software, ETL tools and/or systems being utilized for the Investment business (SAP HANA, Eagle PACE, SimCorp Dimension, Bloomberg, Snowflake) is an asset.

• Completion of Canadian Securities Course.  Enrolment or completion of relation professional training (e.g. CFA) is not required but will be an asset.

• Competency in Python an asset.

• An understanding of the accounting and performance reporting requirements will be an asset to this position.