Data Analyst


Posted 9 months ago

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

Job Features

Job CategoryData analyst

Apply Online