Data Engineer

XL CATLIN; London; On-site; GBP 40,000 - 80,000; Full time

Job summary

An innovative firm is seeking a Data Engineer to join their Data Sourcing & Solutions team in London. This role is pivotal in designing and implementing data structures that enhance decision-making through advanced analytics. The ideal candidate will have a strong background in data engineering, particularly with Python and data pipeline optimization. You will explore new data sources, automate data acquisition, and ensure the integrity and quality of data for analytical projects. If you are detail-oriented and possess a natural curiosity for data, this is an exciting opportunity to make a significant impact within a dynamic organization.

Qualifications

• Experience in Data & Analytics with strong Python skills.
• Expertise in data modeling and building data pipelines.

Responsibilities

• Design and implement data structures for analytical projects.
• Build data pipelines and ensure data quality for analysis.

Skills

Python

Databricks

PySpark

Spark SQL

Data Modeling

Data Pipeline Optimization

Data Quality Solutions

Insurance Domain Knowledge

Analytical Skills

Documentation Skills

Job description

Job Description

Job Number:

Data Engineer (Job Number: 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.

Essential Responsibilities:

• 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.
• Building 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 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.
• Participating 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.

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.

AXA XL is an Equal Opportunity Employer.