One of the biggest Lufthansa Data Warehouse system gathers, processes and provides data about: customers, tickets, journeys, B2B agreements, loyalty systems and many more customer related topics. All the above is supplemented by the scheduled and executed flights information.Such enterprise requires many engineers for the realization. The majority of the project is realized in Teradata technology based on SQL and bash scripts. The organization is based on the agile methodologies.
Who are we?
Lufthansa Systems Poland is acclaimed and widely recognized provider of superior services and IT solutions for the aeronautical, logistic and financial industries. As a part of the Lufthansa Group we implement technological solutions and dedicated services.
Who are you?
Commercial experience in Data Processing using : database procedural language (e.g.: T-SQL, PL/SQL) and ETL tools,
Min 2 years of experience in a similar position,
Very good knowledge of SQL,
Knowledge of Version Control tools,
Good knowledge of English and Polish in speaking and writing (B2/C1),
Team player with good communication skills,
Very good analytical thinking skills,
Readiness to work from the office in Gdańsk min. 2 days a week.
What do we welcome
Experience with ETL tools ( for ex.: Microsoft SSIS, Oracle ODI, Kettle ETL, Informatica ),
Database operations experience (partitioning, index/statistics maintenance, performance analysis),
General knowledge of Unix/Linux systems,
Knowledge about Agile/Scrum methodologies.
Why do we need you?
In this role, you will be responsible for:
Gathering and analyzing business requirements and expectations,
Finding relation between business requirements and existing data model,
Identification of new necessary data sources based on business requirements,
Providing proof-of-concepts in cooperation with business,
Planning of the stories and tasks including estimations for the realization of the identified requirements,
Implementing new functionalities based on gathered and analyzed requirements,
Developing changes and improvements in the existing processes,
Analysis of exceptional data configurations,
Implementation of import and export processes into and from the data warehouse,
Constant learning of business aspects,
Preparing documentation of the particular steps and the final product.
What do we offer?
An international working environment, atmosphere that stimulates development,
Individual career path,
Lufthansa Group membership benefits,
Salary in the range of 8 000 - 16 000 zł gross (contract of employment),
Support for your passion for sports within the local activity group and co-financing Multisport cards,
Private medical care for employees and their family members.