Data Engineer

Key Skills

Airline Crew Management-ACM, Amazon RedShift, Apache Hadoop, Apache Kafka, AWS, Big Data Technology, Business Intelligence, Data Biuld Tool - dbt, Data Engineering, Data pipelines, Effective communication skills, Google BigQuery, Luigi, PostgreSQL, Python Programming, Snowflake, SQL, Writing

Job Description

We are looking for a Data Engineer to scale our Data Operations team and help us improve our Data Governance & Data Integration processes. This Role’s mission will be:

• Ensure we are able to keep all data in our DWH updated and accessible for analysis
• Partner with the Data analysts to support the requirements of the company in terms of analytics, reliability and efficiency
• Develop and maintain data pipelines to extract data from different sources and integrate it in the DWH following data modeling best practices 

What you will do:

• Take charge of the required data processing while ensuring sustainable and organic growth of the data model and the infrastructure
• Keep our data infrastructure up to date and working like a clock
• Integrate and model datasets from different sources
• Support our Data Analysts & BI Developers to get the right data to build awesome dashboards and complex analytical models
• Support Product and Analytics teams in defining the best approaches for data modeling
• Use data to investigate and help resolve issues in our product or processes
• Proactively suggest improvements to data reliability, efficiency and quality
• Champion a healthy data culture throughout the organization

What you need:

• University degree in Computer Science, Engineering or similar
• 3+ years of relevant experience as a Data Engineer, Business Intelligence, Big-Data Engineer or similar role working with large-scale data systems
• Excellent communication skills, both written and spoken, in English
• You are a Master in SQL, optimizing queries for performance, scalability, and ease of maintenance
• You feel comfortable querying different types of databases (PostgreSQL, Redshift, Snowflake) and have knowledge of different AWS services
• You’re an ace at data modeling, accustomed to designing and implementing complex architectures with a constant eye on their future evolution while taking into account the needs of multiple users
• You have experience building data pipelines using Python
• You have experience integrating data from multiple sources including DBs, product tracking, and APIs. You get excited by seeing your jobs run like clockwork
• You have an instinct for automation
• You have the desire to work in an international environment, with minimal direction, and with highly engaged individuals

Bonus points for…

• Experience with AWS Redshift or other distributed systems (Snowflake, Big Query, Hadoop, Vertica, Exasol, etc.). Basic DBA skills
• Experience in web analytics and web tracking and event-based analytics tools
• Experience with workflow managers (Airflow, Luigi, etc.)
• Experience with dbt.
• Experience in queue and streaming systems (SNS, Kafka, Firehose…)

What do we offer?

• Competitive compensation including equity in the company
• Generous vacation days so you can rest and recharge
• Health perks such as private healthcare or gym allowance depending on your location
• Flexible compensation plan to help you diversify and increase the net salary
• Unforgettable TravelPerk events including to travel to one of our hubs
• A mental health support tool for your wellbeing
• Exponential growth opportunities

Our Vision is for a world where TravelPerk serves as the platform for human connection in-real-life (IRL). We take an IRL-first approach to work, where our team works together in-person 3 days a week. As such, this role requires you to be based within commuting distance of our Barcelona hub. We fundamentally believe in the value of meeting in-real-life to improve connectivity, productivity, creativity and ultimately making us a great place to work.

For certain roles, we can help with relocation from anywhere in the world, English is the official language at the office. Please submit your resume in English if you choose to apply. Do not forget to submit an updated portfolio and/or resume.