Junior Software Engineer

London. Posted a month ago

The role

You will write and maintain dbt models, SQL, and Python-based data ingestion services. You will work on production data engineering pipelines and collaborate with data engineers, analysts, and AI agents.

What you will do

Write and maintain dbt models and SQL as part of production data engineering pipelines
Help build and maintain Python-based data ingestion services
Contribute to pipelines that move data from ingestion through transformation to APIs
Write clean, tested code
Give and receive code review feedback
Debug data quality issues systematically
Get exposure to cloud infrastructure
Work with AI agents to write specifications for AI-assisted engineering work
Collaborate with data engineers, analysts, and product stakeholders

Required qualifications

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
Comfortable being reviewed and iterating quickly on feedback
Confident asking questions and pushing for clarity

Nice to have

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
Any exposure to marketing, ecommerce, or advertising data

Benefits

Competitive salary + bonus
£1,000/year flexible benefits allowance for private medical, dental, health cash plan, gym, extra holiday, or pension top-up
Access to Wellhub membership
25 days' annual leave plus 8 UK bank holidays
An extra day off for your birthday
Increased holiday entitlement over time
Regular socials
Free weekly snacks
Lunch & Learn events
Access to the wider Blenheim Chalcot community
Opportunities to travel to India and North America offices
Life assurance worth 4x your annual salary

About the company

Fospha is a measurement system for enterprise retail and ecommerce brands. It provides marketing teams with a view of performance across channels like websites, Amazon, and TikTok Shop.