Explore and Apply for Bi Developer jobs in Liverpool, United Kingdom

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

• 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