Location Address: WFH until BCP ends (potentially January) – Toronto
Contract Duration: 6 month contract (Possibility for extension or Convert to FTE)
Story Behind the Need
Finance: This group deals with a lot of project work involving EQT and chart accounts mapping.
Project: Working on the IFRS 17 implementation project and other projects as needed. This project is still in wave 1.
Typical Day in Role:
• Candidate needs to have a strong background in Accounting and Finance
• Talk to both business users and IT developers on reports and communicate reporting requirements
• Dealing with accounting systems (Peoplesoft) and mapping of accounts.
• Assisting on EQT (equivalency testing) process – involving data mining and working with large datasets
• Flexibility to handle multiple projects on a day-to-day basis
• Working with Audit Command Language (ACL)
Candidate Requirements/Must Have Skills:
1) 5-7 Years Business Analyst Experience in the Financial Services Industry
2) Experience with System Implementation – migrating general ledgers or adapting a new standard
3) Excellent Communication and analytical skills – both written and verbal
4) Advanced experience in SQL and Excel – ex. Pivot tables
1) Understand what is required under the Accounting Standard (such as IFRS-17)
2) Hands-On Experience with Peoplesoft General Ledger System, OBI
3) Regulatory Reporting Standards knowledge and experience with tree hierarchy reporting structures (able to build reports)
4) Familiar with Insurance Accounting Standards
Soft Skills Required:
– Able to show Initiative to users for any requirements that might have been missed
– Organizational and Project Management Skills
– Excellent communication
Degrees: Bachelor's degree in Business, Finance, or related field
Certifications: Nice to have CPA Designation – or working towards
Best vs Average: The ideal candidate would be technically inclined (SQL, Advanced Excel, ACL) and have some form of professional designation or knowledge of accounting. They will need to understand accounting concepts to perform well, but will not assume the role of an accountant themselves beyond potentially some quarterly entries (training would be provided for this).