Job Overview

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.

Role Profile

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.

The team:

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).

Responsibilities:

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;