Loading...

Data Analyst // Mineola, NY

Mineola, New York, US
70
Posted Sep 16, 2026

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

Interested in this job?

**

Log in to see your Jobscore and apply to this job.

Quick Facts

Company
Ampcus
Location
Mineola, New York, US
Salary
70