Data Modeller

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

Employment Type: Permanent

Location: Aberdeen (Preferred)

Hours of Work: 37.5 hours per week, Monday - Friday - Hybrid working to be agreed

ASCO is undertaking a multi-year business systems transformation to modernise its core operational and financial systems, improve business processes and support future growth across existing and new markets. Working under the Data Lead, the Data Modeller will develop and maintain a consistent Group data model across multiple system implementations, including core operational systems, the AX replacement and orchestration layer. This permanent role will also establish data modelling capability within the business for the future.

Key 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.

Minimum Competencies (Skills, Knowledge and Behaviours)

• 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.

Minimum Qualifications

• Degree in a numerate or computing discipline, or equivalent.

Desirable Qualifications/Competencies

• Experience with Microsoft data platforms, including Fabric, Azure and Dataverse.
• Experience with PowerBI with a focus on dashboards and performance management
• Familiarity with Microsoft AX and Dynamics 365 data models.
• Background in logistics, supply chain, marine, energy services or industrial services.
• Experience delivering data projects across multiple countries or legal entities.
• Experience implementing master data management platforms.
• Knowledge of GS1 standards and product or container identification data.
• Understanding of data residency and privacy requirements across jurisdictions.
• DAMA Certified Data Management Professional (CDMP).
• Current Microsoft data certification.