Skills

Data Analysis SQL Data Warehousing Data Engineering DevOps Azure Data Factory Test Architecture Databases Azure Analytics Databricks

Job Specifications

Greetings! Adroit People is currently hiring

Title: PCT Data Engineer

Location: London, UK

Work Mode: Hybrid

Duration: Contract OR FTC

Keywords: PCT Data Engineer, Data Vault,T-SQL,KIMBALL

Role Purpose

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
Build and maintain Azure Analysis Services databases and cubes
Share support and operational duties within the wider engineering and data teams
Work with Architecture and Engineering teams to deliver on these projects. and ensure that supporting code and infrastructure follows best practices outlined by these teams.
Help define test criteria to establish clear conditions for success and ensure alignment with business objectives.
Manage their user stories and acceptance criteria through to production into day-to-day support
Assist in the testing and validation of new requirements and processes to ensure they meet business needs
Stay up-to-date with industry trends and best practices in data engineering

About the Company

Adroit People Ltd is a top-notch technology firm focused to deliver Staffing Services, IT Consulting, Implementation and Support Services in UK, Europe, USA, Asia-Pacific and Middle East. Adroit People Ltd creates and implements value-added solutions to its clients. It has got an excellent range of competencies in the implementation, maintenance and support of various technologies including ERP, Oracle and Web Technologies. As an end-to-end solutions/services provider, we strive to give the best solutions to our customers,... Know more