Business Systems Analyst (Wholesale Banking/Capital Market)

Position: Business Systems Analyst (Wholesale Banking/Capital Market) Location: Onsite (4days/week)- Toronto, ON Job type: Full-time/Permanent hiring We are seeking a Capital Markets Business Analyst to drive requirements management and system integration initiatives across our wholesale finance domains. In this role, you will lead data sourcing, system integration, and interface mapping workflows for major Capital Market products, partnering closely with Product Control functions. You will leverage SQL to query and analyze complex datasets, while utilizing MS Visio and Excel to execute process automation mapping. Additionally, you will support modern architecture frameworks by working with APIs, Python scripting, and AI/Machine Learning tools to drive workflow automation across Jira, Confluence, or ServiceNow platforms in an enterprise DevOps setting. Key Responsibilities: Manage Capital Markets Requirements: Execute end-to-end requirements planning, elicitation, and prioritization techniques for large-scale, complex wholesale finance projects. Map Data Sourcing & Schemas: Lead structural data sourcing and data mapping tasks across complex source-to-target pathways for diverse, multi-asset Capital Market products. Support Product Control Functions: Align technical engineering blueprints with the operational requirements of the Product Control function, including valuation, P&L attribution, and risk boundaries. Execute Deep-Dive SQL Analytics: Query relational databases using advanced SQL to profile complex financial transactions, validate data accuracy, and isolate integration anomalies. Design Workflow Process Automations: Model as-is and future-state data patterns using MS Visio and deploy operational configurations across Jira, Confluence, and ServiceNow pipelines. Collaborate on APIs & Python Ingestion: Analyze API response payloads, interpret Python script automation configurations, and integrate advanced AI/machine learning data workflows. Audit ETL Data Pipelines: Oversee technical platform integration concepts, verifying downstream data pipeline integrity and ETL mapping transformations across enterprise lakes. Partner across DevOps Sprints: Interface directly with development teams, quantitative analysts, and business sponsors, ensuring deliveries adhere to enterprise DevOps standards. Required Skills: Primary: Capital Markets Product Knowledge, Requirements Elicitation & Management, Wholesale Finance Systems, Data Sourcing & Mapping, Product Control Integration. Tools/Frameworks: MS Visio, Advanced MS Excel, JIRA, Confluence, ServiceNow, SQL Developer, DevOps utilities. Database/Cloud: Relational Databases, ETL Architecture, API Integration (REST/JSON), Python Scripting basics, Machine Learning & Predictive Analytics concepts. Nice-to-Have: Professional Certifications (CFA, FRM, or CBAP), Experience with financial data models (e.g., FpML), CI/CD pipeline visibility.

Lead requirements management and system integration for Capital Market products, focusing on data sourcing and interface mapping. Partner with Product Control functions to align technical blueprints with operational needs like valuation and risk boundaries.

Requires deep expertise in Capital Markets and wholesale finance systems along with advanced SQL and data mapping skills. Proficiency in tools like MS Visio, Jira, and basic Python/API integration is essential for workflow automation.

• SQLPreferred
• JiraPreferred
• Machine learningPreferred

Identified from the job description. Confirm important requirements above.

• Capital Markets Product Knowledge
• Requirements Elicitation
• Wholesale Finance Systems
• Data Sourcing & Mapping
• Product Control Integration
• SQL
• MS Visio
• MS Excel
• Jira
• Confluence
• ServiceNow
• API Integration
• Python Scripting
• Machine Learning
• ETL Architecture
• DevOps

• Finance & Accounting
• Data & Analytics
• Technology
• Software
• Consulting

Minimum education

Professional degree

Minimum experience

5+ years

Apply by

Sep 23, 2026

Posting language

English

Working hours

40 hours per week

Office presence

4 days per week

Seniority

Mid-Senior level

Application method

Direct apply is available