Data Engineer

Position: PCT Data Engineer

Location: Central London

Hybrid work (3 days per week onsite)

Description of role and key responsibilities:

Primary function of the role is to deliver high quality data engineering solutions to business and end users across Private Client Transactional and Lending teams – either directly via self-service data products, or by working closely with the Analytics team, providing modelled data products on which they can add reporting and analytics.

The candidate will be required to deliver to all stages of the data engineering process – data ingestion, transformation, data modelling and data warehousing, and build self-service data products. The role is a mix of Azure cloud delivery and on-prem (SQL) development. Ultimately all on-prem will be migrated to cloud and decommissioned

The role will work closely with our Architect, Engineering lead, Analytics team, DevOps, DBAs, and upstream Application teams in Private Client Technology

Specifically, the person will:

• Work closely with end-users and Data Analysts to understand the business and their data requirements
• Carry out ad hoc data analysis and ‘data wrangling’ using Synapse Analytics and Databricks
• Building dynamic meta-data driven data ingestion patterns using Azure Data Factory and Databricks
• Build and maintain business focused data products and data marts...