Job Description

Job Title: Lead Software Engineer (Azure Data)

Contract Type: Permanent

Location: Alderley Park

Working style: Hybrid 50% home/office based

Closing date: 29th April 2025

We are seeking a highly skilled and experienced Lead Software Engineer (Azure Data) to join out dynamic team at Royal London. In this role, you will play a crucial role in providing deep technical expertise to help our teams design, develop, test, implement and support efficient solutions that meet business and customer requirements.



The successful candidate will have a real impact into how Royal London develop and support our applications and will provide a blend of both solid leadership experience and technical expertise.



This role is focussed within the Engagement Services platform with a focus on Azure Data and contributes to our purpose of strengthening the mutual choice for our customers, by providing the best technology solutions to our customers.

About the role

Data Pipeline Development

:

Design, develop, and maintain

ETL/ELT data pipelines

using

Azure Data Factory (ADF)

for automating data ingestion, transformation, and orchestration from diverse data sources.


Build scalable data integration processes to bring in data from

on-premises

,

cloud

, and

external APIs

into Azure Data Lake Storage (ADLS).

Data Transformation & Modeling

:

Utilize

Azure data Factory/ Databricks (PySpark/Scala)

to build scalable data processing and transformation workflows for both batch and streaming data.


Develop data models and implement

data partitioning

,

indexing

, and

schema optimization

to improve query performance in

Azure Synapse Analytics

.

Data Warehouse & Analytics Solutions

:

Collaborate with data architects and business stakeholders to design and implement

data lake

and

data warehouse

architectures on Azure.


Create and optimize

data models

(star and snowflake schemas) for business intelligence (BI) and analytics workloads, ensuring high performance and scalability.

Data Governance & Quality

:

Implement

data governance

practices to ensure data accuracy, completeness, and integrity across the Azure environment.


Develop and enforce

data quality checks

and validation rules to maintain high levels of data consistency using

Azure Data Factory

and

Databricks

.

Leads the delivery of complex technical solutions, provides technical advice and guidance to other software developers and takes responsibility for ensuring that all code meets Group standards, guidelines and quality gates for given technology. Takes responsibility for ensuring technical solutions are safely implemented to production environment(s) without impact to internal or external customers. Takes an active role on the transfer of knowledge and sharing of experiences relating to own area of technical expertise at practice level.

About you

Strong experience in building and orchestrating complex data pipelines in

ADF

. Experience with

Delta Lake

for implementing data lakes and managing big data workloads efficiently. Strong knowledge of

Synapse Analytics

(formerly SQL Data Warehouse) for data warehousing and advanced analytics. Experience with

T-SQL

and optimizing complex queries for large datasets. Experience with designing and managing data lakes using

ADLS

, with an understanding of hierarchical namespaces, partitioning strategies, and performance optimization techniques. Expertise in

Data Modeling

(star and snowflake schemas) and writing efficient

SQL

queries for analytical workloads. Experience with

Azure DevOps

for CI/CD pipeline creation and deployment automation for data pipelines and infrastructure. Proficiency with

Azure Active Directory (AAD)

,

Azure Key Vault

, and

Azure RBAC

for managing security and access control. A growth mindset with the ability to lead a team, support, coach, and mentor others. Able to communicate at all levels in a collaborative manner. Good understanding of the full software development lifecycle, and an awareness of agile development practices.

About Royal London

We're the UK's largest mutual life, pensions and investment company, offering protection, long-term savings and asset management products and services.


Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve.



We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, an up to 14% employer matching pension scheme and private medical insurance. You can see all our benefits here - Our Benefits

Inclusion, diversity and belonging

We're an Inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected - whatever their background.