Senior Business Systems Analyst, Data Technology

Investment Management Corporation of Ontario; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

The Investment Management Corporation of Ontario seeks a Senior Business Systems Analyst, Data Technology in Toronto. This role focuses on leading systems and data analysis for investment processes, requiring expertise in performance measurement and investment systems. Ideal candidates will have a strong analytical background, excellent communication skills, and hands-on experience with ETL tools and SQL.

Qualifications

• At least five years of experience in performance and investment data and systems.
• Experience implementing performance investment systems and reporting solutions.
• Understanding of solution development life cycles and agile practices.

Responsibilities

• Lead requirements gathering, system configuration, and business workflow design.
• Act as a subject matter expert to business partners and IT stakeholders.
• Manage client relationships and project tasks with minimal direction.

Skills

SQL (PL/SQL, T-SQL)

Communication

Data solutions development

Investment data background

ETL tools & concepts

Agile practices

Education

Undergraduate or Postgraduate degree in business, data, engineering, or a related discipline

Tools

Azure stack

Power BI

Eagle PACE

Job description

Senior Business Systems Analyst, Data Technology

Apply locations Toronto - 16 York St
time type Full time
posted on Posted Yesterday
job requisition id R24-224

At IMCO, our talent is among the best! IMCO offers a uniquely stimulating and rewarding environment where you can help build and drive organizational transformation, all while seeking to challenge yourself, learn, and grow your career.

We offer a culture of collaboration and passion, creating unwavering value for the clients we serve. Our vision is to be the partner of choice for Ontario’s public sector funds and build a high-performing, value-based Asset Management firm in the heart of downtown Toronto.

If you are ready to drive best-in-class service, and join a collaborative, motivated, and fun team of professionals, we’re ready to offer you a great place to work with exciting opportunities for growth and development.

If you want to use your expertise to drive strategic business outcomes, then we want you at IMCO!

IMCO is looking for a highly motivated Senior Business Systems Analyst, Data Technology to join our team!

The Senior Business System Analyst, Data Technology, will lead requirements and business systems and data analysis, and support development, testing and support business stakeholder inquiries. This role will work closely with Performance Measurement and Analytics, Sustainable Investments (ESG) and Investment Compliance business stakeholders to understand business goals and translate them into actionable requirements and technical specifications to build sustainable business and technology processes and reporting.

We are looking for an experienced strong analyst with a background in implementing and maintaining investment systems, reporting solutions and data related to investment performance. The candidate must be comfortable working with investments data and performance concepts and reporting (portfolio hierarchy, performance returns (money weighted, time weighted, IRR), attribution, contribution).

The ideal candidate has successfully implemented systems and reporting solutions, related to performance, investments data (ABOR, IBOR), security reference data, market data (e.g Bloomberg, Rimes) in previous roles.

The ideal candidate is very comfortable working independently alongside business subject matter experts and technologists to advance strategic business objectives. Exposure to ESG datasets and investment compliance reporting is a nice to have.

The ideal candidate has experience working with integration and extension of investment systems databases, data models, reporting/business intelligence, ETL tools & concepts (SFTP, APIs, Azure Data Factory) and file formats (XML, XSD, JSON). Experience working with the Eagle PACE system is preferred.

The incumbent has worked in an agile environment and practices, and can expect to work in SCRUM or Kanban methodologies. This role will report to the Senior Manager, IT Performance and Corporate Analytics.

You Will be Responsible For:

• Lead requirements gathering, testing, system configuration, business workflow and process design for enhancements and projects
• Act as a performance data, systems and reporting subject matter expert to business partners, IT stakeholders, and operation teams.
• Managing client and support relationships and run intake sessions and request backlog, and business facilitate prioritization.
• Able to independently manage project and BAU tasks with minimal direction
• Execute supporting business system activities such as adhoc data analysis, system configuration updates and market data onboarding
• Coordinate backlog, collaborate through forums, and coordinate with business stakeholders, technology architects and IT partners for requirements, design, prioritization, and architecture decisions.
• Contribute to business cases for corporate projects and systems implementations
• Define and refine operational processes, SOC 2 compliance, and production support, as well as ensure the supportability of all solutions /with proper documentation and training.

What do you need to succeed?

• Systems and investment data background
• Experience implementing performance investment systems and reporting solutions, related to performance reporting (e.g portfolio hierarchies, returns, attribution, contribution), investments products, security reference data and market data (e.g Bloomberg, Rimes).
• Exposure to ESG datasets and investment compliance reporting is a nice to have.
• Excellent communication skills and ability to communicate comfortably with business and technical teams.
• A strong technical background in data solutions development to effectively partner, communicate, and understand systems designs with the development and IT architecture teams
• Comfort working with: SQL (PL/SQL, T-SQL), file types/models (XML, XSD, JSON), ETL tools & concepts (SFTP, APIs, Azure Data Factory), Azure stack, Power BI technologies
• Knowledge of data management and investment performance systems. Experience with Eagle PACE is preferred.
• Experience in working with cross-functional teams in other investment IT organizations.
• Exposure to working with outsourced developer, managed services and external data vendors
• Experience in requirement analysis, testing, and implementation of large scale implementation projects
• Knowledge of solution development life cycles, including planning, requirement, analysis, design, build, testing, implementation, and post-implementation activities.
• Undergraduate or Postgraduate degree in business, data, engineering, or a related discipline with at least five years of experience in performance and investment data and systems
• Good understanding of agile practices, with experience operating in Kanban or Scrum for delivery.

We thank all applicants, however, only those selected for an interview will be contacted.

Our hybrid work model offers flexibility and provides our employees with the opportunity to lead a well-balanced life. Our Office located at 16 York Street, Suite 2400, Toronto, ON M5J 0E6 provides a welcoming space for employees to gather, work collaboratively, and grow together.

IMCO is committed to providing accommodation for people with disabilities in its recruitment process. Please advise IMCO if you require an accommodation and we will work with you to meet your needs. Candidates being considered for this position will be required to submit to a background screening.

About Us

The Investment Management Corporation of Ontario (IMCO) is Ontario’s professional asset manager, investing on behalf of our public sector clients so they can care for beneficiaries and secure retirement futures.

With approximately $86 billion in assets under management, we are one of the largest institutional investment managers in Canada and around the globe.

Our mandate is to provide broader public sector clients with exceptional investment management services, including best-in-class advice around portfolio construction, efficient access to a diverse range of asset classes and superior reporting on risks and returns.

Our vision is to rank among the world’s leading public-sector asset managers. We will achieve this through an unwavering focus on creating client value. That means ensuring that we deliver the returns required for our clients to meet their long-term financial obligations.