Data Engineer - Core Engineering

Royal London; Alderley Edge; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

28 days annual leave

Employer pension match

Private medical insurance

Job summary

Royal London is seeking a Data Engineer to join its Core Engineering Team within the Group Data & AI Office. The role focuses on building data pipelines, managing data sources, and enabling analytics and data science across the business.

You will prototype data solutions, productionise pipelines with CI/CD, and collaborate with stakeholders across technology and business teams to maintain high standards in data engineering practices.

Qualifications

• : Experience in data engineering and data management design patterns such as data lakes and data warehouses.
• : Experience with SQL, Python and PySpark in data engineering contexts.
• : Knowledge of versioning tools (GitHub) and work tracking tools (Azure DevOps).
• : Familiar with cloud-based data/analytics tech (Databricks, Snowflake, Azure Data Factory/Fabric).
• : Cross-functional project collaboration and stakeholder management.
• : BI/analytics tool familiarity (PowerBI, Tableau, R).
• : MS SQL Server tech (T-SQL, SSIS).
• : Understanding of data science and software engineering principles.

Responsibilities

• : Source, transform and prepare high quality data for analytics, BI, and data science use cases.
• : Manage multiple data sources and ensure data quality.
• : Design and develop efficient data pipelines across on-prem and cloud.
• : Prototype solutions to test business hypotheses in agile style.
• : Productionise pipelines with CI/CD for consumption by data science/visualisation teams.
• : Maintain awareness of data engineering and ML engineering practices.

Skills

SQL

Python

PySpark

GitHub

Azure DevOps

Data Lakes/Warehouses

Databricks/Snowflake/ADF

BI Tools

T-SQL/SSIS

Stakeholder mgmt

Tools

Databricks

Snowflake

Azure Data Factory

Fabric

Job description

Contract Type: Permanent

Location: Alderley Park or Glasgow

Working Style: Hybrid 50% home/office based

We have a fantastic opportunity for a Data Engineer to join Royal London's Core Engineering Team within our Group Data & AI Office function. As a Data Engineer you will define, manage, and deliver the data, tools and other technical assets to enable analytics, data science, and machine learning projects. These initiatives will create insights, answer key business questions, solve business problems, and support decision making at all levels of the organisation. Support the Principal Data Engineers in their role as technical leads for the team, helping to set and maintain technical standards. Act as an internal SME to the team for data, tooling and the technical practice around data engineering.

The purpose of the Core Data Engineering team is to create business value through delivery of specific Data, Data Products, Data Models and deliver high quality reusable Data as a Service to support our colleagues and stakeholders to derive data driven insight.

More about the role

• Source, Transform and prepare high quality, accurate data for use in strategic data driven use cases, such as digital application, Business Intelligence (BI) visualisation, Analytics and Data Science projects and initiatives.
• Source, evaluate, interpret, and manage multiple disparate data sources.
• Understand, own, and manage the team's data - working with business, technology and external partners.
• Design and develop efficient, performant data pipelines, from both on-premises and cloud platforms.
• Prototype solutions to explore business hypothesis in an agile and iterative way which supports a learn fast/fail fast methodology.
• Productionise data pipelines created by the team through CI/CD so that they are available for consumption for the data science and data visualisation team.
• Maintain knowledge of data engineering and machine learning engineering practices including keeping abreast of new developments and changes in the field.
• Maintain knowledge of data related technologies and practices.
• Help to ensure that robust software engineering practices are adhered to by the team.

More about you

• Experience in data engineering and application of data management design patterns, such as data lakes and data warehouses.
• Experience of programming languages: SQL, Python & pySpark etc. or equivalents.
• Experience of development practices: the use of versioning tools such as GitHub, work tracking tools such as Azure DevOps, or equivalents.
• Experience of cloud-based Data and Analytics technologies, including a minimum of one of: Databricks, Snowflake, Azure Data Factory / Fabric.
• A proven track record in working in cross-functional projects to a successful conclusion.
• Experience of managing stakeholders.
• A broad understanding of BI and analytics tools, such as PowerBI, Tableau & R.
• Good understanding of Microsoft SQL Server technologies, such as T-SQL and SSIS.
• Knowledge of the technology side of Analytics and Data Science, including principles of software engineering.

Only candidates whopossess a valid right to work in the UK or Eligibility to work in Ireland will be able to undertakethis role. Unfortunately, Royal London are unable to offer visa sponsorship

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

• 28 days annual leave in addition to bank holidays
• up to 14% employer matching pension scheme
• private medical insurance

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