ETL Support Engineer

We are seeking a skilled ETL Support Engineer to maintain and optimize enterprise ETL processes and data pipelines using Matillion and Informatica. This role is critical in ensuring the reliability, performance, and support of ETL workflows that serve Snowflake and various financial applications. The ideal candidate will have strong problem-solving skills, technical expertise in data integration, and a customer-focused approach to supporting ETL operations.

This role is ideal for a driven and detail-oriented ETL engineer passionate about ensuring data reliability, optimizing ETL processes, and supporting critical business applications. Must have a strong analytical mindset and thrive in a fast-paced support environment.

Key Responsibilities:

• Provide technical support and maintenance for ETL pipelines built in Matillion and Informatica, ensuring high availability and performance.
• Troubleshoot and resolve ETL job failures, data inconsistencies, and performance issues affecting Snowflake and financial applications.
• Monitor ETL job execution, identify failures or inefficiencies, and implement proactive improvements to enhance performance and stability.
• Support data movement and transformation across various systems while ensuring data integrity and compliance with business rules.
• Work closely with data engineers, analysts, and business teams to understand and resolve data-related challenges.
• Perform SQL query tuning and optimization within Snowflake to enhance ETL processing efficiency.
• Maintain and improve CI/CD pipelines for ETL deployments, ensuring smooth and automated deployments.
• Utilize scripting and programming languages (Python, Shell, or SQL) for automation, debugging, and data processing.
• Support API-based data integrations where necessary, ensuring secure and efficient data exchange.
• Ensure ETL security best practices, including data access controls and compliance with governance standards.
• Document troubleshooting steps, best practices, and system changes for knowledge sharing and process standardization.

Required Skills & Experience:

• 3-5+ years of experience in ETL support and operations, working with Matillion and Informatica.
• Strong expertise in SQL and Snowflake, including query optimization and data modeling concepts.
• Experience troubleshooting and optimizing ETL jobs, workflows, and data pipelines.
• Understanding of cloud-based ETL processing, especially in AWS or Azure environments.
• Familiarity with financial data processing and compliance requirements in enterprise environments.
• Knowledge of CI/CD practices and experience using tools like Git, Jenkins, or Azure DevOps for ETL automation.
• Hands-on experience with scripting languages (Python, Shell, or PowerShell) for automation and data processing.
• Proficiency in API-based data exchange and ability to troubleshoot REST/SOAP-based integrations.
• Experience with job scheduling and monitoring tools, ensuring ETL processes run efficiently and are properly logged.
• Strong problem-solving and analytical skills to handle complex ETL issues and optimize workflows.
• Excellent communication and collaboration skills to support users and work across different IT teams.

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. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

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

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.

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.