> Markdown version of [/jobs/ext/1406991-data-analyst](https://www.wearedevelopers.com/jobs/ext/1406991-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Analyst

- **Company:** Ampcus Inc
- **Location:** Mineola, NY, United States
- **Contract:** Permanent contract
- **Skills:** Software Bug Management, Data Validation, Data Conversion, Data Integrity, Data Migration, Data Profiling, Oracle (Applications), Regression Testing, SAP (Applications), SQL Databases, People Soft, Data Management, Legacy Systems, Database Tools and Utilities
- **Published:** July 23, 2026
- **Apply:** https://jobs.localjobnetwork.com/apply/add/87816201/1

## About the Role

* 1015+ 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 where 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

## Description

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, complete, 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 where available)
 * Perform:
 + Record count validation
 + Data sampling and comparison
 + 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


## Related Videos

- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [The Chief Joy Officer and Decoding Motivation@Work](https://www.wearedevelopers.com/videos/1501-the-chief-joy-officer-and-decoding-motivation-work)
- [Exploring 5 Key Applications of AI Abundance with Blockchain Assurance](https://www.wearedevelopers.com/videos/971-exploring-5-key-applications-of-ai-abundance-with-blockchain-assurance)
- [Database Magic behind 40 Million operations/s](https://www.wearedevelopers.com/videos/748-database-magic-behind-40-million-operations-s)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)