Data Integration Developer
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 layerIn 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 hierarchyPosition hierarchyManager/appraiser assignmentsCustom fieldsPreferencesImplement robust error-handling for all LP error codes.Data TransformationBuild transformation logic to unify data from Unit4 and Learning Pool feeds.Implement Slowly Changing Dimensions (SCDs Type-1 Overwrite and Type-2 Track History handling.Perform identity resolution using email as primary key (and fallback fuzzy matching if needed).Design schemas optimised for Power BI and semantic modelling Hays Specialist Recruitment Limited acts as an employment agency for
Perform a fresh search...
-
Create your ideal job search criteria by
completing our quick and simple form and
receive daily job alerts tailored to you!