Data Conversion & Reconciliation Lead (ERP Financial Systems)

Ampcus Inc

Village of Mineola (NY)

On-site

USD 120,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Ampcus is seeking a Data Conversion & Reconciliation Lead to oversee data validation, financial reconciliation, and conversion testing for ERP implementations (CGI Advantage or similar). The role focuses on ensuring data migration accuracy, completeness, and financial soundness with emphasis on balances, tie-outs, and audit readiness.

The candidate will lead validation across mock conversions, coordinate with functional leads and UAT teams, and produce audit-ready reconciliation documentation to

Qualifications

  • 10–15+ years in data validation, testing, or financial systems.
  • Experience with data conversion, migration validation, and financial reconciliation.
  • Strong understanding of accounting principles and financial data structures.
  • Experience with ERP systems (CGI Advantage preferred, Oracle, SAP, PeopleSoft).
  • Ability to validate data using reports, extracts, and SQL queries.

Responsibilities

  • Oversee data validation, reconciliation, and conversion testing for ERP implementations.
  • Validate data migration accuracy, completeness, and financial soundness.
  • Lead mock conversions and coordinate with functional leads and UAT.
  • Develop reconciliation workbooks and exception logs.
  • Track defects and retesting results with audit-ready documentation.
  • Support go/no-go decisions with reconciliation results.

Skills

Data validation
Financial reconciliation
Conversion testing
SQL queries
Data mapping
Analytics

Tools

CGI Advantage
Oracle ERP
SAP ERP
PeopleSoft

Job description

Role Overview

Ampcus is seeking a Data Conversion & Reconciliation Lead to oversee data validation, financial reconciliation, and conversion testing for ERP implementations (CGI Advantage or similar). This role is responsible for ensuring that data migration from legacy systems to the new ERP is accurate, complete, and financially sound, with a strong focus on balances, tie-outs, and audit readiness.

Key Responsibilities
  • Data Conversion Strategy Validation
  • Review and validate:
    • Data conversion approach
    • Mapping logic from legacy to target system
  • Ensure:
    • Completeness, accuracy, and referential integrity of data
  • Identify:
    • Data gaps, inconsistencies, and risks
  • Conversion Testing & Execution Support
  • Lead validation across:
    • Mock conversions (Mock 1, Mock 2, Dress Rehearsal)
  • Coordinate with:
    • Functional Leads
    • Data teams
    • UAT team
  • Ensure readiness for each conversion cycle
  • Financial Reconciliation & Tie-Outs (Critical Responsibility)
  • Perform and oversee:
    • Trial balance validation
    • Sub-ledger to GL reconciliation
    • Fund-level and cross-fund balancing
  • Validate:
    • Beginning balances
    • Roll-forward data
    • Transaction continuity
  • Define and enforce:
    • Reconciliation rules and tolerance thresholds
  • Data Validation & Analysis
  • Validate migrated data using:
    • System reports
    • Data extracts
    • Query tools (SQL or equivalent where available)
  • Perform:
    • Record count validation
    • Data sampling and comparison
    • Exception analysis
  • Investigate and categorize:
    • Data issues (mapping, data quality, configuration, integration)
  • Reconciliation Reporting & Documentation
  • Develop and maintain:
    • Reconciliation workbooks
    • Exception logs
    • Conversion validation reports
  • Track:
    • Issues, defects, and retesting results
  • Provide:
    • Clear documentation for audit and sign-off
  • Defect Management & Resolution Support
  • Log and track:
    • Data-related defects and discrepancies
  • Support:
    • Root cause analysis
    • Retesting after fixes
  • Coordinate with:
    • Implementation team and functional leads
  • Go-Live Readiness Support
  • Provide:
    • Data readiness assessment
    • Financial validation status
  • Support:
    • Go/no-go decision with reconciliation results
  • Ensure:
    • No material financial discrepancies remain
Required Qualifications
  • 10–15+ years in data validation, testing, or financial systems
  • Strong experience with:
    • Data conversion and migration validation
    • Financial reconciliation (trial balance, sub-ledgers)
  • Deep understanding of:
    • Accounting principles and financial data structures
  • Experience with:
    • ERP systems (CGI Advantage preferred, Oracle, SAP, PeopleSoft)
  • Strong analytical skills with ability to:
    • Validate data using reports, extracts, and query tools (SQL where applicable)
Preferred Qualifications
  • Public sector / fund accounting experience
  • Experience with:
    • Large-scale ERP transformations
    • Multi-phase data conversion efforts
  • Familiarity with:
    • Data profiling and mapping techniques
Work Model
  • Onsite-heavy during conversion cycles and UAT execution
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Conversion and Reconciliation Analyst
Data Conversion and Reconciliation Analyst

Ampcus, Inc • Village of Mineola (NY)

On-site
USD 110,000 - 160,000
ERP Data Migration & Reconciliation Lead
ERP Data Migration & Reconciliation Lead

Ampcus Inc • Village of Mineola (NY)

On-site
USD 120,000 - 160,000
ERP Data Conversion & Reconciliation Lead
ERP Data Conversion & Reconciliation Lead

Ampcus, Inc • Village of Mineola (NY)

On-site
USD 110,000 - 160,000
Implementation-Conversion Analyst I
Implementation-Conversion Analyst I

Ampcus, Inc • Milwaukee (WI)

Hybrid
USD 60,000 - 80,000
Functional UAT Lead –Finance & Controllership (GL, Budgeting, Assets, Treasury)
Functional UAT Lead –Finance & Controllership (GL, Budgeting, Assets, Treasury)

Ampcus Inc • Village of Mineola (NY)

On-site
USD 110,000 - 160,000
Data Conversion Lead (1657)
Data Conversion Lead (1657)

Highstreet • United States

On-site
USD 120,000 - 170,000
Competitive benefits
Senior ERP Project Manager – Data Conversion
Senior ERP Project Manager – Data Conversion

JRD Systems • Michigan

Remote
USD 120,000 - 180,000
ERP Data Conversion Lead - Finance, Procurement & O2C
ERP Data Conversion Lead - Finance, Procurement & O2C

Capgemini • City of Albany (NY)

Hybrid
USD 63,000 - 99,000
Oracle Fusion Technical Conversion Lead
Oracle Fusion Technical Conversion Lead

TechDigital Group • Santa Clara (CA)

On-site
USD 120,000 - 160,000
Data Conversion Analyst: Liaison and Migration Specialist
Data Conversion Analyst: Liaison and Migration Specialist

Compunnel Inc. • Westlake (OH)

On-site
USD 70,000 - 90,000