Data Engineer

Role Profile

LSEG are embarking on a Finance Transformation programme, delivering our Finance Vision and redefining the way we work to bring value and deliver sustainable growth for the business.  The Programme shall drive efficiencies and maximise benefits for LSEG by Transforming our abilities of managing Financial Crime via our internal Engineering capabilities.

We have an exciting opportunity for a Data Engineer to join our dynamic team within the London Stock Exchange Group, working as part of the Financial Crime Engineering team, and supporting LSEG through designing and developing data warehousing solutions and integration of our core systems.

The role sits within the Corporate Engineering Delivery function, which provides technology services to Corporate Functions Teams for LSEG and we are looking for someone with demonstrated ability for our Financial Crime Engineering Team. This is a hands-on development position for a candidate with demonstrable record of working with data analysis and database development having excellent development and problem-solving skills, someone with creativity and self-motivation to deliver on critically important projects with timelines and competing priorities and execution excellence (preferably in Financial Services) in supporting enterprise applications across various business units and has good exposure to various database engineering platforms.

As a Data Engineer, you will be responsible for:

• Work with a team of Developers to deliver the product led by data along with the desired functionalities and business outcomes.
• Managing backlog, designing, developing, delivering and supporting data warehouse changes in an Agile methodology.
• Ensure data structure and database designs align with application requirements, organization standards, business goals, and scalability needs.
• Develop ETL pipelines and processes for OLAP systems and data warehouses.
• Managing build and release activities for data solutions
• Assisting with architecture artefacts to support product changes.
• Maintaining and optimizing of data modelling through continuous improvements and enhancements.
• Working with product owners, architects, business analysts, scrum master and other team members to deliver change on a timely basis

Knowledge/Skills

• Hands on experience in writing advanced SQL Queries.
• Strong analytical problem-solving skills
• Hands on development experience with solid skills in designing, developing and deploying complex applications using OLTP and OLAP based databases. 
• Hands on expertise in Physical Data Modeling and DB design with solid skills in performance tuning.
• Hands on experience in troubleshooting and resolving database performance issues.
• Hands on experience in building systems using modern, scalable, resilient, cloud native architectures. Experience on AWS is desirable.
• Hands on experience with multiple databases along with Snowflake and implementing complex stored procedures
• Good knowledge of data modeling concepts like dimensional modeling and DWH concepts like change data capture (CDC)
• Hands-on experience in Matillion, Boomi or any other ETL tools
• Scripting knowledge (e.g. Python, Spark etc.) would be desirable
• Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
• Worked in Offshore / Onsite Engagements and collaborated across time zones
• Should be a great teammate
• Should be eager to learn new technology and/or functional areas

Experience

• At least 6 years of experience in various databases and ETL tools like Informatica, Matillion
• Must have ETL E2E experience in documentation, development, testing & deployment to Production
• Bachelor’s degree in computer science or related field
• Strong Relational Database background and SQL Skills
• Proficiency in automation and continuous delivery methods 
• Proficiency in all aspects of the Software Development Life Cycle in an Agile environment
• Experience leading & managing a development team, preferably in a financial technology or banking MNC.

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.