Business Data Analyst - integration of a new General Ledger system into existing automated business processes - 31335
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.