Arriva is a leading European passenger transport partner, operating in 11 countries across the UK and Europe. The company employs around 35,000 people, delivering more than 1.5 billion passenger journeys connecting people and communities safely, reliably and sustainably. We have strong roots dating back to 1938, an ambitious growth and sustainability agenda, and a continuously developing relationship with I Squared Capital – a global infrastructure investment fund manager - who acquired Arriva in 2024.
We are looking for a BI Engineer to join our BI Product Team on a full-time, permanent basis. We offer hybrid working. This role will be based from either our Sunderland or London office a minimum of 3 days per week, the rest focusing on where you can best deliver for your customers, whilst still allowing for the required work life balance.
TheBI Engineerrolesupportthedeliveryofhigh-qualitydashboards,reports,andself-service analyticsthatenabledata-drivendecisionmakingacrosstheorganisation.ReportingtotheLead BI Engineer,theBI Engineerbuildsreliableandefficient datapipelines,modelsand infrastructurethatpowerfront-enddashboardsandself-serveanalytics.Partneringcloselywith the BI Developersthisrolewilltranslatebusinessneedsintorobustbackenddata products, ensuringdataaccuracy,performance,standardsadherenceandgreatuserexperiencesthrough well-designeddatasets.Thisroleblendstechnicalskillswithstakeholdermanagement,business understandingand effectivecommunicationtoeffectivelytranslatebusinessproblemsinto actionable outputs. Due tothe nature ofthe evolvingdataspace, continuouslearningiscritical toensure our technology isup todate with the latest toolingand capabilities
Data Engineering Development & Delivery
• Design, develop and maintain secure, scalable ETL / ELT workflows to ingest, transform and prepare data that enables reliable BI reporting and self-serve analytics.
• Implement data transformation logic using SQL and Python to convert raw data into reporting datasets.
• Build curated, business-ready datasets optimised for front-end use cases supporting efficient querying and accurate reporting.
• Optimise query, dataset and pipeline performance (indexing, partitioning, compression) through refactoring and new technology introduction ensuring cost efficiency.
• Collaborate with BI Developers to understand frontend requirements and ensure backend data structure supports visualisation requirements.
• Support the automation of data processes to reduce manual effort.
• Implement data quality checks, validation rules, and monitoring to assure accuracy, completeness, lineage, and timeliness.
• Monitor data pipeline performance and proactively identify and resolve issues.
• Document data lineage, transformation logic, and quality controls for transparency and maintainability.
• Continuously explore new BI design principles and tools with Lead BI Engineer to push the boundaries of data architecture, including open-table formats and data observability.
• Ensure BI products comply with governance and security principles.
Stakeholder Engagement & Enablement
• Engage with business stakeholders to clarify requirements and understand underlying business needs, translating them into backend technical solutions.
• Partner with BI developers to ensure seamless integration between backend data models and frontend visualisations.
• Support and train business users to enable effective self-service analytics and increase BI adoption, guiding colleagues on effective data lake and database queries.
• Educate BI Developers and Non-Technical stakeholders on technical concepts to build understanding and trust.
• Provide ongoing support for BI products (including enhancements) within agreed priorities.
• Act as an embedded BI partner within business units, educating colleagues on best practices and solutions to business problems.
Team Contribution & Development
• Collaborate with Platforms & Operations on solution architecture, integration, performance, scalability, and cost; help select appropriate tools and approaches.
• Follow and contribute to BI development standards and best practices for data engineering.
• Support incident investigation and remediation. Contribute to runbooks and operational documentation.
• Participate in peer reviews, knowledge sharing, and team learning initiatives.
• Develop understanding of BI solutions end-to-end, from data source to dashboard, to enhance context and decision-making.
The closing date for applications is Wednesday 18th February 2026. Arriva Group reserves the right to close this vacancy early.