Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Find Jobs
Find Jobs Near You – Available Work in Your Location
Find & Apply For Data / Data Mining Analyst Jobs in Mineola, New York
Browse jobs from a variety of sources below, sorted with the most recently published, nearest to the top. Click the title to view more information and apply online.
Skip to job details
Now viewing: Data Conversion And Reconciliation Analyst
AI
Ampcus Inc.
Data Conversion And Reconciliation Analyst
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
78
out of 100
Average of individual scores
Job Description
Prev Data Conversion and Reconciliation Analyst#26-11079
Mineola, NY
Onsite 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).
This role is responsible for ensuring that data migration from legacy systems to the new ERP is accurate,plete, and financially sound, with a strong focus on balances, tie-outs, and audit readiness.
Key Responsibilities
1. 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
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 w available)
Perform:
Record count validation
Data sampling andparison
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
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 w 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