Position: PCT Data Engineer
Location: Central London, UK
Duration: 6 Months Contract
Hybrid work (3 days per week onsite)
Need Immediate joiners only
Rate: 300 GBP/Day inside IR35
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
Core skills and knowledge:
Excellent data analysis and exploration using T-SQL
Strong SQL programming (stored procedures, functions)
Extensive experience with SQL Server and SSIS
Knowledge and experience of data warehouse modelling methodologies (Kimball, dimensional modelling, Data Vault 2.0)
Experience in Azure – one or more of the following: Data Factory, Databricks, Synapse Analytics, ADLS Gen2
Experience in building robust and performant ETL processes
Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)
Experience in using source control \& ADO
Understanding and experience of deployment pipelines
Excellent analytical and problem-solving skills, with the ability to think critically and strategically.
Strong communication and interpersonal skills, with the ability to engage and influence stakeholders at all levels.
To always act with integrity and embrace the philosophy of treating our customers fairly
Analytical, ability to arrive at solutions that fit current / future business processes
Effective writing and verbal communication
Organisational skills: Ability to effectively manage and co-ordinate themselves.
Ownership and self-motivation
Delivery focus
Assertive, resilient and persistent
Team oriented
Deal well with pressure and highly effective at multi-tasking and juggling priorities