Data Profiling Jobs

1 job found

1d ago

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

TLK International Mineola, NY

Mineola, NY

1d ago

$80k - $95k/yr Full time Analyst Data Analysis Data Analytics

Apply Now

Job Description

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

View full job page →

Get Job Alerts

New jobs delivered to your inbox.