Reporting Data Analyst

Overview

On Site
Accepts corp to corp applications

Skills

BRD
FRD
Business Analysis
Data Analysis

Job Details

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 / Capital Markets divisions for one of our banking clients. 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:

  • 10+ 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, etc.)

  • Ability to operate at both high-level strategic and detailed technical levels.

  • Strong communication, stakeholder management, and workshop facilitation skills.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Grand Software Solutions