Data Engineer

We are looking forData Engineerfor our client's project based atLondon, UK - Hybrid

Role Description:

• We are seeking an experienced Data Modeller with proven expertise in the London Market insurance sector.
• The successful candidate will play a key role in designing and validating data models that support enterprise data initiatives.
• This includes working closely with data engineers, architects, and business stakeholders to ensure data structures are scalable, accurate, and aligned with business needs.

Key Responsibilities:

• Design and maintain conceptual, logical, and physical data models to support reporting, analytics, and operational systems.
• Collaborate with data engineers and analysts to ensure models are implemented correctly and efficiently.
• Translate complex business requirements into scalable and maintainable data structures.
• Ensure data models comply with data governance, compliance, and London Market regulatory standards.
• Document data definitions, relationships, and lineage using industry-standard modelling tools.
• Support data quality initiatives by identifying gaps and inconsistencies in source systems and downstream usage.

Qualifications:

• London Market insurance experience is essential, including familiarity with Lloyd’s market data structures and regulatory reporting.
• Strong experience in data modelling (conceptual, logical, physical) using tools such as Erwin, ER/Studio, or dbt.
• Solid understanding of data warehousing, data lakes, and enterprise data architecture.
• Proficiency in SQL and experience working with cloud data platforms (e.g., Azure, AWS, GCP).
• Familiarity with data governance frameworks, metadata management, and data Cataloging tools.
• Excellent communication and documentation skills, with the ability to explain complex data concepts to non-technical stakeholders.

Preferred Skills

• Experience with insurance platforms such as Guidewire, Duck Creek, or legacy PAS systems.
• Knowledge of Delta Lake, Apache Spark, and data pipeline orchestration tools.
• Exposure to Agile delivery methodologies and tools like JIRA, Confluence, or Azure DevOps.
• Understanding of regulatory data requirements such as Solvency II, Lloyd’s Core Data Record (CDR), or Blueprint Two.