Lead Engineer (EDP) – Data Transformation & Modelling Lab

Description

JOB TITLE: Lead Engineer (EDP) – Data Transformation & Modelling Lab

SALARY: £90,440 – £106,400 (Manchester) | £104,686 – £123,160 (London)

LOCATION(S): Manchester or London

HOURS: Full-time – 35 hours per week

WORKING PATTERN: Our work style is hybrid, which involves spending at least two days per week, or 40% of our time, at our Manchester or London office.

About this opportunity

If you think all banks are the same, think again. We’re an innovative, fast-changing organisation shaping finance as a force for good. Through brands like Lloyds Bank, Halifax, Bank of Scotland, and Scottish Widows, we serve over 26 million customers. Join us and help build a bank that empowers its people to innovate, explore possibilities, and grow with purpose.

We're committed to Help Britain Prosper and become the best bank for customers. As part of this, we're redefining our data and digital capabilities, providing customers with personalised, simpler, continuous interactions across online, mobile and branches. 

We're part of an ever-changing industry and are currently on a journey to shape the financial services of the future, whilst supporting our customers’ changing needs.

As part of our transformation, we’re modernising our data estate—migrating from on-premise platforms tocloud and enablingGenerative AI and Agentic AIthrough trusted, well-modelled data.

The scale and reach of our Group means we can offer a broad range of opportunities to learn, grow and develop. Our values-led culture and approach to inclusion and diversity means we can all make a real difference together.

You’ll be joining theData Transformation & Modelling Lab, a key part of our Data & Machine Learning Platform. The Lab plays a central role in shaping the bank’s future data landscape by:

Designing and maintaining the Group Data Model, ensuring consistency, reusability, and alignment with enterprise-wide data standards.

Building high-quality data productsthat serve as trusted, reusable assets across the organisation.

Developing toolkits and acceleratorsto enable rapid, secure, and scalable data migration toGoogle Cloud Platform (BigQuery).

Underpinning our strategy for Generative AI and Agentic AI, by ensuring data is well-modelled, governed, and accessible for advanced analytics and AI use cases.

We work inagile, cross-functional teamsfollowing Scrum principles—focused on iterative delivery, continuous improvement, and close collaboration with stakeholders.

As aLead Engineer, you’ll help define technical direction, mentor engineers, and deliver the foundational data capabilities that power the bank’s digital and AI-driven future.

What you’ll do 

Designing and evolving conceptual, logical, and physical data models aligned to business domains and data mesh principles.

Collaborating with domain teams to define and deliver high-quality, reusable data products on BigQuery.

Leading the transformation of legacy data models from on-premise platforms to cloud-native equivalents.

Ensuring data models are optimised for performance, scalability, and cost-efficiency in BigQuery.

Supporting the development of modelling standards, patterns, and best practices across the engineering community.

Partnering with data architects, engineers, and product owners to align modelling with enterprise architecture and strategic goals.

Mentoring junior engineers and modellers, fostering a culture of continuous learning and technical excellence.

Why Lloyds Banking Group

We’re on an exciting journey to transform our Group and the way we’re shaping finance for good. We’re focusing on the future, investing in our technologies, workplaces, and colleagues to make our Group a great place for everyone. Including you!

What you’ll need

Data Modelling & Architecture:

Expertise in conceptual, logical, and physical data modelling, including dimensional modelling and metadata management; experience in using a tool such as ER Studio.

Experience designing models for analytical and operational use cases in regulated environments.

Strong understanding of canonical modelling, schema evolution, and data contract design.

Cloud & BigQuery Engineering:

Hands-on experience with Google BigQuery, including query optimisation, partitioning, clustering, and federated queries.

Familiarity with GCP services such as Cloud Storage, Dataflow, Pub/Sub, and Looker.

Experience building scalable data pipelines and ELT workflows in cloud-native environments.

Data Mesh & Distributed Architecture:

Knowledge of data mesh principles: ownership focused on specific areas, treating data as a product, decentralized governance, and user-friendly infrastructure.

Experience collaborating with domain teams to define and publish data products.

Knowledge of interoperability standards and API-driven data sharing.

Tooling & Engineering Practices:

Proficiency in SQL and Python; experience with dbt, Dataform, or similar ELT tools.

Familiarity with orchestration tools like Airflow or Cloud Composer.

Exposure to CI/CD, Git-based workflows, and infrastructure-as-code (e.g., Terraform).

Governance & Compliance:

Experience with data cataloging, lineage, and quality tools (e.g., Collibra, Alation, GCP Data Catalog).

Strong understanding of data security, access control, and compliance frameworks (e.g., GDPR, BCBS 239).

Leadership & Collaboration:

Proven ability to lead technical design discussions and influence architectural decisions.

Strong stakeholder engagement skills, with the ability to translate business needs into scalable data solutions.

Experience in mentoring and coaching engineers and modellers.

Ability to lead multi-disciplinary, mixed, geographically distributed teams across the project lifecycle.

About working for us

Our ambition is to be the leading UK business for diversity, equity and inclusion supporting our customers, colleagues and communities and we’re committed to creating an environment in which everyone can thrive, learn and develop.

We were one of the first major organisations to set goals on diversity in senior roles, create a menopause health package, and a dedicated Working with Cancer Initiative.

We offer reasonable workplace adjustments for colleagues with disabilities, including flexibility in office attendance, location and working patterns. And, as a Disability Confident Leader, we guarantee interviews for a fair and proportionate number of applicants who meet the minimum criteria for the role with a disability, long-term health or neurodivergent condition through the Disability Confident Scheme.

We provide reasonable adjustments throughout the recruitment process to reduce or remove barriers. Just let us know what you need.

We also offer a wide-ranging benefits package, which includes:

A generous pension contribution of up to 15%

An annual performance-related bonus

Share schemes including free shares

Benefits you can adapt to your lifestyle, such as discounted shopping

30 days’ holiday, with bank holidays on top

A range of wellbeing initiatives and generous parental leave policies

At Lloyds Banking Group, we're driven by a clear purpose; to help Britain prosper. Across the Group, our colleagues are focused on making a difference to customers, businesses and communities. With us you'll have a key role to play in shaping the financial services of the future, whilst the scale and reach of our Group means you'll have many opportunities to learn, grow and develop.

We keep your data safe. So, we'll only ever ask you to provide confidential or sensitive information once you have formally been invited along to an interview or accepted a verbal offer to join us which is when we run our background checks. We'll always explain what we need and why, with any request coming from a trusted Lloyds Banking Group person. 

We're focused on creating a values-led culture and are committed to building a workforce which reflects the diversity of the customers and communities we serve. Together we’re building a truly inclusive workplace where all of our colleagues have the opportunity to make a real difference.