Data Business Analyst (GCP) - London - Outside IR35 - Hybrid working (3 days onsite) - £500 per day

Korn Ferry; City of Westminster; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading consultancy firm in the City of Westminster is seeking a Business/Systems Analyst - Data to support the development of a Common Data Model (CDM). The role involves data mapping, ensuring data accuracy, and collaborating with SMEs. Ideal candidates will have hands-on SQL skills and experience with cloud platforms, particularly GCP/BigQuery. This position offers an opportunity to work in financial services data.

Qualifications

• Strong experience in data mapping, integration, or ETL processes.
• Hands-on SQL skills and experience with cloud data platforms.
• Ability to interpret complex data structures into business-friendly outputs.

Responsibilities

• Collaborate with business SMEs to analyse data structures.
• Perform detailed data mapping from source systems to CDM.
• Validate mappings using SQL/BigQuery through profiling.

Skills

Data mapping

SQL

ETL processes

Cloud data platforms

Tools

GCP/BigQuery

Data catalogue tools

Job description

We are seeking a Business/Systems Analyst - Data to play a key role in supporting the development and rollout of our Common Data Model (CDM). You'll work across multiple source systems and help ensure data is mapped, transformed, and delivered accurately into the CDM, and from the CDM into regulatory reporting, dashboards, and MI.

What You'll Do

• Collaborate with business SMEs, engineers, and architects to analyse data structures and requirements
• Perform detailed data mapping from source systems to CDM and from CDM to target domains
• Define transformation logic, business rules, and ensure harmonisation of data
• Validate mappings using SQL/BigQuery through profiling, reconciliation, and testing
• Maintain mapping documentation and contribute to the data catalogue
• Identify and help resolve data quality issues

Qualifications

• Strong experience in data mapping, integration, or ETL processes
• Hands‑on SQL skills and experience with cloud data platforms (preferably GCP/BigQuery)
• Ability to interpret complex data structures and translate them into business-friendly outputs
• Background in financial services data, especially lending or credit

Desirable Skills

• Familiarity with CDM frameworks or canonical data models
• Knowledge of regulatory reporting in UK banking
• Experience with data catalogue/metadata management tools