Reporting Data Analyst

Grand Software Solutions; Toronto; On-site; CAD 75,000 - 120,000; Full time

Job summary

A leading company in the financial services sector seeks a Senior Reporting Data Analyst to enhance enterprise reporting within Wealth Management. The role involves analyzing and transforming legacy reporting tools into scalable solutions, and requires extensive experience in banking data analysis and strong technical skills.

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.
• Ability to operate at both high-level strategic and detailed technical levels.

Responsibilities

• Reverse engineer legacy reports built in Excel, Access, VBA and SQL.
• Develop comprehensive functional requirements, user stories, and data mapping documents.
• Collaborate with stakeholders from business operations and technology.

Skills

Cognos

Microsoft Access

SQL

Crystal Reports

Financial Report Writing

Power BI

Pivot tables

SSRS

Tableau

Regulatory Reporting

SAS

Data Analysis Skills

Job description

Job Title : Senior Reporting Data Analyst

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 :

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.

Key Skills

Cognos,Microsoft Access,SQL,Crystal Reports,Financial Report Writing,Power BI,Pivot tables,ssrs,Tableau,Regulatory Reporting,SAS,Data Analysis Skills

Employment Type : Full Time

Experience : years

Vacancy : 1

Create a job alert for this search