Lead Data Engineer

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.

Benefits:

We are looking for intellectually curious people, passionate about the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios! If you are creative and a problem solver, this is the place to be as will be supporting you to fast-forward your career!

We maximise each employee’s potential through personal development through a wide range of learning tools both formal and informal. We believe in remunerating our people with competitive salaries and a range of attractive benefits such as:

25 days’ holiday per year

1 additional day off for your Birthday

Annual wellness allowance

Share Purchase Plan

Medical Health Insurance

Medical Subscription (preventive medical services)

Life insurance

Pillar 3 Private Pension

Meal Vouchers

Flexible Benefits

Bookster

Volunteering Events

All LSEG colleagues with at least one year’s continuous service, who become parents, are now entitled to at least 26 weeks’ paid leave, and the option to return to work on a phased basis, in relation with specific company’s policy and guidelines

Career Stage:

Senior Associate

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.