Business Analyst – Capital Markets (Montréal)

act digital; Montreal; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading digital consultancy in Canada is seeking an experienced Business Analyst with significant finance expertise to join their team in Montreal. The ideal candidate will have a strong technical background in SQL and the ability to adapt to changing project requirements. Responsibilities include gathering business requirements, translating them into technical solutions, and ensuring accuracy in data operations. Candidates should have a solid understanding of capital markets and the capability to collaborate effectively with technical teams.

Qualifications

• Deep knowledge of financial products such as Fixed Income, Bonds, and Equities.
• Proficiency in writing and troubleshooting SQL queries.
• Hands-on experience with financial platforms like Murex or Calypso.

Responsibilities

• Gather, analyze, and document business and technical requirements.
• Translate business needs into actionable technical solutions.
• Support data operations with a strong focus on accuracy.

Skills

Capital markets expertise

SQL database expertise

Clear communication

Adaptability

Technical understanding

Teamwork skills

Tools

SQL

Java

C++

Oracle

VBA

Job description

Company Description

At Act Digital Canada, we’re the Canadian subsidiary of an international group with over 5,000 consultants worldwide.

What makes us stand out?

• A solid international backbone with the agility of a local team.
• Deep technical expertise in cybersecurity, cloud, data & AI combined with strong business understanding.
• A focus on real collaboration, not buzzwords.

Our Canadian team, based in Montréal and Toronto, partners with leading organizations in banking, insurance, pharma, manufacturing, and energy. We don’t just deliver projects — we work side by side with our clients, adapting to their challenges and bringing the right expertise at the right time.

Job Description

About the Role

We are hiring a Business Analyst with proven and significant expertise in finance. If you do not have experience in finance, please do not apply.

Beyond strong business knowledge, the ideal candidate will also bring a solid technical background (SQL is mandatory) and the ability to work across several initiatives at once. The role requires adaptability, clear communication, and the ability to operate between functional and technical perspectives.

You will be working in an English environment.

Responsibilities

• Gather, analyze, and document business and technical requirements across multiple projects.
• Translate business needs into actionable technical solutions.
• Support data operations, validation, and transformation with a strong focus on accuracy.
• Write, optimize, and troubleshoot SQL queries (mandatory).
• Collaborate with developers, QA, and stakeholders to ensure successful delivery.
• Adapt to changing priorities, switching effectively between projects.
• Maintain strong communication in hybrid/remote environments.

Qualifications

Required Skills & Experience

• Capital markets expertise (mandatory): deep knowledge of financial products (such as Fixed Income, Bonds, Repos, Money Market, Equities, Mutual Funds, Derivatives, FX.)
• Technical background (mandatory): SQL database expertise is required. Additional experience with development tools/languages (Java, C++, Oracle, Sybase, VBA, etc.) is a strong asset.
• Hands-on experience with platforms such as Murex, Calypso, Openlink, Moody’s KMV, or similar.
• Ability to operate as both a technical expert and business analyst, bridging functional and technical aspects.
• Proven adaptability and flexibility to handle multiple projects at once.
• Strong communication and teamwork skills.

Additional Information

• Knowledge of reporting tools (Crystal Reports, Business Objects).
• Exposure to risk management platforms or data governance environments.