Job Title: Database / Data Analyst – Data Conversion & Validation (ERP Financial Systems)
Location: Mineola, New York 11501
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:
o Assess data quality, completeness, and structure
o Identify anomalies, duplicates, and inconsistencies
• Support:
o Data discovery and profiling activities
o Data quality assessments across modules (GL, AP, AR, Projects, etc.)
2. Data Validation & Conversion Testing
• Validate converted data using:
o System reports
o Data extracts
o SQL queries
• Perform:
o Record count validation
o Control total validation
o Data comparison between legacy and target systems
• Support validation across:
o Pre-load, load, and post-load phases
3. Financial Data Validation & Reconciliation
• Support reconciliation of:
o General Ledger balances
o Sub-ledger data (AP, AR, Assets, Projects)
• Validate:
o Beginning balances and roll-forwards
o Transaction-level data where applicable
• Assist in:
o Trial balance validation
o Fund-level and cross-fund reconciliation
4. Conversion Data Support
• Support validation of:
o Master data (vendors, customers, projects, grants)
o Open transactions (AP, AR, POs, contracts)
• Verify:
o Data mapping and transformation outputs
o Crosswalk logic and data normalization
• Participate in:
o Mock conversion cycles and dress rehearsal validation
5. Data Querying & Analysis
• Develop and execute:
o SQL queries (where available) for:
Record counts
Control totals
Data integrity checks
• Analyze:
o Data discrepancies and exceptions
• Support troubleshooting and root cause analysis
6. Reporting & Documentation
• Prepare:
o Validation reports
o Exception logs
o Data comparison summaries
• Document:
o Findings and discrepancies
o Validation results for audit purposes
Required Qualifications
• 4–8+ years in data analysis, QA, or data validation
• Experience with:
o Data validation and reconciliation
o Data comparison across systems
• Strong analytical skills with ability to:
o Interpret and validate financial data
• Experience with:
o SQL (data validation, querying, analysis)
• Familiarity with:
o ERP systems (CGI Advantage, Oracle, SAP, PeopleSoft)
Preferred Qualifications
• Experience with:
o Data conversion / migration projects
• Understanding of:
o Financial processes (GL, AP, AR, budgeting)
• Exposure to:
o Public sector or fund accounting
• Experience with:
o Data profiling and ETL validation
