Financial Data Consultant

IFG International Financial Group Ltd; Ontario; On-site; CAD 70,000 - 90,000; Full time

Job summary

A major financial institution is seeking a Financial Data Consultant for a 6-month contract. The role involves analyzing GL hierarchies, ensuring compliance with IFRS and US GAAP, and supporting a transition to ERP systems. The ideal candidate will possess strong analytical skills and advanced Excel proficiency.

Qualifications

• Experience in data mapping, financial reporting structures, or hierarchy analysis.
• Advanced MS Excel skills including VLOOKUPs and pivot tables.

Responsibilities

• Analyze existing GL hierarchies under IFRS and US GAAP.
• Collaborate with finance and technical teams for data alignment.
• Create mapping documents and impact analysis reports.

Skills

Analytical Skills

Communication

Attention to Detail

Education

Experience in Data Mapping

Knowledge of IFRS and US GAAP

Tools

MS Excel

SAP S4/HANA

Job description

Our client, a Major Financial Institution, is seeking a highly analytical Financial Data Consultant for an initial 6-month contract to support a critical initiative. The role involves analyzing and rationalizing the current General Ledger (GL) hierarchy, comparing how financial data is reported externally under IFRS and US GAAP with its internal structure. The successful candidate will map and reconcile key differences, contributing to long-term change management as the bank transitions from legacy systems to ERP/GL.

The Key Responsibilities include:

1. Analyze existing GL hierarchies and understand entry flows under IFRS and US GAAP.
2. Review and document current financial reporting processes under both standards and map them to the GL structure.
3. Identify gaps, discrepancies, and misalignments; propose corrective actions.
4. Collaborate with finance, external reporting, and technical teams to ensure data and reporting alignment.
5. Support changes across approximately 10,000 GL accounts, considering hierarchy nuances and downstream impacts.
6. Assist in restructuring the S4 hierarchy and contribute to change management efforts.
7. Create detailed mapping documents, change logs, and impact analysis reports.
8. Utilize Excel tools (VLOOKUPs, pivot tables) for data analysis and reconciliation.
9. Qualifications include:

• Experience in data mapping, financial reporting structures, or hierarchy analysis within banking or large enterprises.
• Knowledge of IFRS and US GAAP frameworks and accounting principles.
• Advanced MS Excel skills (VLOOKUPs, pivot tables, etc.).
• Experience with SAP S4/HANA is a strong asset.
• Exceptional analytical skills and attention to detail.
• Ability to work with large datasets and derive insights from complex structures.
• Excellent communication and documentation skills.
• Self-motivated with the ability to work cross-functionally in a collaborative environment.

The Nice to Have skills include:

• Experience supporting GL hierarchy redesign or external reporting transformation projects.
• Familiarity with financial reporting systems and tools used in large banks.
• Understanding of change management processes in financial or regulatory contexts.