Lead Engineer (EDP) – Data Transformation & Modelling Lab

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 to cloud and enabling Generative AI and Agentic AI through 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 the Data 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 products that serve as trusted, reusable assets across the organisation. 

• Developing toolkits and accelerators to enable rapid, secure, and scalable data migration to Google 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 in agile, cross-functional teams following Scrum principles—focused on iterative delivery, continuous improvement, and close collaboration with stakeholders. 

• As a Lead 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