Analytics Engineer

Data Engineering And Analytics Role

This critical role sits at the intersection of Data Engineering and Data Analytics, focusing on transforming raw data into high-quality, trustworthy, and easily consumable datasets and visualisations for business users. The ideal candidate will possess a strong background in SQL, dbt, data modelling, ETL/ELT principles and experience with modern cloud data platforms.

Core responsibilities include:

• Develop and maintain transformation best practices in ELT pipelines.
• Implement best-practice data modelling and software engineering techniques.
• Write comprehensive data quality checks, tests, and monitoring scripts.
• Work closely with Data Analysts and business users to understand their reporting needs.
• Tune and optimise SQL queries and data models.
• Champion the adoption of modern data stack tools and practices.
• Build scalable, compelling data visualisations in Looker.

Required qualifications include:

• 3+ years of experience in a data-focused role.
• Expert-level proficiency in writing and optimising complex SQL queries.
• Hands-on experience with dbt or similar data transformation frameworks.
• Experience working with cloud-based data warehouses.
• Solid understanding of data warehousing concepts, ETL/ELT principles, and dimensional modelling techniques.
• Proficiency with Git for collaborative development and version control.
• Familiarity with reporting/ BI tools like Looker.

Preferred qualifications include:

• Python expertise for automation, integration, and orchestration.
• Experience with Semantic layers.
• Experience with orchestration tools like Airflow.
• Knowledge of modern software engineering practices applied to data.

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 London or 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.

Perk is a global company with a diverse customer base—and we want to make sure the people behind our product reflect that. We're an equal opportunity employer, which means you're welcome at Perk regardless of how you look, where you're from, or anything else that makes you, well, you.