Snowflake Senior Developer

As a Senior ETL Developer at London Stock Exchange Group (LSEG), you will be responsible for designing, developing, and maintaining robust, scalable, and secure data integration solutions that support enterprise management information, reporting, analytics, and regulatory needs. Your role will focus on end-to-end ETL design and implementation, ensuring high-quality, reconciled, and well-governed data pipelines across cloud-based data platforms. Key Responsibilities: - 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, AbInitio, 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 - 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 - 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 - 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 - 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 Qualifications Required: - Strong hands-on experience with ETL tools such as AbInitio, 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 If you are looking to join a dynamic organization that values innovation, quality, and continuous improvement, and you are ready to make a significant impact in the field of data engineering, London Stock Exchange Group (LSEG) welcomes you to apply for the Senior ETL Developer role. As a Senior ETL Developer at London Stock Exchange Group (LSEG), you will be responsible for designing, developing, and maintaining robust, scalable, and secure data integration solutions that support enterprise management information, reporting, analytics, and regulatory needs. Your role will focus on end-to-end ETL design and implementation, ensuring high-quality, reconciled, and well-governed data pipelines across cloud-based data platforms. Key Responsibilities: - 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, AbInitio, 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 - 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 - 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 - 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 - Translate business and reporting requirements into detailed ETL technical designs - W