Senior Database Developer

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.