Job Description
Role : Database / Data Analyst
Work site: Mineola, New York
Duration: Full Time/Permanent or 6-12+ Months Assignment
Role Overview
Ampcus is seeking a Data Analyst to support data conversion, validation, and reconciliation activities for ERP implementations (CGI Advantage or similar).
This role is responsible for performing data profiling, validation, and financial analysis to ensure that migrated data is accurate, complete, and fully reconcilable to legacy systems. The analyst works closely with the Data Conversion Lead, Functional Leads, and UAT teams to validate data across all phases—from discovery through post–go-live.
Key Responsibilities
1. Data Profiling & Analysis
Analyze legacy data to:
Assess data quality, completeness, and structure
Identify anomalies, duplicates, and inconsistencies
Support:
Data discovery and profiling activities
Data quality assessments across modules (GL, AP, AR, Projects, etc.)
2. Data Validation & Conversion Testing
Validate converted data using:
System reports
Data extracts
SQL queries
Perform:
Record count validation
Control total validation
Data comparison between legacy and target systems
Support validation across:
Pre-load, load, and post-load phases
3. Financial Data Validation & Reconciliation
Support reconciliation of:
General Ledger balances
Sub-ledger data (AP, AR, Assets, Projects)
Validate:
Beginning balances and roll-forwards
Transaction-level data where applicable
Assist in:
Trial balance validation
Fund-level and cross-fund reconciliation
4. Conversion Data Support
Support validation of:
Master data (vendors, customers, projects, grants)
Open transactions (AP, AR, POs, contracts)
Verify:
Data mapping and transformation outputs
Crosswalk logic and data normalization
Participate in:
Mock conversion cycles and dress rehearsal validation
5. Data Querying & Analysis
Develop and execute:
SQL queries (where available) for:
Record counts
Control totals
Data integrity checks
Analyze:
Data discrepancies and exceptions
Support troubleshooting and root cause analysis
6. Reporting & Documentation
Prepare:
Validation reports
Exception logs
Data comparison summaries
Document:
Findings and discrepancies
Validation results for audit purposes
Required Qualifications
4–8+ years in data analysis, QA, or data validation
Experience with:
Data validation and reconciliation
Data comparison across systems
Strong analytical skills with ability to:
Interpret and validate financial data
Experience with:
SQL (data validation, querying, analysis)
Familiarity with:
ERP systems (CGI Advantage, Oracle, SAP, PeopleSoft)
Preferred Qualifications
Experience with:
Data conversion / migration projects
Understanding of:
Financial processes (GL, AP, AR, budgeting)
Exposure to:
Public sector or fund accounting
Experience with:
Data profiling and ETL validation