Investment Data Analyst

6 days ago


Toronto ON, Canada The Mirillion Group Full time

Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on projects. End to end knowledge of trading workflows will be leveraged support the activities of all stakeholders involved in the trading process.

The incumbent will also be an integral part of data operations that ensures investment applications have complete information for business users daily. This includes operational activities such as setting up securities, portfolios and maintaining data in trade and book of record systems. The incumbent will further contribute to monitoring and responding to the daily cycle of events, ensure data integrity and availability within investment applications, data reconciliation, pricing integrity, security master, integrity of reference data, 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 be involved in reviewing data governance processes and practices keeping current on industry standards in the data governance space. The Business Data Analyst will assist in the design, build, support and use data quality checks in support of governance process and integrity of investment data across multiple systems.

The position requires strong problem solving and analytical skills coupled with experience in the capital market space. The candidate should have solid investment operations knowledge, securities modelling, managing reference data, market data and systems testing experience. The candidate should be SQL literate and comfortable navigating databases. This position requires the individual to be on support during some holidays depending on investment market activity. There may also be the occasional weekend work for system testing or implementations.

What you will do:

  • Create and maintain trade support data in investment systems.
  • Resolve data integrity issues on a timely basis, escalate as needed and work cross team to resolve issues. Candidate should be able to contribute to finding root causes and resolutions 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 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.
  • Participate in daily operational support scrums to ensure solid support of clients that support the firm's investment activities.
  • Where changes to application functions are 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, controls and test cases and results.
  • Develop effective working relationships with the investment management teams, operational teams, custodians, auditors, IT and external vendors and business partners.
  • Develop a detailed understanding of the investment business and the various systems and operation processes used to support it.
  • Respond timely, accurately and clearly 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.

What you bring:

  • Knowledge of investment management principles and practices with solid knowledge of marketable securities, derivatives, private placements, infrastructure and real estate.
  • Experience in the capital market space. Your experience in investment operations, fund valuations or data operations will be especially valuable.
  • Highly analytical with strong consulting and problem-solving skills.
  • Solid communication skills verbal and written. Ability to understand and articulate complex topics.
  • Experience working with databases and knowledge of report development concepts.
  • Competency in SQL language.
  • Competency in Python a definite asset.
  • Advanced Excel knowledge using macros, pivot tables and lookup functions.
  • Proactive and results oriented with proven time management skills and the ability to work well under pressure and manage multiple tasks concurrently.
  • Post-secondary training in finance such as the Canadian Securities Course or equivalent experience.
  • Completion of professional training (CFA, BABOK) is not required though will be an asset.
  • 3 to 5 years in investment and financial systems administration, implementation and reporting.
  • A team player. Must be able to work cross team.
  • Comprehensive understanding of middle and back-office processes and technical applications.
  • Competence with database report writers and software tools in the data quality and data governance space.
  • An understanding of the accounting and performance reporting requirements will be an asset to this position.
  • Experience with or proficiency with systems being utilized for the Investment business (SAP HANA,
  • Eagle PACE, SIMCORP Dimension, Bloomberg, UC4, PagerDuty and SQL query analyzer).
  • 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.



  • Toronto, ON, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, ON, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Old Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Old Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Ontario, Ontario, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational and IT teams to address production issues and execute on...


  • Toronto, Canada The Mirillion Group Full time

    Reporting to the Senior Manager, Investment Data Management (IDM) – Data Delivery, the Business Data Analyst is responsible for providing trading application support to the Investment Management (IM) division. The incumbent will manage relationships with IM, external vendors, securities operational


  • Toronto, Canada Canada Post - Postes Canada Full time

    Job Requisition Id: 181876 Business Function: Pension Investment Primary City: Toronto Other Location(s): Province: Ont. - GTA Employment Type: Full-Time Employment Status: Permanent Language Requirement: English Essential Employee Class and Level: UPCET01 Working Hours: Number of Vacancies: 2 **Salary**: Job Closing Date (MM/DD/YYYY):09/05/2024 Reporting...


  • Toronto, Canada Canada Post Full time

    Job Description Reporting to the Manager, Pension Investment Technology, the Analyst, Investment Data and Technology assists in designing, maintaining, and advancing the in-house IT structure of Pension Investment. The Analyst works with cross-functional teams, supporting the development and maintenance of data architecture, models, and integration...


  • Toronto, ON, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business demands Deploying ETL/ELT...


  • Toronto, ON, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business demands Deploying ETL/ELT...


  • Toronto, Ontario, Canada Hillsdale Investment Management Inc. Full time

    About the RoleHillsdale Investment Management Inc. is seeking a highly skilled Quantitative Analyst to join our Portfolio Management team. As a key member of our team, you will be responsible for developing and enhancing our existing stock selection models, researching and developing new factors and strategies, and providing routine support to Portfolio...


  • Toronto, Ontario, Canada Hillsdale Investment Management Inc. Full time

    About the RoleHillsdale Investment Management Inc. is seeking a highly skilled Quantitative Analyst to join our Portfolio Management team. As a key member of our team, you will be responsible for developing and enhancing our existing stock selection models, researching and developing new factors and strategies, and providing routine support to Portfolio...

  • Data Engineer

    21 hours ago


    Toronto, ON, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer.Role and Responsibilities:Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business...


  • Toronto, Canada Hillsdale Investment Management Inc Full time

    **INVESTMENT OPERATIONS ANALYST** **Hillsdale Investment Management Inc. **(Hillsdale) is an independent, employee-controlled, and client-aligned investment boutique managing investments on behalf of a select group of sophisticated institutional and private wealth investors. We engage in disciplined active investment management, specializing in equities,...

  • Research Analyst, Data

    3 months ago


    Toronto, Canada International Data Group, Inc. Full time

    Overview: - Do you want to be part of a dynamic team in a fast-paced exciting industry? You can make an impact by joining IDC Canada._ IDC Canada is looking for a **Research Analyst **to join our Data and Analytics team on a full-time basis for a permanent opportunity. Reporting to the Research Manager of IDC Canada’s Market Insights and Analytics,...