Data Integration Developer
JOB_53697074764455Job type
ContractLocation
BirminghamWorking Pattern
Full-timeSpecialism
Software DevelopmentIndustry
Technology & Internet ServicesPay
£525 outside IR35
Data Integration Developer - Outside IR35
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:
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.
- Build 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
Data Integration DeveloperJOB_536970747644552026-01-232026-04-24
Talk to Harry Taylor, the specialist consultant managing this position
Located in Birmingham, 3rd Floor, One Colmore Square, Telephone 03330106462Click here to access our Privacy Policy, which provides detailed information on how we use and protect your personal information, and your rights in relation to this.
JOB_53697074764455