Data Engineer

XL CATLIN; London; On-site; GBP 45,000 - 75,000; Full time

Job summary

An innovative firm is seeking a skilled Data Engineer to join their Data Sourcing & Solutions team in London. This role is critical in designing and implementing data structures that enable advanced analytics, ensuring data quality and context. The ideal candidate will have a strong background in data engineering, particularly with Python and data pipeline optimization. Join a dynamic team where your contributions will directly impact decision-making processes and help the organization harness the power of data. This is a fantastic opportunity to work in a collaborative environment focused on solving complex risks and delivering top-notch client service.

Benefits

Flexible Working Arrangements

Enhanced family friendly leave benefits

Diversity and Inclusion initiatives

Qualifications

• Experience in Data & Analytics with a focus on data structures.
• Strong background in Python and data pipeline optimization.

Responsibilities

• Design and implement data structures for analytics projects.
• Build data pipelines and ensure data quality and integrity.

Skills

Python

Databricks

PySpark

Spark SQL

Data Modelling

Data Pipeline Optimization

Analytical Skills

Communication

Detail Orientation

Curiosity

Education

Bachelor's Degree in Data Science or related field

Master's Degree preferred

Tools

Data Management Tools

ETL Tools

Data Visualization Tools

Job description

Job Description

Job Number:

Data Engineer (78002584D20240801)

Data Engineer – Data Sourcing & Solutions

London, UK

The Data Sourcing & Solutions team is a growing group inside of AXA XL, responsible for designing and implementing data structures that will enable AXA XL to harness the potential of advanced analytics in the decision-making process. Data is vital to analytics. In order to ensure that we are achieving our potential under this discipline, we need to make certain our data has the right context, granularity, and quality.

The Data Engineer plays a critical role within the Data Sourcing & Solutions team as this person is responsible for designing and implementing data structures to support current and future analytical projects. We are looking for candidates that have experience working with data from a raw, unprocessed state and organizing it in an intuitive way. Building this data pipeline enables our partners to analyze data better and faster – ultimately leading the organization in optimizing the decision-making process.

What will your essential responsibilities include?

• This role will spend the majority of time focused on a mix of internal and external data. This will involve building proper data pipelines to support initial exploration and real-time integration.
• Exploring and acquiring new sources of data. Using curiosity and creativity, this would involve using technology to automate data acquisition, ability to link new sources with internal data, and appropriate level of supporting documentation of the source and technical solution.
• Providing the right context of data required for a given analysis. This would require the candidate to work with data modelers/analysts to understand the business problems they are trying to solve and create data structures to feed into their analysis.
• Build upon learnings of internal and external data to become more proactive. This includes thinking ahead of what modelers will anticipate with their data needs and designing structures that are intuitive to use.
• Ensuring quality and understanding of analytical data. This would require hands-on data experience to look into data issues and seek to resolution or acceptance. Create the appropriate amount of documentation, leverage standards and build upon them. Data should be reconciled and documented at various stages for integrity.
• Participate in developing governance and rigor of data management practice within the Data Sourcing & Solutions Team. This will also include partnering with enterprise IT groups and involvement in enterprise data related functions.

You will report to Data Engineering Manager/Principal Data Engineer.

We’re looking for someone who has these abilities and skills:

• Well established Data & Analytics work experience.
• Sound understanding/experience of Python, Databricks, PySpark, Spark SQL and best practices.
• Expertise in Star Schema data modelling.
• Expertise in the design, creation and management of large datasets/data models.
• Experience working on building/optimizing logical data model and data pipelines while delivering high data quality solutions that are testable and adhere to SLAs.
• Data Engineering and Insurance background preferred.
• Ability to work with business owners to define key business requirements and convert to technical specifications.
• Demonstrated ability to work through data complexities which includes variety of sources, formats, and structures.
• Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modelling decisions and data engineering strategy.
• Preference of experience in Insurance domain.
• Ability to see through ambiguous concepts, breakdown complex problems into manageable components.
• Detail oriented, proven ability to recognize patterns in data.
• Possesses natural curiosity. Seek to understand the world around you, question when appropriate.

FIND your future

AXA XL, the P&C and specialty risk division of AXA, is known for solving complex risks. For mid-sized companies, multinationals and even some inspirational individuals we don’t just provide re/insurance, we reinvent it.

How? By combining a strong and efficient capital platform, data-driven insights, leading technology, and the best talent in an agile and inclusive workspace, empowered to deliver top client service across all our lines of business − property, casualty, professional, financial lines and specialty.

With an innovative and flexible approach to risk solutions, we partner with those who move the world forward.

Inclusion & Diversity

AXA XL is committed to equal employment opportunity and will consider applicants regardless of gender, sexual orientation, age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic.

At AXA XL, we know that an inclusive culture and a diverse workforce enable business growth and are critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most diverse workforce possible, and create an inclusive culture where everyone can bring their full selves to work and can reach their highest potential. It’s about helping one another — and our business — to move forward and succeed.

• Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with 20 Chapters around the globe.
• Robust support for Flexible Working Arrangements.
• Enhanced family friendly leave benefits.
• Named to the Diversity Best Practices Index.
• Signatory to the UK Women in Finance Charter.

Location

Location: GB-GB-London

Work Locations: GB London 20 Gracechurch Street London EC3V 0BG

Job Field

Job Field: Data & Analytics

Schedule

Schedule: Full-time

Job Type

Job Type: Standard

AXA XL is an Equal Opportunity Employer and does not discriminate against any colleague or applicant for employment on the basis of race, color, national origin, religion, sex, gender identity and/or expression, sexual orientation, age, disability, genetic information, veteran status, military status or any other category protected by local law.