Hays Technology are looking for a Data Integration Developer for our public sector client. The role will be remote and will run until the end of March with a view to extend.
You will be responsible for:
Delivering an integrated data platform to combine workforce, learning, and (future) performance data from multiple systems:
- Unit4 (HR/Employee Data)
- Learning Pool (LMS Data)
- Nightly SQL/MariaDB Database Backups from Learning Pool
- Existing Data Lake assets
- Power BI consumption layer
In parallel, they are implementing Learning Pool User Provisioning via API, enabling automated CRUD operations for LMS accounts.
A dedicated resource is required to deliver the ingestion pipelines, modelling, API integrations, and operational components.
API Development
- Build integration to the Learning Pool External Extended API for Create, Retrieve, Update, and Delete LMS users.
- Implement all mandatory and optional schema attributes, including:
* Organisation hierarchy
* Position hierarchy
* Manager/appraiser assignments
* Custom fields
* Preferences
* Implement robust error-handling for all LP error codes.
Data Transformation
1. Build transformation logic to unify data from Unit4 and Learning Pool feeds.
2. Implement Slowly Changing Dimensions (SCDs Type-1[Overwrite] and Type-2 [Track History] handling.
3. Perform identity resolution...