HOOPP
Sr. Business Data Analyst (Finance)
Toronto, Ontario, Canada · Senior
Sponsorship not specified$103k-$153kDetected 1 day ago
PythonSQLSnowflakeData AnalysisData EngineeringStakeholder ManagementNegotiationAccountingForecastingExcelSAPValuationVendor ManagementProcurementCommunicationProblem SolvingCFA
About the role
- Administer Bloomberg services, including user onboarding, terminal and licensing management, permissions, and configurations to enable trade capture and data flows.
- The content of this job profile is not exhaustive but is merely the most accurate list of the current job.
- Management reserves the right to revise the job profile or require that other tasks be performed when the circumstances of the job change (for example, emergencies, and changes in personnel, workload, or technical development).
Responsibilities
- Develop and maintain data governance standards, models, and controls; monitor adherence and recommend improvements.
- Execute, create and enhance data integrity reporting to identify and assess potential data issues across investment applications; proactively maintain data and ensures ongoing controls are effective.
- Design, develop, and implement data quality checks using the data quality application; automate quality controls where possible and strengthen exception handling and validation procedures.
- Perform detailed business and data analysis to resolve complex data exceptions with vendors and internal stakeholders; own resolution of breaks rather than only reporting issues to others.
- Lead investment system releases and data recovery activities to meet SLAs which enable Finance, Risk, Compliance and Investment Management to utilize data for daily insights, investment reporting and investment decision making.
- Build detailed knowledge of investment workflows and respond quickly to data availability, integrity, and completeness issues.
- Own security master, reference data, pricing, and market data processes, including consolidation of external sources into a single, trusted version of data and synchronization of positions and transactions across production systems.
- Provide end-to-end support for front office and compliance, trading applications, including onboarding, configuration management, and troubleshooting trade flow and data issues across integrated platforms.
- Coordinate and/or lead cross department initiatives on behalf of Investment Data Governance, managing stakeholder expectations, dependencies, and delivery timelines, support data vendor management activities including procurement, due diligence, forecasting, and invoice management.
- Support Master Data Management (MDM) technologies and processes by onboarding new data, configuring system that produce fit-for-purpose data from multiple sources.
Requirements
- Serve as back up for operational tasks as required.
Skills
- 7+ years of experience in investment and financial systems administration/implementation or investment data management.
- Post-secondary education in finance or equivalent experience; Canadian Securities Course preferred.
- Progress towards or completion of professional designations (e.g. CFA) is an asset.
- Highly analytical with strong consulting and problem-solving skills; persistence in addressing root causes is essential.
- Ability to understand and navigate multi-system investment environments and how different user groups consume and rely on data.
- Knowledge of accounting and performance reporting requirements is an asset.
- Experience with data quality tools (e.g., Precisely DQ+) and procedures, relational data concepts, and report development.
- Proficiency with SQL and Python, and exposure to ETL and business intelligence/reporting tools are strong assets, advanced Excel skills.
- A.I. fundamentals especially in generative A.I. and applicability to process automation.
- Understanding of valuation and pricing methodologies across asset classes is an asset.
- Conceptual knowledge and experience with Master Data Management (MDM) technologies.
- Business analysis experience (e.g. requirements, process mapping, testing and stakeholder management).
Compensation
- The actual base salary offered to the successful candidate may vary based on multiple factors including, but not limited to, individual's expertise and level of experience applicable to the role they are being offered.
- This role is eligible to participate in discretionary incentive plan(s), subject to the terms and conditions of the applicable incentive plan text.
- $103,000 - $153,000 CAD
Benefits
- 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
- optional post-retirement health and dental benefits subsidized at 50%
- yoga classes, meditation workshops, nutritional consultations, and wellness seminars
- 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
This listing is sourced directly from HOOPP's careers page and normalized into a canonical job model.