> Markdown version of [/jobs/ext/609925-database-data-analyst-data-conversion-validation-erp-financial-systems](https://www.wearedevelopers.com/jobs/ext/609925-database-data-analyst-data-conversion-validation-erp-financial-systems). 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).

---

# Database / Data Analyst - Data Conversion & Validation (ERP Financial Systems)

- **Company:** TLK INTERNATIONAL, INC.
- **Location:** New York, NY, United States
- **Experience:** Experienced
- **Salary:** $80,000.0 - $95,000.0
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Databases, Data Validation, Data Conversion, Data Discovery, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Normalization, Data Profiling, Database Queries, Oracle (Applications), SAP (Applications), SQL Databases, Data Processing, People Soft, Data Management, Crosswalk, Legacy Systems
- **Published:** June 12, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=a935897d7d06ea24

## About the Role

Do you have experience in SQL?, * 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

## Description

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., 1. Data Profiling & Analysis | Analyze 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


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [The Chief Joy Officer and Decoding Motivation@Work](https://www.wearedevelopers.com/videos/1501-the-chief-joy-officer-and-decoding-motivation-work)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [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)
- [Building Organizations That Can Actually Adapt](https://www.wearedevelopers.com/videos/100316-building-organizations-that-can-actually-adapt)
- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)