Data Consultant

Korn Ferry Group; United States; A distancia; USD 74.000 - 98.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

SQL

Data analysis

Data profiling

Data transformation

Data cleansing

Data reconciliation

ETL testing

Data governance

Herramientas

ETL/Data integration technologies

Excel

Descripción del empleo

• 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.

  Experience working with complex financial datasets, Legacy banking or financial platforms, and tools such as SQL, Excel and ETL/data integration technologies would be particularly valuable.

  I am currently looking for a Data Analyst for a financial services company in the UK.

  This is an initial 3 month engagement working remotely paying £350/day Outside IR35