Data Engineer

We are seeking a Data Engineer to work within our growing Data team to help shape and enhance our data capabilities. The role is to provide data engineering expertise to support delivery of our programme of work. This will include a broad range of initiatives, including Finance and Actuarial, Claims Augmentation utilising AI, and a number of Azure Data Platform and Databricks deliverables.

This role is an opportunity to apply your expertise in Azure, Databricks and data engineering techniques to business projects. It requires an in-depth technical knowledge combined with the ability to engage directly with senior business stakeholders in a range of our business domains

The role will also involve supporting development activities on our legacy SQL Server data warehouses and aiding in the transition over to the Azure platform. The candidate should have experience of working in an Agile delivery environment.

The candidate will ideally have experience and knowledge of processes within insurance, and the ability to work directly with business stakeholders, understand business problems and deliver effective solutions. They should be comfortable collaborating and working as part of a dynamic multi-disciplinary team.
 

This is a hybrid role, working 2-3 days a week at our London office.

Responsibilities will include:

• Designing, developing and maintaining data solutions using components such as Azure Data Factory, Databricks, and Azure SQL Database
• Providing technical guidance and support to the development team as a senior member of the project development team.
• Assisting in creating and maintaining comprehensive documentation of data transformations, processes and systems
• Fostering communications and relationships between team members and stakeholders to ensure that expectations are managed and that teams are aligned
• Development of good internal client relationships
• Working to bridge any gaps between the offshore, third-party development team, the internal development team and business stakeholders on the project.
• Keeping abreast of developments and trends in data and reporting technology
• Planning, tracking and managing the progress of development activities in coordination with project managers and scrum masters.

Skills and experience:

• Experience in developing data solutions, demonstrating understanding of relational databases, common data warehousing concepts, ETL processes and data modelling
• Strong T-SQL skills with experience in querying and manipulating data
• Familiarity of working within an Agile delivery environment, leveraging tools including Kanban boards, repositories and CI/CD pipelines
• Strong analytical and problem-solving skills, with a keen eye for detail
• Experience with Azure Data Factory (ADF), or SQL Server Integration Services (SSIS)
• Experience with Azure Databricks and Python
• Experience with Master Data Services (MDS) are beneficial
• Insurance or other financial service experience is desirable, preferably within a Lloyd’s Managing Agency