At a Glance
- Tasks: Design and build a modern data platform on Google Cloud for accessible rail travel.
- Company: Join a Series A tech company making rail travel accessible for everyone.
- Benefits: Enjoy private healthcare, a pension scheme, hybrid work, and 25 days holiday.
- Other info: Work in a culture valuing ownership, clarity, and impact with excellent career growth.
- Why this job: Make a real impact by shaping data usage in the rail industry.
- Qualifications: 4+ years in Data Engineering, strong Python and SQL skills required.
The predicted salary is between 60000 - 75000 £ per year.
B2B SaaS | Hybrid – 2-3 days office | UK
Location: London
Type: Full-time
We’re building the next generation of our data platform for accessible rail travel — powering millions of journeys and enabling new Data-as-a-Service products. Accessible rail travel depends on systems that work reliably in live environments. Our platform processes large volumes of operational, auditing, and passenger data to generate real-time insights and external data products used by partners and operators.
You’ll play a key role in designing and building a modern, cloud-native data platform on Google Cloud: replacing legacy systems and shaping how data is used across the business and by external stakeholders.
Strategic Context
Transreport exists to remove structural barriers in rail travel. Our vision is that everyone has access to travel everywhere. As a Series A technology company and recipient of a King’s Award, we operate across the UK, Japan and the EU, delivering award-winning accessibility and safety platforms that have supported over 10 million assistance requests for more than 1 million users. As our operational demands grow, our systems must support increasing integrations, regulatory complexity, data volume, and reliability expectations.
Outcomes & Impact
Within 6 months, you will:
- Deliver and stabilize our new read-only Data APIs on GCP for external partners, ensuring they meet strict rate limits and utilize cursor-based pagination.
- Establish the foundational BigQuery Data Lake using Terraform, deploying automated ingestion pipelines for core platform data.
- Assist in the management of the legacy Ruby on Rails auditing applications, ensuring stability while utilizing AI coding assistants to accelerate the migration to the new stack.
Within 12 months, you will:
- Play a lead role in deploying a new unified Auditing application (FastAPI/Cloud Run), merging internal and external audits into a single cloud-native architecture.
- Replace manual Python Jupyter notebooks with fully automated, regulatory periodic reporting engines via Cloud Run and Workflows.
- Eliminate legacy database silos by migrating transactional and analytical data into unified Cloud SQL and BigQuery schemas.
Tasks
- Build & Evolve the Platform: Architect and build serverless Python (FastAPI) microservices on Google Cloud Run to replace legacy monoliths.
- Data Pipelines & ETL: Build and maintain robust ETL/ELT pipelines streaming data from Cloud SQL and external third-party APIs into BigQuery.
- Data Modelling: Write clean, performant SQL to transform raw data in BigQuery into curated, analysis-ready datasets (utilizing tools like Dataform or dbt).
- Data API Ownership: Manage secure, high-throughput external APIs utilizing OAuth 2.0 (M2M) and API Gateway.
- Infrastructure as Code: Utilize Terraform to deploy, secure, and monitor GCP environments.
Requirements
Must Haves
- 4+ years of professional experience in Data Engineering or Backend Software Engineering.
- Strong proficiency in Python and SQL.
- Hands-on experience with Google Cloud Platform (GCP), specifically BigQuery, Cloud Run, and Cloud SQL.
- Experience building and maintaining ETL/ELT pipelines and transforming data via modelling tools (Dataform, dbt, etc.).
- Experience with Infrastructure as Code (Terraform) and CI/CD pipelines.
- High proficiency in using AI coding assistants to accelerate development and infrastructure tasks.
Nice to Haves
- Familiarity with FastAPI and asynchronous workers (Cloud Tasks/PubSub).
- Experience with modern BI tools, specifically Looker (LookML) and/or Looker Studio.
- Experience working in regulated industries or multi-client B2B SaaS.
- Comfortable working within legacy codebases (Ruby on Rails) while migrating them to modern architectures.
- Experience designing and scaling REST APIs.
Benefits
- Private healthcare after your probation (including children).
- Company pension scheme.
- Hybrid working model.
- 25 days holiday.
- Volunteering Leave.
- Free flu jab for you and your family.
Culture & Operating Principles
We value: Ownership over hierarchy, Clarity over bureaucracy, Impact over job titles. We operate with high autonomy and high accountability. People are expected to raise risks early, communicate clearly, and take responsibility for outcomes.
Interview Roadmap
- Screening Call (30 mins) – Recruiter alignment.
- Technical Exercise – Architecture & integration discussion.
- Deep Dive Interview – Engineering & Product.
- Final Culture Conversation – Leadership alignment.
Guaranteed Interview Scheme
We’re a Disability Confident employer and we welcome applications from disabled candidates. If you need any adjustments at any stage of the recruitment process, please tell us what would help - we’ll work with you to make the process as accessible as possible. We also offer a Guaranteed Interview Scheme (GIS) for candidates who consider themselves to have a disability as defined under the Equality Act 2010. If you indicate this option in your application and your application demonstrates that you meet the essential criteria for the role, you’ll be invited to interview or assessment. Choosing GIS doesn’t guarantee a job offer. If you have any questions, please get in touch.
Mid-Senior Data Engineer (GCP, Python, BigQuery) employer: Transreport Limited
Transreport is an exceptional employer, offering a dynamic work environment that champions innovation and accessibility in rail travel. With a hybrid working model, generous benefits including private healthcare and a strong focus on employee growth, we empower our team to take ownership and make impactful contributions. Join us in shaping the future of accessible travel while enjoying a culture that values clarity, autonomy, and accountability.
StudySmarter Expert Advice🤫
We think this is how you could land Mid-Senior Data Engineer (GCP, Python, BigQuery)
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for those interviews! Research the company, understand their products, and be ready to discuss how your skills in Python, GCP, and data engineering can help them achieve their goals. Practice common technical questions and scenarios related to data platforms.
✨Tip Number 3
Showcase your projects! Whether it's a GitHub repo or a personal website, having a portfolio of your work can really set you apart. Highlight any relevant experience with ETL pipelines, BigQuery, or Terraform to demonstrate your hands-on skills.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our mission to make rail travel accessible for everyone.
We think you need these skills to ace Mid-Senior Data Engineer (GCP, Python, BigQuery)
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match our job description. Highlight your proficiency in Python, SQL, and GCP, as these are key for the Mid-Senior Data Engineer role.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about accessible rail travel and how your background aligns with our mission. Show us your personality and enthusiasm for the role!
Showcase Your Projects:If you've worked on relevant projects, especially involving ETL pipelines or cloud-native architectures, make sure to mention them. We love seeing real-world applications of your skills!
Apply Through Our Website:For the best chance of getting noticed, apply directly through our website. It helps us keep track of your application and ensures you’re considered for the role!
How to prepare for a job interview at Transreport Limited
✨Know Your Tech Stack
Make sure you’re well-versed in GCP, Python, and BigQuery. Brush up on your knowledge of serverless architectures and ETL/ELT pipelines. Being able to discuss your hands-on experience with these technologies will show that you’re ready to hit the ground running.
✨Prepare for Technical Exercises
Expect a technical exercise focused on architecture and integration. Practice designing data pipelines and APIs, and be ready to explain your thought process. Use real-world examples from your past work to demonstrate your problem-solving skills.
✨Showcase Your Data Modelling Skills
Be prepared to discuss how you’ve transformed raw data into analysis-ready datasets. Familiarise yourself with tools like Dataform or dbt, and be ready to share specific examples of how you’ve used them to improve data quality and accessibility.
✨Emphasise Cultural Fit
This company values ownership, clarity, and impact. Be ready to discuss how you’ve taken responsibility for outcomes in your previous roles. Share examples of how you’ve communicated effectively and raised risks early to ensure project success.
