Lead Data Engineer

About Us:

LSEG (London Stock Exchange Group) is more than a diversified global financial markets infrastructure and data business. We are dedicated, open-access partners with a dedication to excellence in delivering the services our customers expect from us. With extensive experience, deep knowledge and worldwide presence across financial markets, we enable businesses and economies around the world to fund innovation, manage risk and create jobs. It’s how we’ve contributed to supporting the financial stability and growth of communities and economies globally for more than 300 years. Through a comprehensive suite of trusted financial market infrastructure services – and our open-access model – we provide the flexibility, stability and trust that enable our customers to pursue their ambitions with confidence and clarity.

LSEG is headquartered in the United Kingdom, with significant operations in 70 countries across EMEA, North America, Latin America and Asia Pacific. We employ 25,000 people globally, more than half located in Asia Pacific.

Role Summary:

We’re looking for a strategic and hands-on Lead Data Engineer who can own the data ecosystem, drive architectural decisions, and ensure robust, scalable data workflows. This role combines technical leadership with deep engineering expertise, perfect for someone who thrives on building reliable systems and mentoring others. 

What You’ll Do:

• Architect, design, and maintain complex data pipelines in Azure Data Factory, ensuring efficiency, scalability, and reliability. 

• Build and optimize data models and transformations using SQL Server. 

• Develop Python scripts for automation, data processing, quality checks, and integration tasks. 

• Implement and optimize Databricks workflows for advanced analytics, Spark-based processing, and collaborative notebook development. 

• Fix pipeline issues and implement long-term improvements that strengthen data quality and system resilience. 

• Collaborate with multi-functional teams to align data solutions with business objectives and decision-making needs. 

• Mentor junior engineers and establish best practices for data engineering and governance.

What You’ll Bring:

Must-Have Skills 

• Expert-level experience with Azure Data Factory for orchestrating complex ETL/ELT workflows. 

• Strong proficiency in SQL Server, including performance tuning and advanced query optimization. 

• Practical Python (pyspark) experience for data manipulation, automation, and pipeline logic. 

• Hands-on expertise with Databricks for Spark-based processing, data analytics, and notebook workflows. 

• Proven ability to design scalable data architectures and lead technical initiatives. 

Nice-to-Have Skills 

• Familiarity with AWS Athena for interactive query processing. 

• Experience with Terraform for infrastructure as code and managing cloud resources. 

• Knowledge of data governance, security standard methodologies, and distributed systems. 

Soft Skills We Value 

• Leadership attitude - able to guide teams and influence technical direction. 

• Proactive problem-solving and a focus on business impact. 

• Strong communication and ability to drive alignment across engineering and product teams. 

• Ownership and accountability for quality, reliability, and scalability. 

Career Stage:

Compensation Information:

Benefits Information:

LSEG roles (excluding internships) are typically eligible for inclusion in our LSEG Benefits program. To view the benefits available for the role you're applying for, please click here. This document provides a list of benefits by country. Simply click on the country where the role is based to view the relevant details. If you have specific questions or would like further details, these can be discussed during your interview.

London Stock Exchange Group (LSEG) Information:

Join us and be part of a team that values innovation, quality, and continuous improvement. If you're ready to take your career to the next level and make a significant impact, we'd love to hear from you.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyone’s race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.

You will be part of a collaborative and creative culture where we encourage new ideas. We are committed to sustainability across our global business and we are proud to partner with our customers to help them meet their sustainability objectives. Our charity, the LSEG Foundation provides charitable grants to community groups that help people access economic opportunities and build a secure future with financial independence. Colleagues can get involved through fundraising and volunteering.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what it’s used for, and how it’s obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.