Data Warehouse Development Team Lead
We are looking for a Data Warehouse Development 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 manage the environments and perform releases etc)
2nd/3rd line production support (issue investigation and analysis, evaluation of priority with business)
Guide team development efforts towards successful project delivery.
Provide technical guidance to teammates through coaching and mentorship.
Maintain high standards of software quality within the team by establishing good practices and habits.
Identify and encourage areas for growth and improvement within the team.
Collaborate with other software developers, business analysts and solutions architects to plan, design, develop, test, and maintain the applications built on AWS technologies.
Oversee and manage the full development lifecycle, from analysis and production of business requirements, through development and testing, to deployment, including release management and change management.
Assist in support roles, managing the daily lifecycle, planning and supporting integration testing with upstream and downstream systems, assisting reporting including regulatory reporting and also managing performance, security and license management.
Assist in the collection and documentation of user's requirements, development of user stories, estimates and work plans.
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.
Design, develop, and unit test applications in accordance with established standards.
Participate in peer-reviews of solution designs and related code.
Package and support deployment of releases.
Analyze and resolve technical and application problems.
Adhere to high-quality development principles while delivering solutions on-time and on-budget. Provide third-level support to business users.
A minimum of 5-7 year's experience in design, performance tuning, development and experience with database technologies - preferably warehouse related.
A minimum of 2 years' experience as operation leader/team leader;
Experience in Oracle, PL/SQL development is essential
Experience in CONTROL-M, Jira, ServiceNow, Snowflake and AWS would be preferred;
Extensive experience designing and developing enterprise grade software
Experience with source control management systems and continuous integration/deployment environments
Experience with automated testing
Experience with agile development methodologies including Kanban and Scrum
Experience with change management and release management.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Internally motivated, able to work proficiently both independently and in a team environment
Strong communication skills with both internal team members and external business stakeholders
Strong initiative to find ways to improve solutions, systems, and processes Preferred
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.
Team player (co-operative, support, be flexible, take ownership, appropriate challenge, maturity etc.).
Highly organised, 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, passionate about the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you are creative and a problem solver, this is the place to be as will be supporting you to fast-forward your career.
We maximise each employee's potential through personal development and through a wide range of learning tools both formal and informal. We believe that 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
At LSEG, we believe that creating a diverse and inclusive organisation is fundamental to the way we deliver on our promise - and our purpose. You'll be part of an organisation of over 25,000 people, spanning 70 countries. We recognise the individual perspectives each of our colleagues brings, and our diverse workforce is one of our greatest strengths. In supporting collaboration and creativity and encouraging new ideas across a diverse and inclusive workforce, we can improve how we are driving financial stability, empowering economies and enabling customers to create sustainable growth.
LSEG offers a range of tailored benefits and support from healthcare and retirement planning to paid volunteering days and wellbeing initiatives.
We are an equal opportunities employer. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.
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.