Data Cleansing & Migration Analyst

PSD Group; Barcelona; Presencial; EUR 40.000 - 65.000; Jornada completa

Descripción de la vacante

PSD Group is seeking a Data Cleansing & Migration Analyst to support data quality, transformation, and migration within a large ERP programme. You will work closely with Data Owners and the Data Team to analyse, validate, cleanse, and transform data ensuring accuracy throughout the migration lifecycle.

The role requires strong Excel skills, experience with ERP data migrations, and a solid understanding of data governance in complex environments.

Formación

• Minimum 5 years in data analysis, data manipulation, data migration, or a related data-focused role.
• Strong understanding of data quality, data transformation, and data governance principles.
• Advanced Excel skills with complex formulas, data modelling, reconciliation, and large dataset analysis.
• Experience supporting ERP data migration and governance.
• Familiarity with Oracle ERP environments and SQL.
• Exposure to audit-controlled or highly regulated business environments.

Responsabilidades

• Extract, analyse, and manipulate data to support data quality assessments, cleansing initiatives, and migration activities.
• Review data objects and datasets, applying analytical thinking to identify issues and define data quality criteria.
• Develop and maintain manual data quality dashboards in Excel, with transition to automated reporting.
• Draft business glossaries and support data quality tools and documentation.
• Collaborate with Data Owners and stakeholders to identify data gaps and opportunities for improvement.
• Assist in data mapping, transformation, and migration activities across the ERP programme.
• Maintain documentation and audit trails for migration-related activities.
• Ensure data transformation processes are well-documented and compliant with governance.

Conocimientos

Data analysis

Data manipulation

Data migration

Data quality

Data governance

Advanced Excel

Analytical skills

Stakeholder engagement

ERP implementation experience

SQL

Oracle ERP environments

Herramientas

Microsoft Copilot

SQL clients

Descripción del empleo

Our client is a global technology organisation supporting the air transport industry through the delivery of mission-critical IT and communication solutions.

As part of a major ERP transformation programme, they are seeking a Data Cleansing & Migration Analyst to support data quality, transformation, and migration activities across the programme.

About the Role

The Data Cleansing & Migration Analyst will play a key role in supporting data quality improvement, data transformation, and migration activities within a large-scale ERP programme. Working closely with business stakeholders and the wider Data Team, the successful candidate will be responsible for analysing, validating, cleansing, and transforming data to ensure accuracy and integrity throughout the migration lifecycle.

Key Responsibilities:

Data Cleansing & Quality

• Extract, analyse, and manipulate data to support data quality assessments, cleansing initiatives, and migration activities.
• Review data objects and datasets, applying analytical thinking and best practice methodologies to identify issues and recommend data quality criteria.
• Develop and maintain manual data quality dashboards in Excel, transitioning to automated reporting solutions as they become available.
• Draft business glossaries and support the maintenance of data quality management tools and documentation.
• Work closely with Data Owners, Data Stewards, and business stakeholders to identify data gaps and opportunities for improving data quality.
• Support ongoing data cleansing activities by analysing, validating, and reconciling data across multiple domains.
• Define additional validation checks, metrics, and quality controls as data quality matures throughout the programme.
• Assist in the implementation of automated dashboards and document data quality rules, standards, and criteria within the data management framework.

ERP Data Migration & Transformation

• Support data mapping, transformation, and migration activities across the ERP programme.
• Maintain comprehensive documentation and audit trails for all migration-related activities.
• Ensure data transformation processes are accurately documented and compliant with programme governance and audit requirements.
• Assist with data validation, reconciliation, and issue resolution throughout testing and migration cycles.

What we are looking for

Skills & Experience Required:

• Minimum 5 years' experience in data analysis, data manipulation, data migration, or a related data-focused role.
• Strong understanding of data quality, data transformation, and data governance principles.
• Advanced Excel skills, including complex formulas, data modelling, reconciliation, and large dataset analysis.
• Experience using Microsoft Copilot or similar AI-enabled productivity tools, with the ability to independently review, validate, and challenge outputs.
• Strong analytical skills with the ability to transform, map, validate, and assess data accurately and securely.
• Experience working with structured and unstructured datasets within complex business environments.
• Excellent attention to detail and ability to maintain high levels of accuracy across large volumes of data.
• Strong communication and stakeholder engagement skills.
• Experience supporting ERP implementation or transformation programmes.
• Knowledge of Oracle ERP environments and associated data structures.
• Experience with SQL and data query tools.
• Familiarity with data quality management frameworks, business glossaries, and master data management principles.
• Exposure to audit-controlled or highly regulated business environments.