Job Role: Senior ETL Developer
Job Description:
The Senior ETL Developer is responsible for designing, developing, and maintaining robust, scalable, and secure data integration solutions that support enterprise management information, reporting, analytics, and regulatory needs. This role focuses on end-to-end ETL design and implementation, ensuring high-quality, reconciled, and well-governed data pipelines across cloud-based data platforms.
The position requires strong expertise in ETL tools, cloud data ecosystems, data modeling, and orchestration, with close teamwork across reporting, analytics, and governance teams to enable trusted enterprise data consumption.
Key Responsibilities:
Data Acquisition, Transformation & Integration
Design, develop, and enhance complex ETL workflows to acquire, transform, and load data from diverse source systems into enterprise data platforms such as Snowflake
Use enterprise ETL tools (e.g., AWS Glue, Ab Initio, Matillion, DataStage) to build scalable and reusable data pipelines
Implement robust data reconciliation, validation, and error-handling processes to ensure accuracy and completeness
Maintain strong data lineage and traceability across all ETL processes
Data Modeling & Performance Optimization
Design and implement unified data models, including star schemas and dimensional models, to support reporting and analytics
Optimize data structures and ETL logic to improve performance, scalability, and cost efficiency in cloud data environments
Partner with reporting and analytics teams to ensure ETL outputs align with downstream consumption needs
Cloud & Platform Engineering
Develop and operate ETL solutions within cloud environments (AWS and Azure)
Leverage cloud-native storage and compute capabilities while ensuring performance and reliability
Use Control-M to schedule, orchestrate, and monitor ETL jobs and dependencies
Governance, Security & Compliance
Apply data governance, security, and access control standards within ETL design and execution
Maintain metadata, documentation, and operational run books for all ETL assets
Support audit, regulatory, and compliance requirements through repeatable and well-documented data pipelines
Ensure audit trails and reconciliation controls are embedded within ETL processes
Collaboration & Continuous Improvement
Translate business and reporting requirements into detailed ETL technical designs
Work closely with data designers, MI/reporting teams, and platform engineers
Support production deployments
Mentor junior ETL developers
Required Skills & Experience
Technical Skills
Strong hands-on experience with ETL tools such as Ab Initio, Matillion, DataStage (or equivalent enterprise ETL platforms)
Advanced SQL skills with performance tuning experience
Experience working with Snowflake as an enterprise data warehouse
Solid grasp of data modeling concepts, including star schema and dimensional modeling
Experience with job scheduling and orchestration using Control-M
Familiarity with cloud platforms (AWS and/or Azure) for data solutions
Governance & Data Management
Knowledge of data governance, metadata management, and data security standards
Ability to design and detail out end-to-end data flows ensuring lineage
Experience embedding data quality and reconciliation controls in ETL pipelines
Preferred Qualifications
Experience in financial services, risk, regulatory, or management reporting environments
Familiarity with data cataloging tools and data quality frameworks
Experience supporting reporting tools such as Power BI (from a data producer perspective)
Strong analytical and problem-solving skills with high attention to detail
Career Level / Role Characteristics (for Design Alignment)
Role Type: Senior Individual Contributor – Data Engineering
Primary Capability: ETL Development & Data Integration
Complexity: Designs and delivers complex, enterprise-scale data pipelines
Autonomy: Works independently with limited supervision; provides guidance to others
Customer Impact: Supports enterprise MI, analytics, and regulatory reporting
Benefits
We are equal employer with hybrid working
Annual Leave, Parental Leave benefits
Upskilling opportunities with job relevant training and certifications
Dedicate Employee Helpline
Proud to share LSEG in the India is Great Place to Work certified (Jun ’25 – Jun ’26).
Learn more about life and purpose of our company directly from India colleagues’ video: Bengaluru, India | Where We Work | LSEG
Career Stage:
Senior AssociateLondon 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.
