Backend Engineer - Databases and APIs

ABOUT THE ROLE

We are looking for a a Backend Engineer to leading our API and database development. In this role, you will own the data layer that powers our platform. This role sits at the intersection of data architecture and backend engineering. You will define how data flows from external sources into our systems, how it is stored, transformed, and optimised, and how it is ultimately served through performant, reliable APIs.

You will build the foundations that enable scalable data ingestion, consistent modelling, and fast access across diverse data types.

This is a full‑time role based in London on a hybrid working pattern (2–3 days per week in the office).

ABOUT THE ROLE:

You will work closely with product, data, and engineering teams to build resilient pipelines, coherent data models, and scalable backend services that support a wide variety of use cases across the organisation. Your work will directly influence platform performance, data integrity, and our ability to make informed, data‑driven decisions.

Key responsibilities are to:

• Design and implement database schemas optimised for time‑series, geospatial, multimedia, and relational data.

• Build robust data‑integration pipelines that ingest from multiple third‑party APIs, handling inconsistencies, failures, and schema changes.

• Develop and optimise API endpoints using Python and FastAPI to serve data efficiently and reliably at scale.

• Implement caching strategies, materialised views, and denormalisation patterns to maintain responsive query performance.

• Design coherent data models that reconcile disparate data sources into a unified internal schema.

• Manage core database operations including migrations, indexing strategies, query optimisation, and performance monitoring.

• Build resilient ETL processes with strong error handling, retry logic, and validation mechanisms.

• Deploy and maintain data infrastructure on AWS, including RDS, Redis, S3, and Mongo
  
  DB where required.

ABOUT YOU

What you bring (knowledge, expertise,experience, and skills):

Essential:

• 3–5 years’ experience in backend development with a strong focus on databases.

• Deep expertise in Postgre
  
  SQL, including schema design, indexing, query optimisation, and stored procedures.

• Strong proficiency in Python, with hands‑on experience using FastAPI or similar frameworks.

• Experience designing data models for complex, multi‑source systems.

• Hands‑on experience building large‑scale integrations with third‑party APIs.

• Solid understanding of data consistency, transactions, and failure‑handling patterns.

• Experience with AWS data services (RDS, S3, Mongo
  
  DB, Redis).

• Strong SQL skills and the ability to write efficient queries on large datasets.

• Familiarity with AI‑assisted development tools (e.g., Claude Code, Git Hub Copilot).

Desirable:

• Experience with specialist database extensions such as PostGIS (geospatial), Timescale
  
  DB (time‑series), or pgvector (embeddings).

• Background with No
  
  SQL databases (e.g., Dynamo
  
  DB, Mongo
  
  DB) and an understanding of when to apply them.

• Experience with data warehousing concepts and analytical query patterns.

• Familiarity with message queues and event‑driven architectures for data pipelines.

• Experience with database replication, partitioning, and high‑availability configurations.

WHAT YOU GET

A competitive salary and benefits package that includes 27 days holiday per year, pension contributions, private healthcare, discounted dental insurance, enhanced maternity/parental leave, plus a whole host of others including:

• Cultural stimulation allowance - £250 per person per year

• Half days off before bank holidays

• Emergency care days for dependants

• Up to 5 days volunteering leave per year to work for a registered charity

• Up to 10 days special emergency leave per year

• Season Ticket loan

• Payroll Giving Scheme

• Thursday drinks to unwind and socialize

• An annual Summer and Christmas party

• Our commitment to Diversity and Inclusion sees us offer inclusive bank holidays

We also offer learning opportunities around D&I, targeted mentoring programmes and the opportunity to participate in several active Employee Led Networks and associated events. Finally, this role will be supported with all the necessary personal…