Job Title: Senior Reporting Data Analyst

Client: Leading Canadian Banking Institution

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:
• Financial instruments: Equities, Fixed Income, Mutual Funds, etc.
• 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.