Data Engineer
Requirements
Candidates must have at least 2 years of hands-on Snowflake engineering experience and a minimum of 5 years of experience within the London Market insurance sector. Strong SQL development skills and proficiency with Azure Data Factory are essential for this position.
Job Description
FDM is a global business and technology consultancy seeking a Snowflake Data Engineer to work for our client within the Finance sector. This is initially a 12 month contract with very good prospects to extend and will be a remote role.
Our client is seeking an experienced Snowflake Data Engineer to join a high-performing data team to support with the expansion of it's enterprise data platform. This role will focus on the design, development and optimisation of Snowflake-based data solutions that support critical business functions including Underwriting, Claims, Finance, Portfolio Management and Delegated Authority reporting.
The successful candidate will combine strong technical data engineering expertise with a solid understanding of London Market insurance processes and data.
Responsibilities:
Snowflake Data Engineering
- Design, develop and maintain scalable Snowflake data pipelines and ELT processes.
- Build and optimise data models across Raw, Curated and Gold layers.
- Develop reusable engineering frameworks and deployment patterns.
- Support platform performance tuning, scalability and cost optimisation.
- Implement automated data quality, monitoring and reconciliation processes.
- Ensure auditability, historisation and data lineage requirements are met.
- Contribute to CI/CD, DevOps and release management activities.
Data Integration
- Integrate data from core insurance systems and external sources into Snowflake.
- Develop ingestion and transformation processes using Azure Data Factory and Snowflake.
- Support datasets relating to submissions, policies, premiums, claims, bordereaux, delegated authority and finance.
- Assist with migration and reconciliation activities from legacy data warehouse environments.
Data Modelling and Analytics
- Develop enterprise data models aligned to underwriting, claims and finance requirements.
- Create conformed dimensions and reusable business entities.
- Support semantic modelling requirements for Power BI reporting and analytics.
- Apply best-practice dimensional, star schema and Snowflake modelling techniques.
About You
Snowflake:
- 2+ years' hands-on experience engineering solutions within Snowflake.
- Experience designing and building enterprise-scale Snowflake environments.
- Strong knowledge of:
- Snowflake performance optimisation
- ELT development
- Tasks and Streams
- Secure Views
- Data Sharing
- Cost optimisation
- Data Governance
- Role-based Access Controls
- Metadata Management
Data Engineering:
- Strong SQL development skills.
- Experience with Azure Data Factory.
- Proven experience building enterprise ETL/ELT pipelines.
- Data quality, validation and reconciliation framework experience.
- Familiarity with DevOps practices, Git/version control and cloud-based data platforms.
London Market Insurance:
- Minimum 5 years' experience within London Market insurance.
- Strong understanding of:
- Policies
- Premiums
- Claims
- UMRs
- Lloyd's and Company Market operations
- Experience working with Underwriting, Claims and Finance stakeholders.
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.
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
Skills
About FDM Group
We’re FDM, an award-winning global business and technology consultancy. For over 30 years we’ve been powering the people behind tech and innovation. We collaborate with world-leading companies to identify the expertise they need, exactly when they need it. We have helped successfully launch more than 25,000 careers globally to date and we are a trusted partner to over 300 companies worldwide. Diversity, equity and inclusivity is at the core of everything we do. We have 2,500+ employees worldwide, with over 75 nationalities working together as a team. From our origins in Brighton, UK, we now have 18 centres located across Europe, North America, and Asia-Pacific and are now on the FTSE4Good Index.
View company profile →