Job Title: Data Validation Senior Advisor – FCCS Project
Location: Calgary, AB (Hybrid)
Duration: 6+ months

Project: HFM to Oracle FCCS Migration
Job Description:
We are seeking an experienced Data Validation Senior Advisor to support a large-scale finance transformation initiative involving the migration of the organization's financial consolidation platform from Hyperion Financial Management (HFM) to Oracle Financial Consolidation and Close Cloud Service (FCCS). This role will play a critical part in validating financial data throughout the migration lifecycle to ensure the accuracy, completeness, and integrity of consolidation, reporting, and financial close processes.
The successful candidate will work closely with Finance, Financial Reporting, Consolidation, Technology, and implementation partner teams to validate converted data, investigate variances, support issue resolution, and provide documented evidence of testing throughout System Integration Testing (SIT), User Acceptance Testing (UAT), Parallel Close, and production readiness activities.

Key Responsibilities

• Execute assigned FCCS data validation activities across entities, accounts, currencies, reporting periods, and consolidation levels.
• Validate Oracle GL/ERP data loads, opening balances, converted HFM journals, monthly financial activity, and FCCS consolidation outputs.
• Compare financial results between HFM, Oracle FCCS, and source systems using Smart View, Excel validation workbooks, reconciliation reports, ad hoc queries, and financial reports.
• Review financial results at both the base entity and consolidated reporting levels in functional currencies and CAD.
• Perform variance analysis and investigate material differences between legacy and target systems.
• Validate:
  • Opening balances
  • Monthly financial activity
  • Converted journal entries
  • Consolidation calculations
  • Foreign currency translation
  • Intercompany eliminations
  • Plug accounts
  • Reporting outputs
  • Financial statement impacts
• Identify, document, classify, and track validation issues related to:
  • Data mapping
  • Account hierarchies
  • Entity structures
  • Journal conversions
  • Consolidation processing
  • Currency translation
  • Data integrations
  • Reporting outputs
• Maintain detailed validation documentation, including:
  • Test evidence
  • Screenshots
  • Validation workpapers
  • Issue logs
  • Defect details
  • Retesting results
  • Remediation notes
• Record and manage defects using QTest or similar test management tools.
• Partner with Finance, Reporting, Technology, Consolidation, and implementation teams to support issue investigation and timely resolution.
• Retest resolved defects and confirm successful remediation before closure.
• Provide regular progress updates, communicate risks and blockers, and participate in project meetings and status discussions.
• Support project readiness activities for SIT, UAT, Parallel Close, and production go-live.
• Recommend improvements to validation templates, documentation standards, and repeatable validation processes to increase efficiency and reduce manual effort.

Required Qualifications

• Senior-level experience in accounting, financial reporting, financial consolidations, finance systems, or finance transformation projects.
• Strong understanding of:
  • Financial close processes
  • Financial consolidations
  • Legal entity reporting
  • Journal entries
  • Intercompany eliminations
  • Foreign currency translation
  • Financial statement reporting
• Experience validating financial data between legacy and target systems during finance system implementations, ERP/EPM migrations, or transformation initiatives.
• Demonstrated ability to investigate complex financial data issues, perform root cause analysis, and communicate findings effectively.
• Advanced Microsoft Excel skills, including:
  • Complex formulas
  • Pivot tables
  • Large dataset analysis
  • Variance analysis
  • Financial reconciliations
• Strong analytical, problem-solving, and documentation skills.
• Ability to work independently while managing multiple validation activities within project timelines.
• Excellent verbal and written communication skills with the ability to collaborate across cross-functional teams.
• Professional accounting designation (CPA or equivalent) or comparable senior finance experience is preferred.

Preferred Technical Skills

• Oracle Financial Consolidation and Close Cloud Service (FCCS)
• Hyperion Financial Management (HFM)
• Oracle General Ledger (GL)
• Oracle ERP financial data extracts
• Oracle Smart View
• Microsoft Excel (Advanced)
• Power Query or similar data transformation tools
• QTest or comparable test management and defect tracking applications
• Microsoft Teams
• SharePoint

Core Competencies

• Financial Data Validation
• Financial Consolidation
• Financial Reporting
• General Ledger Validation
• Journal Validation
• Data Reconciliation
• Variance Analysis
• Root Cause Analysis
• Financial Systems Testing
• System Integration Testing (SIT)
• User Acceptance Testing (UAT)
• Parallel Close Validation
• Issue Management
• Defect Tracking
• Financial Controls
• Documentation Management
• Stakeholder Collaboration
• Process Improvement
• Risk Identification and Escalation
• Cross-functional Communication

Ideal Candidate Profile
The ideal candidate is a senior finance professional with hands-on experience validating financial data during finance system implementations or consolidation platform migrations. They possess a strong understanding of financial close and consolidation processes and are comfortable analyzing large financial datasets to identify discrepancies and support issue resolution. They are detail-oriented, highly organized, and capable of maintaining comprehensive validation documentation while collaborating effectively with finance, technology, reporting, and implementation teams. They thrive in fast-paced project environments, adapt to evolving priorities, and continuously seek opportunities to improve validation processes through standardization and efficiency.

Key Success Measures

• Complete assigned validation activities accurately and within project timelines.
• Ensure validation evidence is comprehensive, traceable, and audit-ready.
• Identify, document, and communicate financial data issues early in the validation cycle.
• Support timely investigation, remediation, and successful retesting of defects.
• Provide clear visibility into validation progress, project risks, and outstanding issues.
• Contribute to the successful readiness of Oracle FCCS for SIT, UAT, Parallel Close, and production go-live.
• Help improve the consistency, quality, and efficiency of financial data validation processes throughout the migration project.

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $100.67/hr - $105.00/hr.