The role will focus on designing and building robust data pipelines, migrating data from a wide range of legacy and enterprise source systems, and establishing scalable data flows into Azure Data Lake and Databricks. A key part of the role will also involve integrating data into a proprietary data transformation solution where applicable.
Key Skills & Experience
* Azure Data Engineering
* Azure Data Factory (ADF)
* Azure Data Lake
* Databricks
* Building ETL / ELT pipelines
* Large-scale data migration and integration
* Oracle and/or Oracle Fusion data sources
* SharePoint data extraction and integration
* Working with multiple and varied source systems
* Data transformation, mapping and validation
* Designing data pipelines in environments where architecture and processes are still developing
Key Responsibilities
* Design, build and maintain data migration and ingestion pipelines within Azure.
* Support the setup and development of the Azure Data Lake environment.
* Build integrations between source systems, Azure Data Lake and Databricks.
* Develop and manage pipelines using Azure Data Factory (ADF).
* Extract and migrate data from a variety of source systems, including:
* Oracle
* Oracle Fusion
* Informatica
* SharePoint, which will be an initial priority
* Additional enterprise and legacy systems as the programme develops
* Help define scalable data ingestion, transformation and migration patterns for future source systems.
* Support data quality, validation and troubleshooting throughout the migration process.
* Work closely with technical and business stakeholders to understand source data, target structures and transformation requirements.
* Help improve the overall maturity of the Azure data environment, introducing appropriate engineering standards and best practices
Salary description
£450.00 - £500.00 per day