Closed listing
Business Systems Analyst - Capital Market
- Toronto, ON, Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Closing date
- Experience
- 8+ years of experience as a Business Systems Analyst, Data Analyst, or similar role.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
BSA _SQL Capital Market
Full time
Toronto- Hybrid
Job Description
Role Summary
We are seeking a Senior Business Systems Analyst with strong expertise in Banking and , Capital Markets data, and hands‑on experience in SQL Server and Azure Cloud. The ideal candidate will bring deep data analysis capabilities, strong business systems analysis skills, and the ability to work closely with technology and business stakeholders to deliver high‑quality data solutions.
Key Responsibilities
- Analyze, interpret, and validate banking and Capital Markets datasets to support risk, regulatory, and business reporting needs.
- Collaborate with business stakeholders to gather, document, and translate requirements into functional and technical specifications.
- Perform detailed data analysis, data profiling, and root‑cause investigation for data quality issues.
- Work with technology teams to design and support data integration, transformation, and reporting solutions.
- Develop SQL queries, stored procedures, and data validation scripts to support analysis and solution delivery.
- Support cloud‑based data initiatives leveraging Azure services such as Data Factory, Synapse, and Azure SQL.
- Partner with cross‑functional teams to ensure alignment between business needs and technical implementation.
- Contribute to continuous improvement of data processes, standards, and best practices.
Required Qualifications
- 8+ years of experience as a Business Systems Analyst, Data Analyst, or similar role.
- Strong knowledge of banking and Capital Markets product data
- Proven experience in data analysis and business systems analysis within financial services.
- Proficiency in SQL Server for data extraction, transformation, and analysis.
- Experience working with Azure Cloud (ADF, Synapse, Data Lake, Azure SQL).
- Strong analytical, problem‑solving, and documentation skills.
- Ability to communicate complex data concepts to both business and technical audiences.
- Experience working in large enterprise or financial institutions is an asset.
Nice to Have
- Exposure to risk management frameworks or regulatory reporting (Basel, OSFI).
- Experience with data governance, metadata, or data quality tools.
- Familiarity with Agile methodologies and user story creation.
More about this job
Responsibilities
Analyze and validate banking and Capital Markets data for risk, regulatory, and business reporting, and investigate data quality issues. Gather and document requirements, develop SQL-based analysis and validation solutions, support Azure data initiatives, and coordinate with business and technology teams.
Requirements
Requires 8+ years of experience in business systems or data analysis, strong banking and Capital Markets data knowledge, and financial services experience. Candidates should be proficient in SQL Server and Azure services, with strong analytical, problem-solving, documentation, and communication skills.
Skills
- Business Systems Analysis
- Capital Markets Data
- Banking Data
- SQL Server
- Azure Cloud
- Data Analysis
- Data Profiling
- Data Quality
- Requirements Gathering
- Functional Specifications
- Technical Specifications
- Data Integration
- Data Transformation
- Azure Data Factory
- Azure Synapse
- Azure SQL
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Consulting
Keywords
- Banking
- Capital Markets
- Risk Reporting
- Regulatory Reporting
- Business Reporting
- Business Systems Analysis
- Data Analysis
- Data Profiling
- Data Quality
- Root-Cause Analysis
- SQL Server
- SQL Queries
- Stored Procedures
- Data Validation
- Azure Cloud
- Azure Data Factory
- Azure Synapse
- Azure Data Lake
- Azure SQL
- Data Integration
- Data Transformation
- Functional Specifications
- Technical Specifications
- Data Governance
- Metadata
- Basel
- OSFI
- Agile
- User Stories
- Financial Services