Business Data Analyst - integration of a new General Ledger system into existing automated business processes - 31335

Job Type: Contract
Positions to fill: 1
Start Date: Sep 18, 2023
Job End Date: Sep 17, 2024
Pay Rate: Hourly: Negotiable
Job ID: 132251
Location: Toronto

Business Analyst 

Location Address: 150 King Street W 18th Floor – hybrid – once/twice onsite per week

Contract Duration: 1 year

Story Behind the Need

Business group: Group Treasury Product Control

This team focuses on daily profit/loss reporting and balance sheet substantiation and analysis

The successful candidate will be working on the integration of a new General Ledger system into existing automated business processes that support P&L production, balance sheet substantiation, balance sheet analytics, and regulatory reporting.


-analyze current state

-offer solutions to integrate new system

-update process documents

-performing UAT regression testing

-Supporting end users through transition phase and post-project implementation

- Extract and export data to/from spreadsheet via code

-Filter and loop through data

-Create code that can call functions to work through repetitive processes

-Extract specific data based on conditions

-Join sets of data together

-Add data to the database based on conditional statements

-Open and run macros in excel

-Edit data in excel

-Compute and export data in a python code (to replace calculations being done in excel)

Must Have Skills:

1) 5+ years of experience with VBA (extract/export data, create code)

2) 3+ years of experience with SQL (extract/join data)

3) Proficiency with MS tools (excel, word)

4) 8+ years of experience with Data Analysis (data flows, data reconciliation)

Nice-To-Have Skills:

1)Python Experience

2)Familiarity with Accounting Principles (General Ledgers, GLs, etc.)

3)Capital Markets product knowledge

Soft Skills Required:


-Detail Oriented

-Ability to work with minimal instructions

-Problem-solving skills

-Time management



Post-Secondary in Finance or related Field

Best vs. Average Candidate

The best candidate would have the necessary coding/testing/data analysis experience. They would be able to hit the ground running with minimal supervision/instructions. The candidate should take ownership of work.