Senior Data Validation Advisor; to HFM to Oracle FCCS migration and financial data validation Job Toronto area,Ontario Canada,IT/Tech

Position: Senior Data Validation Advisor (10+ years) to support HFM to Oracle FCCS migration and financial data validation

Our energy & resources client is seeking a Senior Data Validation Advisor (10+ years) to support HFM to Oracle FCCS migration and financial data validation activities

Join a major finance transformation initiative focused on migrating financial consolidation processes from HFM to Oracle FCCS. This role supports critical validation activities across financial data, journals, consolidation outputs, and reporting results for SIT, UAT, parallel close, and go-live readiness. The position works closely with finance, reporting, consolidation, technology, and implementation partner teams to identify and remediate data issues across complex consolidation environments.

Contract, Calgary, Hybrid, 3 DAYS ON SITE

6 MONTHS

Must Haves

10+ years in accounting
, financial reporting
, finance systems
, or finance transformation

Oracle FCCS
, HFM
, financial close
, consolidation
, and intercompany eliminations

ERP/EPM migration
, data validation
, journal entries
, foreign currency translation
, and financial statement reporting

Advanced Excel including reconciliations
, variance analysis
, pivot tables
, and large data set review

Professional accounting designation or equivalent senior finance experience

Nice to Have

Oracle GL / ERP data extracts

Smart View

Power Query or other data transformation tools

QTest or similar test management / defect tracking tools

Microsoft Teams and Share Point

Responsibilities

Execute FCCS data validation activities across assigned periods, entities, accounts, currencies, and consolidation levels

Validate Oracle GL/ERP data loads, converted HFM journal data, opening balances, periodic activity, and FCCS consolidation outputs

Compare FCCS results to HFM and source data using Smart View, Excel validation workbooks, reports, ad hoc queries, and reconciliations

Identify, document, triage, and retest issues related to mapping, journals, entity hierarchy, intercompany eliminations, translation, consolidation, and reporting outputs

Maintain validation evidence, screenshots, defect details, retesting results, and remediation notes in QTest or project tracking tools

Support SIT, UAT, parallel close, and go-live readiness through validation completion and acceptance criteria alignment

Track assigned work, escalate blockers and risks, and provide project status updates through meetings and huddles