At a Glance
- Tasks: Design and build a modern data platform on Google Cloud for accessible rail travel.
- Company: Innovative B2B SaaS company focused on making rail travel accessible for everyone.
- Benefits: Private healthcare, hybrid working, 25 days holiday, and volunteering leave.
- Other info: Dynamic culture valuing ownership, clarity, and impact with excellent career growth.
- Why this job: Join a mission-driven team and make a real impact on millions of journeys.
- Qualifications: 4+ years in Data Engineering, strong Python and SQL skills, GCP experience.
The predicted salary is between 60000 - 75000 £ per year.
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.
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.
Responsibilities
- 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
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) in Slough employer: Transreport
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 company pension scheme, and a culture that prioritises ownership and impact, employees are empowered to grow and make meaningful contributions. Located in London, the company not only supports professional development but also fosters a collaborative atmosphere where every voice is valued, making it an ideal place for passionate data engineers to thrive.
StudySmarter Expert Advice🤫
We think this is how you could land Mid-Senior Data Engineer (GCP, Python, BigQuery) in Slough
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people 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! Brush up on your technical skills, especially Python and SQL, and be ready to discuss your experience with GCP and BigQuery. Practice common interview questions and maybe even do some mock interviews with friends.
✨Tip Number 3
Showcase your projects! If you've built any cool data pipelines or worked on interesting data models, make sure to highlight them during interviews. Having tangible examples can really set you apart from other candidates.
✨Tip Number 4
Apply through our website! We love seeing applications come directly from passionate candidates. Plus, it gives you a better chance of getting noticed by our hiring team. Don’t hesitate, get your application in!
We think you need these skills to ace Mid-Senior Data Engineer (GCP, Python, BigQuery) in Slough
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 well as any relevant projects you've worked on. We want to see how you can contribute to our mission!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share your passion for data engineering and how it aligns with our vision of accessible rail travel. Let us know why you're excited about this role and what unique perspectives you bring to the table.
Showcase Your Projects:If you've worked on any cool data projects, don't be shy! Include links or descriptions of your work, especially if it involves ETL pipelines, BigQuery, or using Terraform. We love seeing practical examples of your skills in action.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows us you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at Transreport
✨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 during the interview process. Practice designing data architectures and integration solutions. You might be asked to solve problems on the spot, so being familiar with common scenarios in data engineering will give you an edge.
✨Showcase Your Problem-Solving Skills
Be ready to discuss how you've tackled challenges in previous roles, especially when it comes to migrating legacy systems or optimising data pipelines. Use specific examples to illustrate your thought process and the impact of your solutions.
✨Align with Company Values
Transreport values ownership, clarity, and impact. Be prepared to discuss how you embody these principles in your work. Share experiences where you took initiative, communicated effectively, and made a significant contribution to your team or project.
