Senior Data Analyst

Grand Software Solutions; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

Une entreprise de premier plan au Canada recrute un Senior Reporting Data Analyst pour moderniser les rapports au sein des divisions Wealth Management et Capital Markets. Ce rôle implique l'analyse de systèmes hérités et la création de solutions de reporting évolutives pour une banque majeure, avec une attention particulière à la conformité et à la précision des données.

Qualifications

• 5+ ans d'expérience en Reporting/Analyse de données ou Analyse d'affaires dans le secteur bancaire.
• Expertise en Gestion de Patrimoine et/ou Courtage.
• Compétences en documentation claires et structurées.

Responsibilities

• Ingénierie inverse des rapports hérités construits dans Excel, Access, VBA et SQL.
• Documenter les spécifications de rapport et les flux de données.
• Collaborer avec les parties prenantes pour s'assurer des objectifs communs.

Skills

Reporting Analysis

Business Analysis

Stakeholder Management

Documentation Skills

SQL

Excel VBA

Job description

Job Title : Senior Reporting Data Analyst

Location : Hybrid (Toronto, ON)

Type : Contract

We are hiring a Senior Reporting Data Analyst to support enterprise reporting modernization across the Wealth Management and Capital Markets divisions of a top-tier Canadian bank. This role focuses on analyzing, deconstructing, and translating legacy reporting tools into scalable, enterprise-grade reporting solutions.

The ideal candidate will have deep knowledge of financial products, book-of-record systems, and reporting architecture, along with strong business analysis skills and a technical mindset.

Key Responsibilities :

• Reverse engineer legacy reports built in Excel, Access, VBA, and SQL to extract embedded business logic.
• Interpret stored procedures, Excel macros, and other code artifacts to define current-state data flows and processes.
• Document current and future state process diagrams , report specifications , and file layouts .
• Develop comprehensive functional requirements , user stories , and data mapping documents for new or redesigned reports.
• Collaborate with stakeholders from business, operations, and technology to align on reporting goals and deliverables.
• Act as a liaison between business users and development teams to ensure clear understanding of requirements and expected outputs.
• Ensure accuracy, consistency, and regulatory compliance in all reporting solutions.

Required Qualifications :

• 5+ years of experience in Reporting / Data Analysis or Business Analysis within the banking or financial services industry .
• Strong domain expertise in Wealth Management and / or Brokerage , with knowledge of :
• Account types : RRSP, Margin, TFSA, Cash Accounts
• Experience with Broadridge or similar book-of-record systems , particularly around positions, transactions, and commissions .
• Proficient in SQL and interpreting stored procedures, Excel VBA / macros
• Writing clear and structured documentation (BRDs, FRDs, report layouts, data mappings)
• Ability to operate at both high-level strategic and detailed technical levels.
• Strong communication, stakeholder management, and workshop facilitation skills.

Create a job alert for this search