Reporting Data Analyst
Reporting Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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 / 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.
-
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.
Employment Type
Full Time
