This role is within client's Risk & Compliance group as part of a global team to support a key platform migration. The platform organizes data collected from various front office businesses and prepares it for processing by Risk & Compliance projects.
The role sits within the Data Sourcing team which is responsible for obtaining and processing data from a large number of systems and normalizing the data into one platform.
The team is highly technical and the client use cutting edge technologies to build out a data lake using Big Data architecture.
Working with a global team, as part of building data platform and enhancing the number of systems that our client has data connectivity to.
Working across multiple IT and Business teams, owning and driving the delivery of solutions for data modeling, data understanding and data preparation and adhering to internal processes for the tooling required to accomplish this in an efficient, consistent and repeatable manner.
Providing regular updates to senior management and key stakeholders.
Technical BA, comfortable querying databases and analysing data.
1. Understand database concepts especially composite primary and surrogate keys
2. Be completely comfortable writing complex SQL queries and querying multiple data sources and tables
3. Any experience in Python / unix would be great but the consultant will spend most of his time in Excel, Sql and writing documents
4. Familiar with Jira / confluence and extremely well organized
5. Able to work in an agile / scrum environment
Nice to have
Datawarehouse / extensive database experience both querying modelling and contributing towards the contents
Any data management experience would be very valuable
ETL experience and building complex pipelines from an architectural or specification point of view
Working with Big data technologies and data lakes and how that differs from traditional database systems
Familiar with documenting data attributes, data feeds and data sources in a concise and succinct way and contributing to how the team evolves
Banking knowledge in particular trading / payments knowledge would be great
English : C1 Advanced