Data Engineer

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 FDM: 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. Why join us • Career coaching, mentoring and access to upskilling throughout your entire FDM career • Assignments with global companies and opportunities to work abroad • Opportunity to re-skill and up-skill into new areas, develop non-linear career paths and build a skillset within your field • Annual leave and work-place pension