BI Engineer

Arriva Group; Sunderland, Greater London; Hybrid; GBP 40,000 - GBP 60,000; Full time

Job summary

A leading transport provider in the UK is looking for a BI Engineer to join their BI Product Team on a full-time, permanent basis. The role offers hybrid working, based in Sunderland or London. The BI Engineer will focus on delivering high-quality dashboards and reports, developing robust data pipelines, and engaging with stakeholders for effective analytics. Candidates should have expertise in SQL and Python, along with strong collaboration skills to optimize backend data solutions. Applications close on February 18, 2026.

Qualifications

• Experience with designing and maintaining ETL processes.
• Strong understanding of SQL and Python programming.
• Ability to collaborate with both technical and non-technical stakeholders.

Responsibilities

• Design and improve ETL workflows for reliable reporting.
• Transform raw data into usable datasets for business insights.
• Monitor and optimize data pipeline performance.

Skills

SQL

Python

Data Visualization

ETL Processes

Stakeholder Management

Education

Degree in Computer Science or related field

Tools

BI Tools

Data Lake Technologies

Job description

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.

The BI Engineer role supports the delivery of high-quality dashboards, reports, and self-service analytics that enable data-driven decision making across the organisation. Reporting to the Lead BI Engineer, the BI Engineer builds reliable and efficient data pipelines, models and infrastructure that power front-end dashboards and self-serve analytics. Partnering closely with the BI Developers this role will translate business needs into robust backend data products, ensuring data accuracy, performance, standards adherence and great user experiences through well-designed datasets. This role blends technical skills with stakeholder management, business understanding and effective communication to effectively translate business problems into actionable outputs. Due to the nature of the evolving data space, continuous learning is critical to ensure our technology is up to date with the latest tooling and 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.