Business System Analyst

 

Description:

Business System Analyst 

Location: Toronto, Canada (Hybrid)

Summary:

We are looking for a Business System Analyst with strong Portfolio Management domain experience to support the functional design and modernization of ClientLink. The role involves translating legacy portfolio management systems into modern, scalable architectures through detailed functional specifications, data analysis, and system integration design. The ideal candidate will work closely with business, architecture, and engineering teams to ensure alignment with portfolio management workflows, financial accuracy, and long-term modernization goals.

Roles & Responsibilities:

Functional Design & Modernization -

Lead the definition of target-state functional capabilities for Client Link

Develop:

Functional specifications

Use cases and user journeys

User stories with clear acceptance criteria

Translate legacy system behavior into modern, modular, and scalable designs

Define business rules, data flows, and system interactions

Identify gaps between current-state legacy ClientLink and future-state modernized architecture

Data & System Analysis -

Analyze and validate end-to-end flows for transactions, positions, valuations, and performance

Perform hands-on SQL analysis for data reconciliation, validation, and issue investigation

Trace and validate data lineage across:

Upstream systems (e.g., security master, transaction feeds)

ClientLink processing (batch engines, financial calculations)

Downstream consumers (reporting platforms and external applications)

System Design & Integration -

Define and document API contracts, including payload-based and file-based integrations

Document batch, real-time, and event-driven processing flows

Collaborate with architecture and engineering teams to ensure scalable, modernization-aligned designs

Identify failure points, edge cases, and data integrity risks

Production Insight & Problem Solving -

Incorporate production realities and known system constraints into functional designs

Support root cause analysis to validate assumptions and strengthen future-state architecture

Business & Domain Alignment -

Partner closely with business stakeholders to define requirements aligned with portfolio management workflows

Ensure outputs align with financial expectations including positions, valuations, performance, and reporting needs

Qualifications & Skills:

Core Technical Skills -

· Strong SQL and hands-on data analysis experience

· Expertise in functional specifications, data mappings, and system flow documentation

· Experience with APIs, batch processing, and cross-system integrations

Functional Design Expertise -

· Proven ability to translate business requirements into clear functional designs

· Strong experience creating consumable documentation for engineering teams

· Hands-on experience in modernization or transformation initiatives, particularly legacy-to-modern transitions