BI Backend Data Engineer — Hybrid, Scalable Pipelines

Tria; City Of London; Hybrid; GBP 50,000 - 60,000; Full time

Job summary

Tria is seeking a Data Engineer (BI Back-End) to join our high-performing BI team in London. You will design and optimise ETL/ELT pipelines, build backend data models and ensure data quality to support reporting and analytics across the business.

Working in a hybrid model (3 days on-site, 2 days remote), you’ll collaborate with BI developers and stakeholders, leveraging cloud data platforms and modern tooling to deliver scalable, reliable data solutions.

Qualifications

• Strong SQL skills with experience building and optimising data models.
• Experience designing and maintaining ETL/ELT pipelines.
• Exposure to data warehousing, data lakes and modern data architecture.
• Experience with cloud data platforms (AWS preferred - Redshift, Athena, S3, Glue. Azure accepted).
• Understanding of workflow orchestration and automation tools.
• Python experience (including PySpark) is beneficial but not essential.
• Exposure to BI platforms such as Power BI, Tableau or QuickSight, with an understanding of how backend data models support reporting and visualisation.
• Strong communication skills and the ability to work effectively with both technical and non-technical stakeholders.
• A genuine interest in modern data engineering practices and emerging technologies.

Responsibilities

• Design, build and maintain scalable ETL/ELT pipelines that deliver reliable, high-quality data
• Develop curated, business-ready datasets that support reporting, dashboards and self-service analytics
• Optimise data models, SQL queries and pipeline performance to improve efficiency and scalability
• Implement data quality, monitoring and governance controls to ensure trusted, accurate data
• Collaborate with BI Developers to build backend data models that support performant visualisations
• Work with business stakeholders to understand requirements and translate them into robust technical solutions
• Contribute to the continuous improvement of the data platform, exploring modern tooling and engineering best practices

Skills

SQL

ETL/ELT pipelines

Data modelling

Cloud platforms

Python (PySpark)

BI tooling

Data warehousing

Workflow orchestration

Communication

Modern data practices

Job description

Tria is seeking a Data Engineer (BI Back-End) to join our high-performing BI team in London. You will design and optimise ETL/ELT pipelines, build backend data models and ensure data quality to support reporting and analytics across the business.

Working in a hybrid model (3 days on-site, 2 days remote), you’ll collaborate with BI developers and stakeholders, leveraging cloud data platforms and modern tooling to deliver scalable, reliable data solutions.