Data Analyst

We are looking for a Data Analyst! Reach out if you are interested and feel free to refer friends/colleagues!

Type of Employment: Contract
Title: Data Analyst
Term: 12 months contract with extension
Location: Toronto – Hybrid once or twice a week on-site
Job ID number: C1266

Brief Description of Duties:

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.

Candidate Value Proposition:

The successful candidate will have the opportunity to be part of a large project. There would be opportunity to network and work with various technology, finance, and operations team as well senior management. The candidate will be working on a highly visibility project.

Typical Day in Role:

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

• Experience with VBA (extract/export data, create code)
• Experience with SQL (extract/join data)
• Proficiency with MS tools (excel, word)
• Experience with Data Analysis (data flows, data reconciliation)

Nice to Have Skills: 

• Python Experience
• Familiarity with Accounting Principles (General Ledgers, GLs, etc.)
• Capital Markets product knowledge

Soft Skills Required: 

• Communication
• Detail Oriented
• Ability to work with minimal instructions
• Problem-solving skills
• Time management
• Self-starter