Data Modeller

ASCO Group; Aberdeen City; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

ASCO Group in Aberdeen is seeking a Data Modeller to develop and maintain a Group data model across multiple system implementations, including core operational systems and the AX replacement.

This permanent role will establish data modelling capability, profile data, define domains, mappings and data dictionaries, support governance and ensure quality and handover for ongoing use.

Qualifications

• Proven experience in data modelling and migration for business system replacements.
• Practical experience in data profiling, cleansing, deduplication and reconciliation of operational data.
• Working knowledge of master data management, including golden records and survivorship rules
• Degree in a numerate or computing discipline, or equivalent.

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

Deduplication

Data reconciliation

Master data management

Data ownership

Education

Degree in numerate or computing discipline

Tools

Microsoft Fabric

Azure

Dataverse

Power BI

Dynamics 365

GS1 standards

Job description

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.

Employment Type: Permanent

Location: Aberdeen (Preferred)

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.