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

TLK International is seeking a Database / Data Analyst to work onsite in Nassau County, NY. This ERP data conversion and validation role focuses on data profiling, validation, and reconciliation to ensure migrated data remains accurate and reconcilable across legacy and target systems. The position offers a salary range of $80,000–$95,000 per year and requires solid experience in data analysis, QA, or data validation. You will collaborate with the Data Conversion Lead, Functional Leads, and UAT teams throughout discovery, validation, and post go-live phases.

Responsibilities

• Data Profiling & Analysis: Examine legacy data to assess quality, completeness, and structure; identify anomalies, duplicates, and inconsistencies; conduct data discovery and profiling across modules such as GL, AP, AR, Projects, and more.
• Data Validation & Conversion Testing: Validate converted data using system reports, data extracts, SQL queries, record-count validation, control totals, and data comparisons between legacy and target systems, covering pre-load, load, and post-load activities.
• 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, and fund-level or cross-fund reconciliation.
• Conversion Data Support: Validate master data (vendors, customers, projects, grants); open transactions (AP, AR, POs, contracts); data mapping and transformation outputs; crosswalk logic and data normalization; participate in mock conversion cycles and dress rehearsals.
• Data Querying & Analysis: Develop and execute SQL queries for record counts, control totals, data integrity checks, discrepancies, and root-cause analysis to support troubleshooting.
• Reporting & Documentation: Produce validation reports, exception logs, data comparison summaries, and validation results suitable for audit purposes.

Requirements

• 4–8+ years in data analysis, QA, or data validation
• Data validation and reconciliation experience
• Data comparison across systems
• Strong analytical skills
• Ability to interpret and validate financial data
• Experience with SQL for data validation, querying, and analysis
• ERP systems familiarity (CGI Advantage, Oracle, SAP, PeopleSoft)
• Data conversion and migration project experience
• Understanding of financial processes (GL, AP, AR, budgeting)
• Public sector or fund accounting background
• Data profiling and ETL validation experience

Technologies

• SQL
• CGI Advantage
• Oracle
• SAP
• PeopleSoft