**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, ensuring data integrity and availability within investment applications, data reconciliation, pricing integrity, security master, and integrity of reference and market data.

The Business Data Analyst will assist in the design and implementation of data quality best practices. Business data governance practices ensure the integrity, usability, and transparency of investment data. The 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 may also be 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 to repair failed jobs, re-run processes, and optimize scheduling
- Resolve data integrity issues in a timely manner, escalate as needed, and contribute to finding resolutions
- Review data integrity checks to assess potential data issues in various investment applications
- Create, develop, test, and implement data quality checks, processes, and procedures to manage data quality and reconciliation requirements
- Conduct root cause analysis to investigate issues and recommend solutions
- Maintain security master, reference data, and ensure controls are executed for static data, pricing, market data, and automated trade capture
- Assist in IT specifications preparation, provide test cases, and test finished products
- Document operational processes, data flows, and operational controls
- Develop working relationships with HOOPP’s investment management teams, operational teams, auditors, IT, data vendors, and industry partners
- Understand HOOPP’s investment business and respond quickly and accurately to questions regarding Investment Data
- Actively monitor and execute data governance controls, contributing to best practices and data governance standards
- Validate data using exception handling tools and procedures
- Contribute to Data Quality checks and identify opportunities to leverage new business tools
- Collaborate cross-functionally to ensure Investment applications have complete information for business users daily
- Serve as subject matter expert 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
- Knowledge of investment management principles with exposure to marketable securities, derivatives, private placements, infrastructure, and real estate
- Ability to perform data analysis to identify trends and correlations
- Experience with databases and advanced report development concepts
- Proficiency in data extraction, cleaning, and analysis from large datasets
- Advanced competency in Excel, MS SQL Server Tools, and SQL
- Understanding of middle and back office processes and technical applications
- Familiarity with Cloud architecture concepts, data lakes, and warehouses
- Knowledge of Agile methodology and Change management
- Strong time management skills with the ability to focus on multiple tasks
- Excellent interpersonal and communication skills to facilitate interaction across departments
- Strong attention to detail and problem-solving skills
- Self-motivated with the ability to work independently or in a team setting
- Experience with Business Intelligence software and systems for Investment business (e.g., SAP HANA, Eagle PACE, SimCorp Dimension, Bloomberg, Snowflake) is an asset
- Completion of Canadian Securities Course is preferred
- Enrolment or completion of professional training (e.g., CFA) is an asset
- Competency in Python and understanding of accounting and performance reporting requirements is beneficial.