Data Analyst

• Title: Data Analyst – Data Conversion & Validation (ERP Financial Systems)
• Location: Nassau County, NY 11501
• Duration: Full time

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 | Analyse legacy data to:
• Assess data quality, completeness, and structure
• Identify anomalies, duplicates, and inconsistencies
• 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
• Record count validation
• Control total validation
• Data comparison between legacy and target systems
• 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)
• Beginning balances and roll-forwards
• Transaction-level data where applicable
• 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)
• Data mapping and transformation outputs
• Crosswalk logic and data normalization
• 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
• Data discrepancies and exceptions
• Support troubleshooting and root cause analysis
• 6. Reporting & Documentation
• Validation reports
• Exception logs
• Data comparison summaries
• Findings and discrepancies
• Validation results for audit purposes
• Required Qualifications:
• 4–8+ years in data analysis, QA, or data validation
• 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
• Data conversion / migration projects
• Understanding of:
• Financial processes (GL, AP, AR, budgeting)
• Public sector or fund accounting
• Data profiling and ETL validation