Analytics Engineer

Perk; Greater London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading technology company in London seeks a Data Engineer to design and maintain ELT pipelines leveraging SQL and dbt. The ideal candidate will have over 3 years in data roles and experience with Snowflake and Looker. This position offers flexibility to work from home while requiring presence in the London office three days a week. Join a dynamic team dedicated to transforming raw data into actionable insights. Opportunities for relocation are also available.

Qualifications

• 3+ years experience in a data-focused role.
• Expert-level proficiency in writing SQL queries.
• Hands-on experience with dbt or similar frameworks.

Responsibilities

• Design, develop, and maintain scalable ELT pipelines.
• Implement best-practice data modelling techniques.
• Write data quality checks and monitoring scripts.

Skills

SQL

dbt

data modelling

cloud data platforms

data quality

Tools

Snowflake

Looker

Git

Airflow

Job description

About Us

Perk (formerly TravelPerk) is an intelligent platform for travel and spend management, automating everything from travel bookings to expenses and invoice processing. We power real work for over 10,000 companies worldwide.

Founded in 2015, Perk has grown to 1,800+ people across 12 offices globally, with headquarters in London and Boston. We value curiosity, purpose, and teamwork.

Overview

This role sits at the intersection of Data Engineering and Data Analytics, transforming raw data into high‑quality, trustworthy datasets and visualisations for business users. It requires strong SQL, dbt, data modelling, and experience with cloud data platforms.

Core Responsibilities

• Design, develop, and maintain scalable ELT pipelines using dbt, loading raw data into Snowflake and producing clean, ready‑to‑use data models.
• Implement best‑practice data modelling techniques to optimise performance, accuracy, and usability for reporting and analytics.
• Write comprehensive data quality checks, tests, and monitoring scripts; document all data transformations and models.
• Collaborate closely with Data Analysts and business users to understand reporting needs and optimise data models.
• Collaborate with Data Engineers on ingestion strategies and platform optimisation.
• Tune and optimise SQL queries and data models to reduce latency and improve performance in the data warehouse.
• Champion modern data‑stack tools and practices, including Git and CI/CD.
• Build scalable, compelling visualisations in Looker for large teams.

Required Qualifications

• 3+ years experience in a data‑focused role (Analytics Engineer, Data Analyst, BI Developer).
• Expert‑level proficiency in writing and optimising complex SQL queries.
• Hands‑on experience with dbt or similar data transformation frameworks.
• Experience with cloud‑based data warehouses such as Snowflake, BigQuery, or Redshift.
• Solid understanding of data warehousing concepts, ETL/ELT principles, and dimensional modelling techniques.
• Proficiency with Git for collaborative development.
• Familiarity with reporting/BI tools like Looker.

Preferred Qualifications

• Python expertise for automation, integration, and orchestration.
• Experience with semantic layers.
• Experience with Airflow orchestration tools.
• Knowledge of modern software engineering practices applied to data (modularity, code review, testing).

Our VisionWe aim to serve as a platform for human connection in real‑life, encouraging in‑person collaboration three days a week. This role requires you to be based within commuting distance of our London or Barcelona hub, though we can support relocation from anywhere.

We are an equal opportunity employer. You are welcome at Perk regardless of how you look, where you’re from, or anything else that makes you, well, you.