Senior Database Developer

Role Profile

LSEG are embarking on a Finance Transformation programme, delivering our Finance Vision and transforming 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 Redefining our abilities of managing Financial Crime via our internal Engineering capabilities.

We have an exciting opportunity for a Senior Database Developer to join our dynamic team within the London Stock Exchange Group, working as part of the Finance 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 at least 10 years’ experience for our Financial Crime Engineering Team. This is a hands-on development position for a candidate with demonstrable record of DB software development having excellent development and problem-solving skills, someone with creativity and self-motivation to deliver on mission critical projects with dynamic timelines and challenging 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 Senior Database Developer, you will be responsible for:

• Managing backlog, designing, developing, delivering and supporting data warehouse changes in an Agile methodology.
• Ensure database designs align with application requirements, organization standards, business goals, and scalability needs.
• Lead and Develop ETL pipelines and processes for OLAP systems and data warehouses.
• Managing data marts in multiple DB platforms as data warehouses
• Assisting with the development of data architecture to support product changes.
• Maintaining and optimising of data modelling through continuous improvements and enhancements.
• Working with product owners, business analysts, scrum master and other team members to deliver change on a timely basis
• Lead a team of Developers to deliver the product along with the desired functionalities and business outcomes.

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 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.
• Hands-on experience with Snowflake utilities: SnowSQL; Data Cloning; Data sharing and Access Control.
• Expertise in 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
• 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

• 10+ years of experience in various databases and ETL tools including Informatica, Matillion, Snowflake & Oracle
• 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.