Data Engineer

Ecruit; City Of London; Hybrid; GBP 50,000 - 60,000; Full time

Job summary

A data-focused advertising company in London is seeking a Data Engineer for a hybrid role. You will build and maintain data pipelines, manage infrastructure in a cloud environment, and create dashboards that provide actionable insights. The ideal candidate has experience with Python, SQL, and cloud platforms, preferably Google Cloud. This role offers flexibility, growth opportunities, and a healthy work-life balance.

Benefits

25 days holiday

Private healthcare

Flexible remote options

Career growth opportunities

Direct access to senior leadership

Qualifications

• Experience building ETL pipelines, preferably with Python.
• Strong SQL skills. Experience with PostgreSQL and BigQuery preferred.
• Experience with cloud platforms, ideally Google Cloud.
• Hands-on experience with Infrastructure-as-Code like Terraform.
• Solid Linux/Unix skills, especially for server and network config.
• Ability to communicate with both technical and non-technical people.
• Ability to work independently with minimal supervision.

Responsibilities

• Build and maintain data pipelines that are fast, reliable, and ready for analysis.
• Manage local server and cloud infrastructure using DevOps practices, in a hybrid cloud environment.
• Run quality checks and validation on release datasets.
• Automate routine checks, loading, and reporting.
• Create dashboards that turn complex data into clear, actionable insights.
• Support the insight team with data analysis and handle queries from industry stakeholders.

Skills

Building ETL pipelines

Strong SQL skills

Experience with PostgreSQL

Experience with BigQuery

Cloud platforms, ideally Google Cloud

Hands-on with Infrastructure-as-Code

Solid Linux/Unix skills

Ability to communicate with technical and non-technical people

Work independently

Job description

Data Engineer | Hybrid Role | £50k-£60k | London

Route delivers world-class audience measurement for out-of-home advertising across Great Britain. We're building new data models and collection methods to better understand how people move and which OOH ads they see. You'll build the data pipelines and infrastructure that makes this happen.

Note: Applicants must be eligible to work in the UK, as visa sponsorship is not available.

Why this role?

From day one, you'll have the freedom to innovate and make decisions that directly affect the business. This isn't a traditional data engineering role; you'll wear multiple hats. You'll design and maintain local and cloud (GCP) data pipelines that power our analytics and dashboards and automate key processes. This includes managing our local infrastructure, including Proxmox virtualisation hosts and network configuration, ensuring seamless integration between on‑premises and cloud systems. Working closely with the team, you'll get hands‑on experience with everything from data engineering to infrastructure management.

What's in it for you?

• Immediate Impact: Your work directly supports how audience data is used to measure advertising effectiveness across GB. You'll see results quickly, whether it's improving data quality, automating tasks, or building tools that surface insights.
• Career Growth: You'll work with Python, Go, SQL, PostgreSQL, BigQuery, Google Cloud, and DevOps practices. With dedicated study days and a supportive team, you'll accelerate your learning and development.
• Visibility: In a small team, your ideas matter. You'll have direct access to senior leadership and influence how data is used across the business.
• Flexibility: Hybrid working (2-3 days in office) with flexible remote options.
• Work-Life Balance: With 25 days holiday, private healthcare, and a social, relaxed working environment.

What you'll do:

• Build and maintain data pipelines that are fast, reliable, and ready for analysis.
• Manage local server and cloud infrastructure using DevOps practices, in a hybrid cloud environment.
• Run quality checks and validation on release datasets. Automate routine checks, loading, and reporting.
• Create dashboards that turn complex data into clear, actionable insights for internal teams and external stakeholders.
• Support the insight team with data analysis and handle queries from industry stakeholders.

What we're looking for:

• Experience building ETL pipelines, preferably with Python.
• Strong SQL skills. Experience with PostgreSQL and BigQuery preferred.
• Experience with cloud platforms, ideally Google Cloud.
• Hands‑on experience with Infrastructure-as-Code like Terraform.
• Solid Linux/Unix skills, especially for server and network config.
• Ability to communicate with both technical and non-technical people.
• Ability to work independently with minimal supervision.