Opis oferty pracy
Expected, SQLOptional, Python, PySpark, DatabricksOperating system, Windows, LinuxAbout the project, 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.Your responsibilities, 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.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.Optional, General knowledge of Unix/Linux systems,, Database operations experience (partitioning, index/statistics maintenance, performance analysis),, Experience with Teradata,, Knowledge of Python (Numpy, Pandas),, Knowledge about Agile/Scrum methodologies.Team size, 3-4This is how we work, in house, you focus on a single project at a time, you develop the code "from scratch", you focus on product development, agileDevelopment opportunities we offer, conferences in Poland, development budget, external training, intracompany training, mentoring, soft skills training, substantive support from technological leaders, support of IT events, technical knowledge exchange within the companyWhat we offer, An international working environment, atmosphere that stimulates development,, Individual career path,, 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.Benefits, sharing the costs of sports activities, private medical care, sharing the costs of professional training & courses, life insurance, flexible working time, fruits, corporate products and services at discounted prices, no dress code, coffee / tea, drinks, parking space for employees, leisure zone, extra social benefits, holiday funds, sharing the costs of holidays for kids, sharing the commuting costsLufthansa Systems, 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.This is how we work,