Junior Software Engineer at Blenheim Chalcot in London
- Company: Blenheim Chalcot
- Location: London
- Posted: Sep 17, 2026
- Type: Full-time
- Experience: 2+ years
Overview
Fospha's measurement products run on data pipelines that process marketing spend and performance data for brands you'll recognise. You'll get exposure across our core data engineering workstreams: large-scale SQL/dbt transformation pipelines, data ingestion services, and pipelines that turn aggregat…
Job description
- Fospha's measurement products run on data pipelines that process marketing spend and performance data for brands you'll recognise. You'll get exposure across our core data engineering workstreams: large-scale SQL/dbt transformation pipelines, data ingestion services, and pipelines that turn aggregated data into insights served through APIs. You'll work alongside data engineers, analysts, and AI agents as part of our AI-first operating model, with senior engineers supporting you as you build real ownership.
- This role suits a recent graduate (or someone with a strong personal/academic project record) who's curious about data pipelines and wants to learn by shipping real, production code from day one.
Responsibilities
- Write and maintain dbt models and SQL as part of our production data engineering pipelines, learning the transformation patterns we build on
- Help build and maintain Python-based data ingestion services, with guidance from senior engineers
- Contribute to pipelines that move data from ingestion through transformation to the APIs that serve it
- Write clean, tested code and get comfortable with code review from both sides — giving and receiving feedback
- Debug data quality issues systematically, learning to trace problems back through the pipeline
- Get exposure to our cloud infrastructure and understand how it supports the pipelines you work on
- Work with AI agents as part of our AI-first operating model, learning to write clear specifications that shape high-quality, AI-assisted engineering work
- Collaborate with data engineers, analysts, and product stakeholders to understand what the data needs to support
Requirements
- Essential
- A relevant degree (Computer Science, Data Engineering, Mathematics, or similar), or equivalent experience through internships/placements/personal projects
- Some experience with SQL and Python
- Genuine curiosity about how data pipelines work end-to-end, not just the code but why the data looks the way it does
- Comfortable being reviewed and iterating quickly on feedback
- Confident asking questions and pushing for clarity rather than staying blocked
- Exposure to dbt or another SQL transformation framework
- Familiarity with Git/GitHub and PR-based workflows
- Some exposure to AWS or another cloud environment
- Experience writing or maintaining automated tests
- Interest in AI-assisted coding tools (we use Claude Code day-to-day)
- Any exposure to marketing, ecommerce, or advertising data
Skills
Required
- SQL
- Python
Preferred
- Git/GitHub and PR-based workflows
- AWS or another cloud environment
- Automated tests
Benefits
- Salary: Competitive + bonus
- A £1,000/year flexible benefits allowance to put towards private medical insurance, dental cover, a health cash plan, gym membership, extra holiday, or a pension top-up — whatever suits you
- Access to Wellhub, giving you one membership across gyms, boutique studios, and wellbeing apps
- 25 days' annual leave plus 8 UK bank holidays, an extra day off for your birthday, and more holiday the longer you stay (26 days after 3 years, 27 after 6)
- Regular socials, free weekly snacks, and Lunch & Learn events at our Scale Space office, plus access to the wider Blenheim Chalcot community
- Opportunities to travel — including to our India and North America offices
- Life assurance worth 4x your annual salary
About Blenheim Chalcot
Fospha is the measurement system enterprise retail and ecommerce brands run their business on. We give marketing teams one clear, daily view of what's actually working — across every channel and everywhere they sell, from their website to Amazon and TikTok Shop — down to the level of a single ad or piece of creative. It replaces guesswork and gut feel with a number marketing, finance and agencies can all trust and act on. Brands including Dyson, Gymshark, Adanola and Huel use Fospha up to 25 times a day to decide where budget should move next. We've spent over a decade building this, with more than $40 billion in marketing spend now optimised through the platform — and we're scaling fast across London, Mumbai and Austin.