Business Data Analyst

Full Time
  • Full Time
  • Toronto

agilius work 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
  • Develop effective working relationships with investment management teams, operational teams, auditors, IT, data vendors and others within the industry
  • Contribute to the development of the Data Quality checks and identify opportunities to leverage new business tools to meet business requirements
  • 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

  • Requirements:

  • 3-5 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
  • Advance competency in Excel, MS SQL Server Tools, and SQL language.

    Intermediate Transact-SQL language skills is also required for the role
  • Excellent interpersonal and communication skills (verbal and written) to facilitate interaction with other partners in Finance, Investment Management, IT, and external vendors
  • 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
  • Additional Competencies:

  • Competency in Python a definite asset
  • Completion of Canadian Securities Course. Enrolment or completion of relation professional training (e.g. CFA) is not required but will be an asset
  • What’s in it for you:

  • The opportunity to work with one of Ontario’s leading Pension Providers
  • Source

    To apply, please visit the following URL: