Data Analytics Specialist - Transformation

Swissport; Madrid; Híbrido; EUR 40.000 - 65.000; Jornada completa

Descripción de la vacante

Swissport in Madrid is seeking a data migration specialist to extract, cleanse and transform large datasets for a new enterprise platform.

The role focuses on ensuring data quality, applying business rules and performing migrations with multiple cycles and robust documentation. Strong SQL, Power BI and ETL tooling skills are required, with Dayforce experience preferred.

Formación

• Requires 3–5 years of experience with large datasets and data migration.
• Experience with data quality, cleansing, validation and reconciliation.
• Proficient in SQL and BI reporting using Power BI.
• Experience with Dayforce preferred.
• Experience with relational databases and ETL tooling.

Responsabilidades

• Extract high-volume datasets from multiple legacy systems using appropriate database query and extraction tools.
• Analyse complex datasets to identify data quality issues, inconsistencies, duplicates and missing information.
• Cleanse, standardise and transform data in accordance with agreed business rules and migration specifications.
• Prepare and format data for bulk upload into the target system using automated processes and migration tools.
• Perform data validation, reconciliation and integrity checks before and after migration activities.
• Investigate and resolve data anomalies, working with business stakeholders and technical teams where required.
• Develop repeatable extraction, transformation and loading (ETL) processes to improve efficiency.
• Produce data mapping documentation between source and target systems.
• Maintain comprehensive documentation of migration activities, assumptions, data issues and resolutions.
• Support multiple migration cycles including trial migrations, user acceptance testing and production cutover.
• Monitor data quality metrics and report progress, risks and issues to project management.
• Ensure compliance with organisational data governance, security and privacy requirements.
• Collaborate with business analysts, solution architects, developers and system owners throughout the migration programme.

Conocimientos

Advanced SQL

Power BI

Excel

Data governance

Problem solving

Herramientas

SSIS

Azure Data Factory

Talend

Informatica

Python

Descripción del empleo

About Swissport

We are a global leader in sustainable and responsible airport services provision, renowned for our unwavering commitment to safety, operational excellence, and exceptional service, shaping a future where air travel thrives on reliability, efficiency, and experience.

Location

Location: Madrid, Hybrid

About Swissport

We are a global leader in sustainable and responsible airport services provision, renowned for our unwavering commitment to safety, operational excellence, and exceptional service, shaping a future where air travel thrives on reliability, efficiency, and experience.

In 2023, with the support of more than 60,000 colleagues, Swissport provided best-in-class airport ground services for some 232 million airline passengers and handled roughly 4.7 million tons of air freight at 115 cargo centres. Across a global network that is unparalleled in the industry, Swissport served airlines at 286 airports in 44 countries across six continents.

The culture of Swissport is shaped by our corporate values, which guide our actions and decision-making processes. These values are at the core of our culture, shaping our business and underpinning our commitment to measuring our impact. They capture the essence of who we are at Swissport and help us deliver value across the entire company.

"Show You Care" underlines that our actions are perceived and valued from the perspective of the people around us. So, whatever we do, we do it purposefully and consciously, taking in the perspective of our colleagues, customers, and passengers.

"Doing the right things" means that we do the things that are valuable to our colleagues, customers, and passengers. We are trained to do this safely and trusted to do the right thing in any given situation.

"Win as a Team" highlights the importance of teamwork. Either we win as a team, or we fall as individuals. Together, we can surpass ourselves and handle any situation.

These values capture the essence of who we are and our unwavering commitment to excellence, and give actionable guidance for individual behaviour of employees, leaders, and executives, serving as a compass for how to act and deliver.

Job Summary

Support a major system implementation by extracting, analysing, cleansing, transforming and validating large volumes of data from legacy systems for migration into a new enterprise platform. The successful candidate will ensure data is accurate, complete and fit for purpose by applying data quality standards, business rules and reconciliation processes throughout the migration lifecycle.

Job Responsibilities

• Extract high-volume datasets from multiple legacy systems using appropriate database query and extraction tools.
• Analyse complex datasets to identify data quality issues, inconsistencies, duplicates and missing information.
• Cleanse, standardise and transform data in accordance with agreed business rules and migration specifications.
• Prepare and format data for bulk upload into the target system using automated processes and migration tools.
• Perform data validation, reconciliation and integrity checks before and after migration activities.
• Investigate and resolve data anomalies, working with business stakeholders and technical teams where required.
• Develop repeatable extraction, transformation and loading (ETL) processes to improve efficiency and accuracy.
• Produce data mapping documentation between source and target systems.
• Maintain comprehensive documentation of migration activities, assumptions, data issues and resolutions.
• Support multiple migration cycles including trial migrations, user acceptance testing and production cutover.
• Monitor data quality metrics and report progress, risks and issues to project management.
• Ensure compliance with organisational data governance, security and privacy requirements.
• Collaborate with business analysts, solution architects, developers and system owners throughout the migration programme.

Qualifications And Competencies

• Required years of experience: 3-5 years
• Experience working with large datasets beyond the practical limitations of Excel.
• Experience in data migration, system implementation or digital transformation projects.
• Strong understanding of data quality, cleansing, validation and reconciliation techniques.
• Experience extracting data from relational databases and legacy applications.
• Knowledge of data mapping and migration methodologies.
• Experience working in structured project environments.
• Understanding of data governance principles and information security.
• Experience with Dayforce (HRIS/HCM) is preferred.
• Advanced SQL for querying and manipulating large datasets.
• Experience with SQL Server, Oracle, PostgreSQL or MySQL.
• Familiarity with ETL tools or scripting languages such as SSIS, Azure Data Factory, Talend, Informatica, Python or PowerShell.
• Ability to work with multi-million-row datasets using appropriate database and analytics tools.
• Strong Excel skills for data analysis.
• Proven experience developing dashboards, reports and data visualisations using Microsoft Power BI (required).
• Highly analytical with excellent attention to detail.
• Methodical and organised approach to managing complex data.
• Strong problem-solving and investigative skills.
• Excellent communication skills with both technical and non-technical stakeholders.
• Able to work independently and collaboratively within a project team.
• Committed to delivering high-quality, accurate data under tight deadlines.

This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.