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
Apply

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.


Responsibilities:

-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:

-Communication

-Detail Oriented

-Ability to work with minimal instructions

-Problem-solving skills

-Time management

-Self-starter


Education:

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.