Data Engineer

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

Job summary

DUAL, part of Howden, seeks a senior Data Engineer to advance DUALPersonal Lines data platforms. You will own data pipelines, enrich analytics, and collaborate across underwriting, operations and finance to ensure accurate data for reporting and decision making.

You will work with the Azure data stack, design data models (Star Schema) for BI, and contribute to ML initiatives within an agile DevOps environment. A strong team player with communication skills is essential.

Qualifications

• Strong knowledge of Data Management principles in a Lakehouse architecture.
• 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; dataintegration and modelling incl. 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: working with Data Science teams to assist with ML models
• Nice to have: infrastructure as code tools for deploying resources
• Ability to work quickly, efficiently and methodically
• A strong team player with good communication and negotiation skills
• Commercial awareness and staying up to date with industry trends
• Proactively sharing best practices across the organisation
• Planning, organising, and prioritising
• Good understanding of data operations
• Broad knowledge of insurance principles and products
• Self-starter with willingness to learn new skills

Responsibilities

• Engineer DUALPersonal Lines' data platforms, incl. the Data Lakehouse, to enhance underwriting analytics.
• Provide technical expertise in data engineering, analysis, orchestrations, and enrichment.
• Build data solutions to address changing requirements; manage new requests and incidents.
• Develop, test and deploy data products while adhering to governance, data quality and security.
• Collaborate with DUAL Group data team to align on data standards.
• Assess impact of changes on the data model to avoid issues in operational and reporting layers.
• Collaborate with data teams and system owners to maintain data model and integrity.
• Support underwriting analytics and reporting with accurate data representations.
• Build knowledge of DUALPersonal Lines systems with the data team.
• Contribute to API interfaces, data models, data sharing, RDM/MDM tools, ML endpoints.
• Work within Agile DevOps to incrementally improve the data platform.
• Collaborate with Group Data Science to productionise ML pipelines.
• Engage with Underwriting, Operations, Finance, Risk & Compliance and HR stakeholders.
• Act as conduit between DUALPersonal Lines and Dual Data Team to promote standards and ROI discussions.
• Help drive future data investments and measure realised ROI.

Skills

Lakehouse data principles

Data engineering

ELT pipelines

Azure data stack

Python

SQL

Data modeling

CI/CD

Power BI integration

Stakeholder collaboration

Infra as code (Nice to have)

Machine Learning collaboration (Nice)

Tools

Azure Data Factory

Azure Databricks

Azure Storage

Azure DevOps

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 DUALPersonal Lines'strategic data platforms, chief of which is the Data Lakehouse, to enable the continuous enhancement of DUALPersonal Lines'sunderwriting 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 theDUAL Groupdata team's business analysts, developers and system owners to avoid divergence from agreed data standards.

• Assesses the impact of change on DUALPersonal Lines'sdata 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 DUALPersonal 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.

• Working with the Group Data Science team to productionise ML pipelines into the overall data platform solution.

• Work collaboratively with internal stakeholders across DUALPersonal Linesincluding but not limited to Underwriting teams, Operations, Finance, Risk & Compliance and HR.

• Act as a conduit betweenDUALPersonal Linesand Dual Data Teamto facilitate the sharing of common approaches, adherence to standards, and advocating on behalf DUAL.

• Help drivesuccess of future investments in Data within DUALPersonal Lines, including clear articulation ofreturn on investment (ROI)and ongoing assessment of realisation attainment.

Key requirements

• Strong knowledge of Data Management principles in a Lakehousearchitecture.

• 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.Experience in dataintegration 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 sharingbest practicewith others across the organisation.

• Planning, organising, and managing skills, and ability to prioritise.

• Good understanding ofdata operations.

• 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 everyone has a voice, where volunteering in the community is part of the day job, and where everyone is encouraged to play a part towards our sustainability goals. We want people who want to make a difference - not just in the workplace, but in the industry and in the wider community.

Our culture: people first

Our core values dictate how we live and work. We're a group with independence and people at its heart – and a home for talent with a unique culture: the biggest small company in the world.

Being a people-first business has always been central to who we are. Our vision was to create an independent organisation with a distinctive culture that would survive and thrive through the people who shape it. Finding the most talented and entrepreneurial individuals to join the group has been, and will continue to be, key to our success.

Diversity and inclusion

At DUAL, our people are our greatest strength. We are committed to building an open and inclusive culture where everyone feels trusted and that they belong. We work to ensure all candidates, employees, clients and business partners are treated with fairness and respect.

We want every candidate to be able to bring their best to the recruitment process, so if you require reasonable accommodation at any stage, please let us know and we will work with you to provide appropriate support.

Permanent