Hybrid Data Modeler: Migration & Governance Lead

ASCO - Workforce Solutions; Aberdeen City; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

ASCO - Workforce Solutions in Aberdeen places data at the core of a multi-year transformation. The Data Modeller will develop and maintain a Group data model across systems, including the AX replacement and orchestration layer.

You will establish data modelling capability and govern data standards for future projects. Under the Data Lead, you will profile data, define domains, ownership and quality rules, and design migration mappings for live implementations while ensuring governance and

Qualifications

• Proven experience in data modelling and migration for business system replacements, including designing target data models and migration mapping rules for live implementations.
• Practical experience in data profiling, cleansing, deduplication and reconciliation of operational data.
• Working knowledge of master data management, including golden records and survivorship rules.
• Able to work independently with limited onboarding and unfamiliar data.
• Designs data models that reflect business operations rather than simply existing system structures.
• Takes a rigorous, evidence-based approach to data quality and reconciliation, identifying issues early and challenging teams where data is not ready.
• Communicates data quality issues clearly in business and operational terms.
• Maintains Group data standards under delivery pressure.
• Methodical in documenting decisions and processes.
• Understands how structured data supports future AI and analytics opportunities.

Responsibilities

• Assess and profile existing data, identifying quality issues, ownership and migration feasibility.
• Define data domains, master data standards, golden sources, reference data and data ownership.
• Develop and maintain Group data models, schemas, data dictionaries and naming standards.
• Establish data quality rules, validation criteria, cleansing and deduplication requirements.
• Design target data models, migration mappings and transformation rules for assigned systems.
• Assess data migration and integration feasibility against potential platforms.
• Build, test and execute migration scripts, cleansing activities and rehearsal runs.
• Validate migrated data, ensuring quality, accuracy and reconciliation between existing and new systems.
• Provide migration evidence to support testing and go-live decisions.
• Support the Data Governance Council with data standards, quality measures and reporting.
• Ensure alignment with Group data standards and document modelling and migration decisions.
• Ensure models, data ownership and quality monitoring are effectively handed over for ongoing business use.

Skills

Data modelling

Data migration

Data profiling

Data cleansing

Data quality

Master data management

Stakeholder communication

Independent working

Documentation

Education

Degree in computing

Tools

Microsoft Fabric

Azure

Dataverse

Power BI

Dynamics 365 data models

Job description

ASCO - Workforce Solutions in Aberdeen places data at the core of a multi-year transformation. The Data Modeller will develop and maintain a Group data model across systems, including the AX replacement and orchestration layer.

You will establish data modelling capability and govern data standards for future projects. Under the Data Lead, you will profile data, define domains, ownership and quality rules, and design migration mappings for live implementations while ensuring governance and