Data Engineer

Apollo; Greater London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A specialized insurance company located in Greater London is seeking a skilled Data Engineer. The role involves designing and maintaining data pipelines to enhance operational efficiency and innovation. Candidates should have strong experience with Azure Data Factory, Databricks, and SQL Server, as well as excellent problem-solving and communication skills. This position supports hybrid and flexible working arrangements, along with a competitive compensation package including a discretionary bonus and comprehensive benefits.

Benefits

31 days of annual leave

Non-contributory pension

Private medical insurance

Discretionary bonus

Qualifications

• Hands-on experience with Azure Data Factory, Databricks, and SQL Server.
• Understanding of ELT development, data modelling, and governance.
• Experience with CI/CD, automation, and testing.

Responsibilities

• Develop and maintain ELT pipelines using Azure Data Factory.
• Build Medallion-layer data models with structured code.
• Ensure data quality and governance standards.

Skills

ADF

Databricks (Python and SQL)

SQL Server

Communication skills

Problem-solving skills

Collaboration skills

Job description

Who we are

Apollo is a specialised independent (re)insurer, established in 2009, to deliver top‑tier products and services to clients, brokers, and capital partners at Lloyd’s. The name "Apollo" was inspired by the achievements of one of its founding investors, Neil Armstrong, the first person to walk on the moon in 1969. Together with Jim Hays, Neil identified an opportunity to create a unique service provider within Lloyd’s. Since its inception, Apollo has significantly broadened its portfolio of insurance solutions, including Apollo 1969’s traditional and specialty lines, ibott 1971’s innovative sharing‑economy products, and managing agency services at Lloyd’s through our Platform Partner Syndicates. Today, Apollo continues to grow with a team of 300 professionals dedicated to fulfilling the company’s mission of enabling a resilient and sustainable world.

“We attract and retain a diverse range of talent by fostering an inclusive, equitable team environment where individuals from all backgrounds have opportunities to grow, succeed, and contribute. We empower our teams to achieve excellence and drive forward‑thinking solutions, aiming to enable a resilient and sustainable world.” – David Ibeson, Group CEO

Your role

Apollo’s Digital Solutions team has built a modern cloud‑based data platform that powers smarter underwriting, operational efficiency, and innovation. As a Data Engineer, you will design, build, and maintain high‑quality data pipelines and models that underpin analytics, applications, and business operations. You will play a key role in strengthening Apollo’s data capabilities and ensuring our platform remains scalable, reliable, and well governed.

What you will do

• Develop and maintain ELT pipelines using Azure Data Factory, Databricks, and SQL Server.
• Build Medallion‑layer data models with clean, well‑structured code.
• Ensure data quality, lineage, observability, and secure access standards are embedded throughout.
• Contribute to agile delivery, estimation, refinement, and peer reviews.
• Improve CI/CD processes, automated testing, and engineering practices.
• Optimise existing pipelines and help resolve production issues.
• Translate business requirements into robust data engineering solutions.
• Work closely with architects, governance teams, and application engineers.
• Support platform alignment through documentation, metadata, and consistent engineering patterns.

What we are looking for

• Hands‑on experience with ADF, Databricks (Python and SQL), and SQL Server.
• Understanding of ELT development, data modelling, and governance.
• Experience with CI/CD, automation, and testing.
• Strong communication, problem‑solving, and collaboration skills.
• Familiarity with Purview or other metadata tools.
• Exposure to Medallion modelling and modern data platforms.

Benefits

Our compensation package is designed to attract top talent. In addition to a fair and attractive salary, this role offers a discretionary bonus and a comprehensive range of benefits, including 31 days of annual leave, a non‑contributory pension and private medical insurance.

Hybrid & flexible working

At Apollo, hybrid and flexible working is fully embraced and we do not see the benefit of presenteeism. We understand that no two colleagues are alike, and as such we support the ability to remain agile and achieve a home‑and‑work balance to best suit business and personal commitments.

Commitment to inclusion

Apollo is a growing and diverse team of empowered and passionate experts who focus on bringing innovation, data‑driven decision‑making, and collaboration to every relationship and every risk. We value the diversity of thought and talent of every member of our team and are committed to supporting and celebrating difference. We offer a range of support and run a programme of events and training that recognise the challenges and opportunities relating to diversity.

EEO statement

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.