Middle/Senior BI Engineer for Ciklum Digital (TUI)

Remote, Kyiv, Lviv, Kharkiv, Vinnytsia, Dnipro, Odessa

Apply

TUI is the world’s leading tourism group. The broad portfolio gathered under the Group umbrella consists of strong tour operators, 1,600 travel agencies and leading online portals, five airlines with around 150 aircraft, over 400 hotels, 17 cruise liners and many incoming agencies in all major holiday destinations around the globe. It covers the entire tourism value chain under one roof. This integrated offering enables us to provide our 27 million customers with an unmatched holiday experience in 180 regions. A key feature of our corporate culture is our global responsibility for economic, environmental and social sustainability. This is reflected in more than 20 years of commitment to sustainable tourism. The TUI Group’s share is listed in the FTSE 250 index, in the Quotation Board of the Open Market on the Frankfurt Stock Exchange, and regulated Market of the Hanover Stock Exchange.

Read more about the client

Description

On behalf of Ciklum Digital, Ciklum is looking for a Middle/Senior BI Engineer to join the UA team on a full-time basis.

You will join a highly motivated team and will be working on a modern solution for our existing client. We are looking for technology experts who want to make an impact on new business by applying best practices and taking ownership

Project description: Client is a world leader travelling company. This project’s team includes cross functional members who operate in the area of customer experience. Role of the BI Engineer is to work on the delivery of the solution along with data engineers and analytics. BI Engineer will keep close contact with the stakeholders (business, IT function, analytics team) to ensure truly data driven decision processes that meet the needs of the business.

Technology Stack: SQL, AWS, Snowflake, DBT

Responsibilities

  • Responsible for data on all stages of its life cycle, starting from feature selection and ingestion, and up to its understanding by end-user via documentation and exploration
  • Acquire, create and manage innovative data assets for the team. These assets will draw from various sources – internal and external systems, flat files, databases and external APIs
  • Evaluate user requests for new or re-engineered analytics and reporting solutions to determine their feasibility, time requirements and their compatibility with current systems and architecture standards
  • Active participation in the development of the data lake, data marts and subsequent enhancements, including the creation of new data solutions to support development of analytic capabilities
  • Interact with stakeholders regarding data availability and report format/presentation, to ensure the report provides the information the stakeholders need without compromising the report’s accuracy
  • Deliver new capabilities to the business through agile methods – experiences with Scrum and Jira are a plus

Requirements

  • 3+ years of experience coding in SQL, with solid CS fundamentals including data structure and algorithm design
  • 1+ years of hands-on experience working with DWH and Big Data technologies
  • 1+ years of experience in cloud data platforms (AWS)
  • The ability to design, implement and use effective database structures to ensure data is organised effectively and ready for downstream development of data science and analytics
  • Experience working in a structured environment and desire for good documentation, exceptional delivery, effective organisation, and high-quality communication
  • Hands on experience with modern data storage systems (e.g. S3, Snowflake, Athena, Glue)
  • Feeling comfortable using AWS, Kubernetes, Docker and Airflow
  • Strong SQL and data profiling skills
  • Hands-on ELT experience using tools like Streams and Tasks or DBT
  • Familiarity with a traditional BI application such as Power BI, Tableau or Spotfire
  • Knowledge of data types including JSON, XML, YAML is a plus
  • Solid understanding of data warehousing principles, concepts and best practices (e.g. ODS, Data Mart, Data Lakes, Data Vault)
  • Strong problem solving and analytic skills

Desirable

  • Understanding of cloud infrastructure design and implementation
  • Experience in backend development and deployment
  • Experience in CI/CD configuration
  • Good knowledge of data analysis in enterprises

Personal skills

  • Curious mind and willingness to work with client in consultative manner to find areas to improve
  • Upper-Intermediate or Advanced English
  • Good analytical skills
  • Good team player, motivated to develop and solve complex tasks
  • Self-motivated, self-disciplined and result-oriented
  • Strong attention to details and accuracy

What's in it for you

  • A Centre of Excellence is ultimately a community that allows you to improve yourself and have fun. Our centers of excellence (CoE) bring together all Ciklumers from across the organization to share best practices, support, advice, industry knowledge and to create a strong community
  • Close cooperation with client
  • A constant flow of new projects
  • Dynamic and challenging tasks
  • Ability to influence project technologies
  • Projects from scratch
  • Team of professionals: learn from colleagues and gain recognition of your skills
  • European management style
  • Continuous self-improvement