About The Role

FDM is a global business and technology consultancy seeking a Senior Data Engineer to work for our client within the Insurance sector. This is initially a 3-month contract with the potential to extend and will be a hybrid role based in London.

Our client is seeking an experienced Data Engineer to play a key role in a high-profile broker data remediation programme. The successful candidate will be responsible for designing, implementing, and optimising data models and transformation pipelines to create a clean, governed, and analytics-ready broker data domain. You will work closely with data modelling, platform, and business teams to resolve long-standing data quality and consistency challenges across multiple systems.

Responsibilities

Build robust ETL/ELT pipelines using Databricks (SQL, Python, Delta Lake) to implement data remediation logic
Develop complex SQL transformations including deduplication, hierarchical roll-ups, hash key generation, and SCD Type 2 modelling
Design and implement scalable data models (star, snowflake, and hierarchical structures) aligned to enterprise standards
Engineer automated processes to improve data quality, standardisation, and reconciliation across multiple source systems
Collaborate with data governance teams to embed data quality rules, lineage, and metadata into pipelines
Translate logical data models into performant physical models for downstream consumption
Work closely with cross-functional teams and SMEs to refine business rules and define data structures
Produce clear technical documentation and contribute to design workshops and model reviews

About You

Requirements

5 years experience in data engineering within complex enterprise environments
Advanced SQL expertise (window functions, complex joins, CTEs, deduplication, large-scale optimisation)
Hands-on experience with Databricks and Delta Lake (including optimisation, incremental processing, and schema evolution)
Proficiency in Python/PySpark for building scalable data pipelines and implementing transformation logic
Strong data modelling experience (star schema, snowflake, dimensional modelling, master data, SCD handling)
Experience working with large, complex datasets and resolving data quality issues across multiple systems
Experience with data remediation, migration, or master data management programmes
Strong stakeholder engagement and communication skills

About Us

Why join us?

Career coaching, mentoring and access to upskilling throughout your entire FDM career
Initial upskilling pre-assignment that has been accredited by TechSkills
Assignments with global companies and opportunities to work abroad
Opportunity to obtain certifications from Microsoft, Salesforce, Cisco and more

About Us

FDM is an award-winning global leader in tech and business talent solutions, backed by more than 35 years of industry experience. We have centres across Europe, North America, and Asia-Pacific, and a global workforce of over 2500 employees. FDM has shown exponential growth throughout the years, firmly establishing itself as an award-winning employer, currently listed on the FTSE4Good Index and as a 2026 Financial Times UK ‘Best Employer’.

Diversity and Inclusion

FDM Group is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, national origin, age, disability, veteran status or any other status protected by federal, provincial or local laws.

Apply

Other jobs like this

Similar

Platform Engineer - London

More Info

Similar