Analytics Engineer

Guaranteed Tenants Ltd; City of London; Hybrid; GBP 34,000 - 40,000; Full time

Job summary

A rapidly growing media agency in London is seeking an Analytics Engineer to enhance data capabilities. This hybrid role focuses on building robust data models, ensuring data quality, and collaborating with various stakeholders to achieve business objectives. The ideal candidate will possess strong SQL, DBT, and Python skills, along with a passion for data and a team-oriented mindset. Opportunities for training and development are emphasized in this supportive environment.

Benefits

Training and development opportunities

Referral schemes with rewards

Qualifications

• Confident in writing clean, performant SQL queries.
• Experienced with building, testing DBT models in production.
• Familiar with using Python and editing scripts.

Responsibilities

• Build and maintain data models in DBT.
• Manage onboarding of new data feeds.
• Champion data quality with tests and alerts.
• Work closely with senior leaders in data and marketing.
• Contribute to Python tooling.
• Collaborate to ensure meaningful data.
• Take ownership of projects from design to deployment.

Skills

SQL

DBT

Python

Git

Strong communicator

Team player

Tools

GCP/BigQuery

Airflow

Data visualisation platforms

GitLab CI

Job description

Join to apply for the Analytics Engineer role at Guaranteed Tenants Ltd.

Location: London – Hybrid (3 days/week central London office).

Salary: £40,000 (depending on experience).

Ref: J13038.

Please note sponsorship is not available now or in the future.

Overview

An exciting opportunity has opened up at one of the UK's fastest-growing independent media agencies. An Analytics Engineer is needed to help shape the future of data in a business where performance, innovation, and impact come together.

Responsibilities

• Build and maintain robust data models in DBT, transforming raw data into high-quality, trusted sources for analytics and activation.
• Manage onboarding of new data feeds from discovery to documentation, collaborating with both technical and business stakeholders.
• Champion data quality, creating tests and alerts to ensure confidence and consistency in our outputs.
• Work closely with senior leaders across data and marketing to align models with business objectives.
• Contribute to and evolve our Python tooling, adapting scripts and automations to support the wider data platform.
• Collaborate with teams across analytics, data science, and visualisation to make sure data is accessible, meaningful, and impactful.
• Take ownership of projects from design through to deployment, following agile best practices.

Must-Have Skills

• SQL – confident in writing clean, performant queries; understands ANSI SQL principles.
• DBT – experienced with building, testing, and documenting models in production environments.
• Python – comfortable using and editing existing scripts; familiar with core concepts.
• Git – solid understanding of version control and team-based workflows.
• Strong communicator – able to translate technical topics for non-technical audiences.
• Team player – collaborative, curious, and happy to work in a self‑organising, fast‑paced environment.

Nice-to-Have Skills

• Experience with GCP/BigQuery or other cloud data warehouses (e.g., Snowflake, Redshift).
• Familiarity with data orchestration tools (e.g., Airflow).
• Experience with data visualisation platforms (such as Preset.io/Apache Superset or other).
• Exposure to CI/CD pipelines, ideally using GitLab CI.
• Background working with media, marketing or advertising data.

The Opportunity

Work alongside smart, supportive teammates who genuinely care about data, performance, and growth. Play a key role in a business that’s investing in its data capabilities for the long term. Huge emphasis on training and development. Contribute to an evolving data platform and a top 1% DBT codebase that sets standards others aspire to. Be part of a company with a strong Data for Good ethos, where your work helps drive real‑world results with purpose.

If you're ready to develop up your analytics career, working with top-tier tools and a brilliant team, we want to hear from you.

Alternatively, you can refer a friend or colleague by taking part in our fantastic referral schemes! For each relevant candidate that you introduce to us (there is no limit) and we place, you will be entitled to our general gift/voucher scheme.

Referrals increase your chances of interviewing at Guaranteed Tenants Ltd by 2x.