CLOSING DATE: 15TH AUGUST 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.

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