Data Validation Senior Advisor – FCCS Project:
On behalf of our finance client, Procom is searching for a Data Validation Senior Advisor – FCCS Project for a 8-month role. This position is a hybrid position with 3 days onsite at our client’s Calgary office.
Data Validation Senior Advisor – FCCS Project - Job Description:
The project involves transitioning the organization's financial consolidation platform from HFM to Oracle FCCS. This is a migration project where data validation is critical to ensure FCCS is ready for SIT, UAT, parallel close, and the January 2027 go-live.
Data Validation Senior Advisor – FCCS Project - Responsibilities:
- Execute FCCS data validation activities for 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 other source data using Smart View, Excel validation workbooks, reports, ad hoc queries, and reconciliations.
- Review base entity and consolidation-level results in functional currency and CAD, including investigation of material variances.
- Identify, document, triage, and retest issues related to mapping, account rollups, entity hierarchy, journals, intercompany eliminations, plug accounts, translation, consolidation, data loads, and reporting outputs.
- Maintain validation evidence, status updates, screenshots, defect details, retesting results, and remediation notes in QTest or other project tracking tools.
- Partner with finance, reporting, consolidation, technology, and implementation resources to support timely issue resolution.
Data Validation Senior Advisor – FCCS Project - Mandatory Skills:
- Senior-level experience in accounting, consolidations, financial reporting, finance systems, or finance transformation.
- Strong understanding of financial close, consolidation, legal entity reporting, intercompany eliminations, foreign currency translation, journal entries, and financial statement reporting.
- Experience validating data between legacy and target systems during a system implementation, ERP/EPM migration, or finance transformation.
- Ability to investigate complex data issues, trace balances across systems, identify root causes, and communicate findings clearly.
- Advanced Excel skills, including complex reconciliations, variance analysis, formulas, pivot tables, and large data set review.
- Strong documentation discipline, including the ability to maintain clear validation evidence, issue descriptions, test results, and status reporting.
- Ability to work independently, manage assigned validation work, and escalate risks or blockers in a fast-paced project environment.
Data Validation Senior Advisor – FCCS Project – Nice-to-Have Skills:
- Professional accounting designation or equivalent senior finance experience.
- Experience with Oracle FCCS / Oracle EPM Cloud.
- Familiarity with HFM and Oracle GL / ERP data extracts.
- Proficiency in Smart View and advanced Excel validation templates.
- Experience with QTest or similar test management / defect tracking tools.
Data Validation Senior Advisor – FCCS Project – Assignment Length:
This is a 8-month contract position.
Data Validation Senior Advisor – FCCS Project - Start Date:
ASAP.
Data Validation Senior Advisor – FCCS Project - Assignment Location:
Calgary, Alberta, Canada, with a hybrid work arrangement requiring 3 days in the office.
