Data Engineer (BI Back-End)

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

Data Engineer (BI Back-End)

We're looking for a Data Engineer (BI Back-End) to join our client's high-performing Business Intelligence team, helping to build scalable, high-quality data solutions that power reporting, dashboards and self-service analytics across the business.

Salary: 50,000- 60,000 per annum + benefits

Hybrid: 3 days onsite, 2 days remote working

Type: Full time 5 days a week

Working closely with BI Developers and business stakeholders, you'll design and optimise ETL/ELT pipelines, develop curated data models, and translate business requirements into reliable backend data solutions. This is a fantastic opportunity for someone who enjoys solving complex data challenges and wants to work with modern cloud technologies in a collaborative, forward-thinking environment.

What you'll be doing

• 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

What we're looking for

• 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

The Team

You'll be joining a highly collaborative and engaging team within a business that genuinely invests in its people. Alongside working on modern data technologies, you'll have the opportunity to influence the evolution of the data platform, work closely with experienced BI professionals, and continue developing both your technical and professional skills in a supportive environment.

Please note: This is a backend-focused Data Engineer (BI Back-End) role centred around SQL, data modelling and ETL/ELT development. While you'll work closely with BI Developers, this is not a dashboard or reporting development position.