Remote Data Migration & Quality Analyst (ETL, SQL)

Korn Ferry Group; United States; Remote; USD 74,000 - 98,000; Full time

Job summary

Korn Ferry Group is seeking a Data Analyst for a financial services client in the UK. The role focuses on SQL-driven data analysis, data profiling, and ensuring data quality ahead of migration. The engagement is remote and initially 3 months, with a daily rate of £350 outside IR35.

The ideal candidate will map legacy data, validate source-to-target migrations, and support ETL testing within a regulated financial services environment.

Qualifications

• Experience with SQL-based data analysis, profiling and quality assessment.
• Ability to map legacy data to target structures and define transformation rules.
• Strong data cleansing and transformation capabilities for migration readiness.
• Proven data reconciliation, validation and control total checks.
• Familiarity with ETL testing and data governance in financial services.

Responsibilities

• Data analysis and profiling: Using SQL to extract, analyse, profile and assess large datasets, identifying data anomalies, inconsistencies, duplicates and quality issues.
• Source-to-target data mapping: Analysing Legacy data structures, defining mapping rules, transformation logic and business rules to ensure accurate migration into target systems.
• Data cleansing and transformation: Investigating data quality issues, applying transformation rules, standardising formats and resolving gaps or inconsistencies ahead of migration.
• Data reconciliation and validation: Performing source-to-target comparisons, control total checks, record-level validation and balance reconciliations to confirm data completeness and accuracy.
• ETL and migration testing: Supporting migration test cycles, executing data validation scripts, analysing test results, investigating defects and working with technical teams to resolve discrepancies.
• Data quality and governance: Maintaining data integrity, documenting migration rules, producing evidence of validation, and ensuring compliance with financial services data standards and audit requirements.

Skills

SQL

Data analysis

Data profiling

Data transformation

Data cleansing

Data reconciliation

ETL testing

Data governance

Tools

ETL/Data integration technologies

Excel

Job description

Korn Ferry Group is seeking a Data Analyst for a financial services client in the UK. The role focuses on SQL-driven data analysis, data profiling, and ensuring data quality ahead of migration. The engagement is remote and initially 3 months, with a daily rate of £350 outside IR35.

The ideal candidate will map legacy data, validate source-to-target migrations, and support ETL testing within a regulated financial services environment.