Senior Data Engineer

Summary: Senior or lead data engineer with good analytical and visualisation skills. Good consultancy skills and able to work independently. Client: are driving innovative and reusable AI solutions across the International Airlines Group. Project: Working as part of our ongoing engagement with ai as part of an executive support team providing data science, analysis and insight to support board decision making. There are a number of CGI colleagues working in different roles across ai but you would be working independently as part of a client team. Dates: ASAP to end of the year, good chance of extension Location: London or Barcelona

• Requisitos y habilidades.

Core (Must-Have) Skills

• Strong SQL proficiency to query complex datasets efficiently and reliably.
• Strong analytical thinking, especially around aggregating and transforming large datasets to answer business questions.
• Experience designing simple, fit-for-purpose data pipelines to move data from raw/silver layers to gold-layer summaries.
• Comfort with producing summary statistics and aggregations (e.g., average fares by week, cabin, route).
• Basic plotting/visualisation skills, sufficient to generate clear outputs for Excel reports or slides. Tool-agnostic: Python, Excel, Power BI, etc.. but python+plotly preferred.
• Ability to structure queries and outputs for business-facing consumption, particularly in regulatory or policy contexts.
• Requisitos necesarios: Experiencia mínima de 5 años desarrollando en Oracle Forms&Reports.
• Requisitos valorables: Nice-to-Have Skills Knowledge of Snowflake, current data warehouse is there Python for data visualisation, especially with Plotly. Familiarity with revenue management, airline pricing, or fare ladders. Basic understanding of econometric techniques, e.g., Diff-in-Diff, fixed effects Experience working with large-scale datasets (1bn+ rows), including performance optimisation. Ability to build lightweight dashboards or summary views for exploratory analysis. Comfort operating in structured, strategic project environments (e.g., staged reviews, legal deliverables, Excel-first reporting). Modalidad del puesto: Posición híbrida: 1 en casa del cliente/oficina de CGI y 2 días de teletrabajo (pueden ser 3 días teletrabajo) Ubicación: Barcelona, * Analytical Thinking
• Data Engineering
• Oracle Forms
• Oracle Report
• Spanish
• SQL
• English