Data Engineer

TPT Retirement Solutions; Leeds; On-site; GBP 55,000 - 75,000; Full time

Job summary

TPT Retirement Solutions is seeking a Data Engineer to design, build, and maintain robust data pipelines and ELT processes. You’ll enhance data warehouse performance, automate processes, and support ingestion of new and legacy data into Microsoft Fabric.

You’ll work with Insights Analysts and the Governance team to ensure data standards, access controls, and data quality across reporting environments, while keeping comprehensive documentation up to date.

Qualifications

• Experience designing and implementing data pipelines using modern tools.
• Strong SQL and Python skills for data manipulation and automation.
• Experience with Fabric Dataflows Gen2, Data Factory, and notebooks.
• Knowledge of data governance, lineage, and lifecycle management.
• Excellent communication and ability to explain technical concepts to non-technical stakeholders.

Responsibilities

• Design, build, and maintain reliable data pipelines and ELT processes.
• Optimise data models, queries, and pipelines for speed and cost-efficiency.
• Implement checks, alerts, and monitoring to ensure data accuracy.
• Collaborate with Insights Analysts and Governance for data standards and access controls.
• Maintain up-to-date technical documentation for ETL and warehousing solutions.

Skills

SQL

Python

Data governance

Data quality

Communication

Problem solving

Tools

Microsoft Fabric

SSIS

Dataflows Gen2

Data Factory

Notebooks

Job description

Are you passionate about designing and building robust data solutions? Do you thrive on tackling challenges to optimise performance and ensure data quality? Join TPT Retirement Solutions as a Data Engineer, and play a key role in driving our data transformation journey.

About the Role

As a Data Engineer, you'll design, build, and maintain robust data pipelines and ELT processes to meet data and reporting needs. You’ll create reliable and well-documented solutions, continuously improving the performance and automation of our data warehouse environment. You will also be involved in the ingestion of new and legacy data sets into Microsoft Fabric.

You will be responsible for:

• Designing, building, and maintaining reliable data pipelines that ingest, transform, and deliver data to downstream systems using Microsoft Fabric and other modern tools.
• Optimising data models, queries, and pipelines for speed, scalability, and cost-efficiency. Monitoring and addressing bottlenecks or inefficiencies proactively.
• Implementing checks, alerts, and monitoring to ensure data accuracy, completeness, and consistency, fostering trust in delivered data.
• Working closely with Insights Analysts to deliver reporting needs and partnering with the Governance team to ensure alignment with data standards and access controls.
• Maintaining up-to-date technical documentation for all ETL processes, data transformations, and warehousing solutions.

Skills, Qualifications & Experience:

We’re looking for someone who brings the following skills and experiences:

• Microsoft Fabric expertise, design, build and implementation.
• Proficiency in SQL and Python for data manipulation, automation and scripting.
• Experience of SQL Server Integration Services (SSIS).
• Experience building and maintaining data pipelines using Fabric Dataflows Gen2, Data Factory, and notebooks.
• Strong independent problem-solving skills, with clarity of when to ask for guidance.
• Excellent communication skills, capable of effectively explaining technical concepts to non-technical stakeholders.
• Knowledge of data governance, quality, lineage, and lifecycle management.

The Company

TPT Retirement Solutions (TPT) is one of the UK’s leading providers of workplace pensions with 80 years’ experience of managing defined benefit and defined contribution pension schemes. It has £11.4 billion of assets under management (as at 30 September 2025) and 490,000 members.

TPT’s mission is to make pension schemes perform better for everyone, from the sponsoring employers and trustees to the members who are saving for the future. They are an innovative, forward-thinking organisation, investing in technology to improve the services they provide. TPT are ultimately owned by a pension fund, providing genuine alignment of interests with those of their clients and scheme members.