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. Such enterprise requires many engineers for the realization. The majority of the project is realized in Teradata technology and based on SQL scripts. The organization is based on the agile methodologies. At the moment only some parts of the project are transferred or created from scratch in Azure technology.
The target for this data warehouse is the migration to Azure platform using (Data Bricks, Data Factory and Azure Synapse) and our engineers are expected to work in that environment in the future.
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?
Your profile:
- Knowledge of Database technology,
- Knowledge of SQL,
- Good knowledge of English in speaking and writing (B2/C1),
- Team player with good communication skills.
What do we welcome?
- Experience and knowledge of database procedural language (for ex.: T-SQL, PL/SQL),
- Experience with ETL tools ( for ex.: Azure Data Factory, Microsoft SSIS, Oracle ODI, Kettle ETL, Informatica ),
- Knowledge of Agile/Scrum methodologies,
- Experience with Azure ( DataBricks, DataFactory ),
- Database operations experience ( partitioning, index/statistics maintenance, performance analysis ),
- General knowledge of Unix/Linux systems,
- Knowledge of Python ( including Numpy and Pandas ),
- Experience with Version Control tools.
Why do we need you?
You will responsibilities for:
- Analyze business requirements in the area of Data Engineering,
- Analyze issues related to inappropriate data,
- Propose technical solution in the form of new or changed database structures and processes,
- Develop the proposed solution,
- Prepare the development to the deployment,
- Documentation maintenance.
What do we offer?
- An international working environment, atmosphere that stimulates development,
- Individual career path,
- Salary in the range of 6 000 - 11 000 zł gross (contract of employment),
- Lufthansa Group membership benefits,
- Flexible working time and place adjusted to employee’s needs. Possibility of starting your workday between 07:00 and 11:00,
- 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.
