At a Glance
- Tasks: Lead the design and optimisation of data pipelines for impactful projects.
- Company: Join TPXimpact, a purpose-driven organisation focused on people-powered transformation.
- Benefits: Enjoy 30 days holiday, health plans, and personal development budgets.
- Other info: Collaborative culture with strong career growth opportunities.
- Why this job: Make a real difference by championing data engineering across diverse projects.
- Qualifications: Proven experience in data engineering and cloud platforms is essential.
The predicted salary is between 43200 - 72000 £ per year.
Job level: 10
We’re looking for a Lead Data Engineer to join our Data Engineering and Analytics practice.
In this role, you will:
-
Lead the design, development, management and optimisation of data pipelines to ensure efficient data flows, recognising and sharing opportunities to reuse data flows where possible.
-
Coordinate teams and set best practices and standards when it comes to data engineering principles.
-
Champion data engineering across projects and clients.
Responsibilities
-
Lead by example, holding responsibilities for team culture, and how projects deliver the most impact and value to our clients.
-
Be accountable for the strategic direction, delivery and growth of our work.
-
Lead teams, strands of work and outcomes, owning commercial responsibilities.
-
Hold and manage uncertainty and ambiguity on behalf of clients and our teams.
-
Ensure teams and projects are inclusive through how you lead and manage others.
-
Effectively own and hold the story of our work, ensuring we measure progress against client goals and our DT missions.
-
Work with our teams to influence and own how we deliver more value to clients, working with time and budget constraints.
-
Strategically plan the overall project and apply methods and approaches.
-
Demonstrably share work with wider audiences.
-
Elevate ideas through how you write, speak and present.
-
Headcount: Typically leads a multidisciplinary team or multiple workstreams (team size 5–15)
-
Resource complexity: Provides leadership across multiple workstreams or technical domains within a project or programme. Responsible for delivery coordination, prioritisation, and quality, often overseeing more junior leads or specialists.
-
Problem-solving responsibility: Solves highly complex problems, balancing technical, user, business, and operational needs. Applies expert judgement to make decisions, manage risks, and guide teams through ambiguity.
-
Change management requirements: Leads or co-leads significant change initiatives. Responsible for managing stakeholder expectations, supporting adoption, and embedding sustainable ways of working.
-
Internal/External interactions: Acts as a trusted partner to client and internal stakeholders at multiple levels. Leads workshops, presentations, and stakeholder engagement to ensure buy-in, alignment, and delivery clarity.
-
Strategic timeframe working towards:Works across mid- to long-term delivery cycles (6–12 months), ensuring that near-term work supports broader programme and client objectives.
About You
Professional knowledge and experience
Essential
-
Proven experience in data engineering, data integration and data modelling
-
Expertise with cloud platforms (e.g. AWS, Azure, GCP)
-
Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks)
-
Expertise with multiple data analytics tools (e.g. Power BI)
-
Deep understanding of data warehousing concepts, ETL/ELT pipelines and dimensional modelling
-
Proficiency in advanced programming languages (Python/PySpark, SQL)
-
Experience in data pipeline orchestration (e.g. Airflow, Data Factory)
-
Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc)
-
Ability to communicate technical concepts to both technical and non-technical audiences
-
Proven experience in delivery of complex projects in a fast paced environment with tight deadlines
Desirable
-
Advanced knowledge of data governance, data standards and best practices.
-
Experience in a consultancy environment, demonstrating flexibility and adaptability to client needs.
-
Experience defining and enforcing data engineering standards, patterns, and reusable frameworks
-
Professional certifications in relevant technologies (e.g. Microsoft Azure Data Engineer, AWS Data Analytics, Databricks Certified Professional Data Engineer)
Skills
Data Development Process
- Design, build and test data products that are complex or large scale
- Build and lead teams to complete data integration services integration and reusable pipelines that meet performance, quality and scalability standards
- Collaborate with architects to align solutions with enterprise data strategy and target architectures
Data Engineering and Manipulation
- Work with data analysts, engineers and data science and AI specialists to design and deliver products into the organisation effectively.
- Understand the reasons for cleansing and preparing data before including it in data products and can put reusable processes and checks in place.
- Access and use a range of architectures (including cloud and on-premise) and data manipulation and transformation tools deployed within the organisation.
- Optimise data pipelines and queries for performance and cost efficiency in distributed environments
Testing (Data)
- Review requirements and specifications, and define system integration testing conditions for complex data products and support others to do the same
- Identify and manage issues and risks associated with complex data products and support others to do the same
- Analyse and report system test activities and results for complex data products and support others to do the same
Other Skills
- Proficiency in developing and maintaining complex data models (conceptual, logical and physical).
- Strong skills in data governance and metadata management.
- Experience with data integration design and implementation.
- Ability to write efficient, maintainable code for large scale data systems.
- Experience with CI/CD pipelines, version control, and infrastructure-as-code (e.g. Git, Azure DevOps).
- Strong stakeholder communication skills, with the ability to translate technical concepts into business terms.
- Ability to mentor junior engineers, foster collaboration, and build a high-performing data engineering culture.
Behaviours and PACT values
- Purpose: Be values-driven, recognising that our client's needs are paramount. Approach client engagements with professionalism and creativity, balancing commercial and operational needs.
- Accountability: Be accountable for delivering your part of a project on time and under budget and working well with other leaders. Lead by example, promoting a culture where quality and client experience are foremost.
- Craft: Balance multiple priorities while leading high-performing teams. Navigate ambiguity and set the technical direction and approach to support positive outcomes.
- Togetherness: Collaborate effectively with others across TPXimpact. Build strong relationships with colleagues and clients.
About Us
We're a purpose driven organisation, supporting organisations to build a better future for people, places and the planet. Combining vast experience in the public, private and third sectors and expertise in human-centred design, data, experience and technology, we’re creating sustainable solutions ready for an ever-evolving world.
At the heart of TPXimpact, we’re collaborative and empathetic. We’re a team of passionate people who care deeply about the work we do and the impact we have in the world. We know that change happens through people, with people and for people. That’s why we believe in people-powered transformation.
Working in close collaboration with our clients, we seek to understand their unique challenges, questioning assumptions and building in their teams the capabilities and confidence to continue learning, iterating and adapting.
Benefits Include:
- 30 days holiday + bank holidays
- 2 volunteer days for causes that you are passionate about
- Maternity/paternity - 6 months Maternity Leave, 3 months Paternity Leave
- Life assurance
- Employer pension contribution of 5%
- Health cash plan
- Personal learning and development budget
- Employee Assistance Programme
- Green incentive programmes including Electric Vehicle Leasing and the Cycle to Work Scheme
- Health assessments
About TPXimpact - Digital Transformation
We drive fundamental change in approaches to product and service development, delivery and technology. Our agile, multidisciplinary teams use technology, design and data to deliver better results, improving outcomes for individuals, organisations and communities.
By working in the open, in partnership with our clients, we not only transform their systems and services but also build the capability of their teams, so work can continue without us in the longer term. Our focus is sustainable change, always delivered with positive impact.
We’re an inclusive employer, and we care about diversity in our teams. Let us know in your application if you have accessibility requirements during the interview.
Lead Data Engineer employer: TPXImpact
At Manifesto, we pride ourselves on being an exceptional employer that champions creativity and innovation in the heart of the digital experience sector. Our collaborative work culture fosters personal and professional growth, offering opportunities to mentor and lead while working on impactful projects for changemaker clients. With a commitment to ethical practices and a focus on using AI to enhance user experiences, we provide a dynamic environment where your contributions can truly make a difference.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Data Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. We all know that sometimes it’s not just what you know, but who you know that can help you land that Lead Data Engineer role.
✨Tip Number 2
Prepare for those interviews by brushing up on your technical skills and project experiences. We recommend practising common data engineering scenarios and being ready to discuss how you've tackled complex problems in the past.
✨Tip Number 3
Showcase your passion for data engineering! During interviews, share your thoughts on the latest trends and technologies in the field. We want to see that you’re not just qualified, but genuinely excited about the work you’ll be doing.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets the attention it deserves. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Lead Data Engineer
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the Lead Data Engineer role. Highlight your experience with data pipelines, cloud platforms, and any relevant projects that showcase your skills. We want to see how you fit into our team!
Showcase Your Technical Skills:Don’t hold back on your technical expertise! Mention your proficiency in programming languages like Python and SQL, as well as your experience with tools like Airflow and Databricks. We love seeing candidates who can communicate complex concepts clearly.
Demonstrate Leadership Experience:Since this is a lead role, it’s crucial to highlight your leadership experience. Share examples of how you've coordinated teams or set best practices in previous roles. We’re looking for someone who can inspire and guide others!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets the attention it deserves. Plus, you’ll find all the details about the role and our company culture there!
How to prepare for a job interview at TPXImpact
✨Know Your Data Engineering Stuff
Make sure you brush up on your data engineering principles, especially around data pipelines, ETL/ELT processes, and cloud platforms like AWS or Azure. Be ready to discuss your past projects and how you've optimised data flows.
✨Showcase Your Leadership Skills
As a Lead Data Engineer, you'll be expected to lead teams and set best practices. Prepare examples of how you've successfully managed teams, navigated ambiguity, and delivered impactful results in previous roles.
✨Communicate Clearly
You’ll need to explain complex technical concepts to both technical and non-technical audiences. Practice articulating your thoughts clearly and concisely, perhaps even using analogies to make your points relatable.
✨Prepare for Scenario Questions
Expect questions that assess your problem-solving abilities and how you handle uncertainty. Think of specific scenarios where you’ve had to make tough decisions or adapt to changing project requirements, and be ready to share those stories.