Data Analyst

Ampcus, Inc; Village of Mineola (NY); On-site; USD 110,000 - 165,000; Full time

Job summary

Ampcus, Inc. is seeking a Data Conversion & Reconciliation Lead to oversee data validation, financial reconciliation, and conversion testing for ERP implementations.

The role focuses on validating conversion strategies, leading mock conversions, and ensuring data integrity for go-live cycles across CGI Advantage or similar systems. The candidate should bring extensive experience in data validation, reconciliation, and ERP environments, with strong analytical skills and the ability to coordinate

Qualifications

• 1015+ years in data validation, testing, or financial systems.
• Experience with data conversion and migration validation.
• Strong understanding of accounting principles.
• Experience with ERP systems (CGI Advantage preferred, Oracle, SAP, PeopleSoft).
• Strong analytics with ability to validate data using reports, extracts, and SQL.

Responsibilities

• Validate data migrated during ERP implementations using system reports and data extracts.
• Lead data conversion testing and validation across mock cycles and go-live readiness.
• Oversee financial reconciliation, trial balance and sub-ledger validation, and tie-outs.
• Document reconciliation rules, tolerance thresholds, and audit-ready reports.
• Coordinate with functional leads, data teams, and UAT to ensure readiness for each conversion cycle.
• Log and track data defects and coordinate retesting after fixes.
• Support go-live readiness and provide data readiness assessments.

Skills

Data validation

SQL

Financial reconciliation

ERP knowledge

Tools

CGI Advantage

Oracle

SAP

PeopleSoft

Job description

Data Analyst

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).

Key Responsibilities

• 1. Data Conversion Strategy Validation
  • Data conversion approach
  • Mapping logic from legacy to target system
• 2. 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
• 3. 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
• 4. 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)
• 5. 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
• 6. 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
• 7. 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

• 1015+ 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