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: 25 days holiday, company pension scheme, and free flu jab for you and your family.
- Other info: Dynamic hybrid work environment with a focus on accessibility and inclusivity.
- Why this job: Join us to shape the future of rail travel and make a real impact.
- 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
- 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.
- 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.
Company benefits include a pension scheme, 25 days holiday, and a free flu jab for you and your family.
We value clarity over bureaucracy.
Legal and Accessibility Statements
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
Transreport is an exceptional employer, dedicated to fostering a culture of inclusivity and innovation in the heart of London. With a strong commitment to employee growth, we offer opportunities to work on cutting-edge technology that enhances accessibility in rail travel, alongside a generous benefits package including a company pension scheme and 25 days holiday. Our hybrid work model promotes a healthy work-life balance, making Transreport an ideal place for talented individuals looking to make a meaningful impact in their careers.
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 folks 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 put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects, especially those involving GCP, Python, and BigQuery. This gives you a chance to demonstrate your expertise and makes you stand out during interviews.
✨Tip Number 3
Prepare for technical interviews by brushing up on your coding skills and understanding data engineering concepts. Practice common interview questions and consider mock interviews to build confidence.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. 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 is tailored to the role of Mid-Senior Data Engineer. Highlight your experience with GCP, Python, and BigQuery, and don’t forget to mention any relevant projects that showcase your skills in building data platforms.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about accessible rail travel and how your background aligns with our mission at StudySmarter. Keep it concise but impactful!
Showcase Your Technical Skills:In your application, be sure to highlight your technical expertise, especially in ETL/ELT pipelines and Infrastructure as Code. Mention specific tools you've used, like Terraform or FastAPI, to demonstrate your hands-on experience.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it’s super easy!
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 processes, as these will be crucial for the role. Be ready to discuss specific projects where you've used these technologies.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled challenges in data engineering or backend development. Think about times when you had to migrate legacy systems or optimise data pipelines. This will demonstrate your ability to adapt and innovate.
✨Understand the Company’s Mission
Familiarise yourself with Transreport's vision of accessible rail travel. Be prepared to discuss how your skills can contribute to their goals, especially in building a reliable data platform that supports millions of journeys.
✨Ask Insightful Questions
Prepare thoughtful questions about the team dynamics, the tech stack, and future projects. This shows your genuine interest in the role and helps you assess if the company culture aligns with your values.
