Data Engineer

hyperiongrp; Romford; On-site; GBP 70,000 - 100,000; Full time

Job summary

DUAL is a specialist underwriting group, part of Howden, operating globally in 57 countries. We seek a Senior Data Engineer to lead the evolution of the Data Lakehouse and related data platforms for Personal Lines, collaborating with underwriting, risk and reporting teams.

The role demands 5+ years in data engineering, expertise with Azure data services, Python, SQL, and data modelling. You will drive governance, CI/CD and data quality across a scalable analytics landscape.

Qualifications

• At least 5 years' experience in data engineering and building data pipelines.

Responsibilities

• Engineer DUAL Personal Lines' data platforms, notably the Data Lakehouse, to enhance underwriting analytics.
• Provide technical expertise in data engineering, analysis, orchestrations and enrichment.
• Build data solutions while managing new requests and incidents.
• Develop, test and deploy data products with governance, change control and data quality.
• Collaborate with data team members and system owners to follow data standards.
• Assess impact of changes on data models to maintain operational, analytical and reporting integrity.
• Support underwriting analytics and reporting teams with accurate data.
• Contribute to delivery of API interfaces, data models, and data sharing tools.
• Work within Agile/DevOps to incrementally deliver value.

Skills

Data engineering

Python

SQL

ELT pipelines

Data modelling

Data management

Power BI data modelling

CI/CD principles

Machine Learning collaboration

Communication

Tools

Azure Data Factory

Azure Databricks

Azure Storage

Azure DevOps

Power BI

Job description

About DUAL

Working across 21 countries, DUAL has built a reputation as a specialist underwriting group and the market of choice for insurance intermediaries around the world. That's how we have become one of the world's largest international underwriting agencies (or MGAs) with US$3.4bn GWP.

DUAL is part of Howden, a leading global insurance group with employee ownership at its heart. Founded in 1994, it provides insurance, reinsurance and underwriting services to clients ranging from private individuals to the largest multinational companies. The Group operates in 57 countries, employs over 24,000 people and manages premiums totalling US$50bn on behalf of its clients.

Role responsibilities

• Key member of the team, engineering DUAL Personal Lines' strategic data platforms, chief of which is the Data Lakehouse, to enable the continuous enhancement of DUAL Personal Lines' underwriting analytical capabilities.
• Provide technical expertise in data engineering, analysis, orchestrations, and enrichment .
• Build data solutions where required to address changing requirements - managing new requests and incidents.
• Building, testing and deployment of data products while remaining true to governance principles including change control, accountability, data quality, and data security.
• Consult the DUAL Group data team's business analysts, developers and system owners to avoid divergence from agreed data standards.
• Assesses the impact of change on DUAL Personal Lines' data model to determine and avoid any potential issues which may hinder our operational, analytical and reporting environments.
• Actively collaborates with data teams and system owners to maintain the data model and data integrity throughout the DUAL Group data lakehouse.
• Closely support underwriting analytical teams and reporting analysts to ensure data is accurately represented for use in underwriting and performance analysis and reporting.
• Build knowledge and expertise of DUAL Personal Lines' systems with other data team members.
• Working with other members of the data team and wider business to support delivery of additional project components (API interfaces, Data Models, Data Sharing, RDM/MDM tools, ML Endpoints).
• Working within an Agile delivery / DevOps methodology to incremental change to the overall data platform to deliver additional data products to provide value to stakeholders.
• W orking with the Group Data Science team to productionise ML pipelines into the overall data platform solution.
• Work collaboratively with internal stakeholders across DUAL Personal Lines including but not limited to Underwriting teams, Operations, Finance, Risk & Compliance and HR.
• Act as a conduit between DUAL Personal Lines and Dual Data Team to facilitate the sharing of common approaches, adherence to standards, and advocating on behalf DUAL.
• Help drive success of future investments in Data within DUAL Personal Lines , including clear articulation of return on investment (ROI) and ongoing assessment of realisation attainment.

Key requirements

• Strong knowledge of Data Management principles in a Lakehouse a rchitecture.
• At least 5 years' experience in data engineering and building data pipelines.
• Proven track record in Data Engineering and supporting the business to gain true insight from data .
• E xperience in data integration and modelling including ELT pipelines .
• Hands on experience designing and delivering solutions using Azure services including Azure Data Factory, Azure Databricks, Azure Storage, Azure DevOps.
• Strong proficiency in Python and SQL
• Experience working with Data Architects for technical design
• Experience on the design of data models (Star Schema) for use in Power BI. Insurance analysis, MI or reporting experience
• Understanding and adherence to CI/CD principles
• Nice to have: experience working alongside Data Science teams to assist with building and deploying Machine Learning models
• Nice to have: experience working with infrastructure as code tools for deploying resources
• Ability to work quickly, efficiently and methodically .
• A strong team player who is confident in their ability .
• Very strong communication, influencing and negotiation skills . Actively listens to the views of colleagues, but also has the strength of character to challenge where required .
• Has a commercial awareness and stays up to date with current issues affecting the industry and its technologies.
• Proactively sharing best practice with others across the organisation .
• Planning, organising, and managing skills, and ability to prioritise .
• Good understanding of data o perations .
• Broad knowledge and understanding of insurance principles, products and services .
• Self-starter, with a passion and ability for learning new skills and technologies

What do we offer in return?

• A career that you define.
• Of course, we offer a competitive range of rewards and benefits to support you, but we know you expect all that.

What you might not expect is a job where