Data Warehouse Support Team Lead
About London Stock Exchange Group
London Stock Exchange Group (LSEG) is a diversified international exchange Group that sits at the heart of the world's financial community. The Group can trace its history back to 1801.
The Group operates a broad range of international equity, bond and derivatives markets, including London Stock Exchange, Europe's leading fixed income market; and the Pan-European equities and derivatives platform, Turquoise. Through its markets, the Group offers international business, and investors, outstanding access to Europe's capital markets.
Post trade and risk management services are a significant and growing part of the business operations. LSEG operates CC&G, the Rome headquartered CCP and Monte Titoli, the significant European settlement business, selected as a first wave T2S participant. The Group is also a majority owner of leading multi-asset global CCP, LCH.Clearnet.
The Group offers its customers an extensive range of real-time and reference data products, including Sedol, Unavista, Proquote and RNS, as well as access to over 200,000 international equity, bond and alternative asset class indices, through LSEG's world leading index provider, FTSE.
London Stock Exchange Group is also a leading developer of high-performance trading platforms and capital markets software. In addition to the Group's own markets, over 30 other organisations and exchanges around the world use the Group's Millennium IT trading, surveillance and post trade technology.
Headquartered in London, United Kingdom with significant operations in Italy, France, North America and Sri Lanka, the Group employs approximately 2,800 people.
We are looking for a Data Warehouse Support Team Lead to join our growing team of DevOps and QA professionals. The team lead report to the Product Manager for the corporate data warehouse.
Data Solutions for Capital Markets Technology team provide data solutions for Capital Markets business. The team is comprised of Corporate Data Warehouse (CDW), Business Intelligence and Front-End team, and Application Development (App Dev) team, Solution Architect team and Quality Assurance team. The team works as a collective to craft and build valuable data solutions for Capital Markets business.
The CDW Products team is responsible for delivering critical business logic such as billing and regulation requirements and data analytics requirements for BI reporting for the UK Equity, Derivatives Markets, Turquoise (pan-European Equity Markets) and Foreign Exchange:
The team is responsible for providing an AWS cloud-based data factory (Kafka, EMR, Spark and Flink). The cloud data warehouse is snowflake with Matillion as ELT tool.
is small, focused and Agile - consisting of a Product Manager, in-house developers, support staff, external consultants and QA teams;
builds upon and maintains local relationships with the Business and other Product teams (UK Equity Trading, Turquoise Trading and Surveillance teams) with regards to Strategy, Vision, Roadmaps, Business Requirements etc.;
progresses the Change Management process for Corporate Data Warehouse (CDW), BI and other applications within Data Solutions team;
helps the QA teams (offshore) to design, build and execute appropriate test suites;
works with users to train them, coordinating the test and acceptance of the final system solution (UAT);
gets the technology platform changes deployed into production (working with internal Technology Project Managers and teams who physically handle the environments and perform releases etc.);
2nd/3rd line production support (issue investigation and analysis, evaluation of priority with business).
Provide level 2 technical advice and risk assessment based on knowledge of applications, databases and system software;
Handle incidents following the Incident management process, and provide effective resolution of issues and problems;
Provide technical guidance to teammates through coaching and mentorship;
Maintain high standards of software quality by establishing good practices and habits, creating standards and supporting the business teams;
Identify and encourage areas for growth and improvement within the team;
Collaborate with other support teams, business analysts and solutions architects to plan, design, develop, test, and maintain the applications built on AWS technologies;
Ensure that all operational responsibilities are performed including regular checks, monitoring systems, compliance with security policies and deploying releases;
Assist in support roles, handling the daily lifecycle, planning and supporting integration testing with upstream and downstream systems, assisting reporting including regulatory reporting and also leading performance, security and licence management;
Assist in the collection and documentation of user's requirements, development of user stories, estimates and work plans. Provide updates to KPI and SLA reporting;
Prepare reports, manuals and other documentation on the status, operation and maintenance of software running the data warehouse including data landing, ETL Reporting and processing;
Reduce the number of recurring technical issues;
Provide on call support via a rotation;
Maintain relationships with suppliers and technical account managers;
A minimum of 5-7 years' experience with database technologies - preferably warehouse related, with relevant SQL skills;
A minimum of 2 years' experience as operation leader/team leader;
Experience in Oracle, CONTROL-M, Jira, ServiceNow, Snowflake and AWS would be preferred;
Extensive experience supporting enterprise level critical business systems;
Experience with change management and incident management and request managements systems and processes;
Experience with security and performance/capacity planning and monitoring;
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement;
Internally motivated, able to work proficiently both independently and in a team environment;
Good communication skills with both internal team members and external business partners;
Strong initiative to find ways to improve solutions, systems, and processes;
Team leadership experience with good skills in performance management and delegation;
Be comfortable working in a fast-moving environment where needs evolve rapidly and priorities change;
Self-motivated and pro-active;
Highly organized, self-disciplined and thorough;
Able to build good client (internal and external) relationships; establish and maintain rapport, orientation towards providing client service;
Interested in the evolution of the Equities and Derivatives trading landscape in Europe;
Happy to operate outside of their normal role when required.
We are looking for intellectually curious people, interested in the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you are a forward thinker and problem solver, this is the place to be as we will be supporting you to fast forward your career.
We maximise each employee's potential through personal development through a wide range of learning tools both formal and informal. We believe in remunerating our people with competitive salaries and a range of attractive benefits such as:
25 days' holiday per year
Share Purchase Plan
Private Medical Insurance
Pillar 3 Private Pension Plan
People are at the heart of what we do and drive the success of our business. Our culture of connecting, creating opportunity and delivering excellence shape how we think, how we do things and how we help our people fulfil their potential.
At LSEG we embrace diversity and actively seek to attract individuals with unique backgrounds and perspectives. We break down barriers and encourage collaboration, enabling innovation and rapid development of solutions that make a difference. Our workplace generates an enriching and rewarding experience for our people and customers alike. Our vision is to build an inclusive culture in which everyone feels driven to reach their potential.
We know that real personal growth cannot be achieved by simply climbing a career ladder - which is why we encourage and enable a wealth of avenues and interesting opportunities for everyone to broaden and deepen their skills and expertise.
LSEG are committed to supporting emotional, physical, financial and societal wellbeing. Our tailored benefits are a key part of this commitment and we offer colleagues a range of support from healthcare and retirement planning to paid volunteering days and consumer discounts.
We also make reasonable accommodations for applicants and employees with disabilities. If an accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please make your recruiter aware, we want to ensure you perform at your best.
As a global organisation spanning 70 countries and one rooted in a culture of growth, opportunity, diversity and innovation, LSEG is a place where everyone can grow, develop and fulfil your potential with purposeful careers.
Please take a moment to read this privacy notice carefully, as it describes what personal information the 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.