Data Analyst Sql Server & Power Bi (Madrid)

Data Analyst Sql Server & Power Bi (Madrid)

25 ago
|
Swissport
|
Madrid

25 ago

Swissport

Madrid

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 general 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.
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.
"So, whatever we do, we do it purposefully and consciously, taking in the perspective of our colleagues, customers, and passengers.
"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.
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.
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.
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).
Methodical and organised approach to managing complex data.
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.

📌 Data Analyst Sql Server & Power Bi (Madrid)
🏢 Swissport
📍 Madrid

Postulate a este anuncio

Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: data analyst sql server & power bi (madrid) / madrid

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: data analyst sql server & power bi (madrid) / madrid