Backend Engineer - Databases and APIs
Role details
Job location
Tech stack
Job description
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., * 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 MongoDB where required.
Requirements
- 3-5 years' experience in backend development with a strong focus on databases.
- Deep expertise in PostgreSQL, 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, MongoDB, Redis).
- Strong SQL skills and the ability to write efficient queries on large datasets.
- Familiarity with AI-assisted development tools (e.g., Claude Code, GitHub Copilot).
Desirable:
- Experience with specialist database extensions such as PostGIS (geospatial), TimescaleDB (time-series), or pgvector (embeddings).
- Background with NoSQL databases (e.g., DynamoDB, MongoDB) 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.
Benefits & conditions
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 development required to set someone up for success.