Data Engineer

Royal London; Alderley Edge; On-site; GBP 60,000 - 85,000; Full time

Job summary

Royal London is seeking a Data Engineer to join its Analytics Engineering Team within the Group Data & AI Office. The role focuses on building data pipelines and data assets to enable analytics, data science and machine learning initiatives across the organisation.

You will support the Senior Data Engineer, maintain data engineering best practices, and collaborate with stakeholders across business and technology to deliver robust data solutions. This is a hybrid role with 50% home working.

Qualifications

• Experience in data engineering and data management patterns such as data lakes and data warehouses.
• Proficient in SQL, Python and PySpark.
• Experience with GitHub and Azure DevOps.
• Experience with cloud-based data/analytics platforms (Databricks, Snowflake or Azure Data Factory).
• Proven ability to work on cross-functional projects and manage stakeholders.
• Knowledge of BI tools like PowerBI and Tableau.
• Strong MS SQL Server skills (T-SQL, SSIS).
• Understanding of analytics/data science tech and software engineering principles.

Responsibilities

• Source and prepare data for BI, analytics and data science projects.
• Design and develop data pipelines across on-prem and cloud platforms.
• Prototype solutions to test business hypotheses iteratively.
• Productionise pipelines with CI/CD for analytics teams.
• Maintain knowledge of data engineering and ML engineering practices.
• Collaborate with business, technology and external partners.
• Ensure robust software engineering practices within the team.

Skills

Data engineering

SQL

Python

PySpark

GitHub

Azure DevOps

Databricks

Snowflake

Azure Data Factory

BI tools

PowerBI

Tableau

R

T-SQL

SSIS

Stakeholder mgmt

Education

Bachelor's degree in a relevant field

Tools

GitHub

Azure DevOps

Databricks

Snowflake

Azure Data Factory

PowerBI

Tableau

R

T-SQL

SSIS

Job description

Job Title: Data Engineer

Contract Type: Permanent

Location: Alderley Park (Wilmslow) or Glasgow

Working Style: Hybrid 50% home/office based

We have a fantastic opportunity for a Data Engineer to join Royal London's Analytics 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 Senior Data Engineer in their role as technical lead 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, analytics, data science and machine learning.

The purpose of the Analytics Engineering team is to create business value through delivery of specific Analytics, Data Science, Machine Learning and Artificial Intelligence projects and initiatives. These initiatives will create insights, answer key business questions, solve business problems, and support decision making at all levels of the organisation. This team supports the other teams within the Analytics & Insight function, providing them with a Data and Analytics service to support their insight activities. The team will also act as a Centre-of-Excellence in Analytics and Data Science, helping to take forward the Group's capability in these areas and our ambition to become Data Led .

More about the role

• Source and prepare data for use in Business Intelligence (BI), 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 data pipelines, from both the 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.

If you think you would be a great fit for our team at Royal London but don't meet all the requirements of the role, please get in touch as your application will still be considered.

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