Data Engineer (BI Back-End)
Summary
Builds and maintains scalable ETL/ELT pipelines and curated, business-ready datasets for a BI team, optimizing SQL, data models and cloud data platforms (AWS Redshift/Athena/Glue or Azure) to power dashboards, reporting and self-service analytics.
As a Data Engineer (BI Back-End), you will build scalable data pipelines and curated datasets to empower reporting and self-service analytics. You’ll work inside a collaborative BI team to translate business needs into robust, backend data solutions. You’ll optimize performance, enforce data quality, and help evolve the data platform with modern tooling. This role offers hands-on work with cloud data platforms and the chance to shape how the business uses data to drive decisions. A strong focus on data modeling and ETL/ELT will help you impact dashboards and analytics across the organization.
Responsibilities- Design, build and maintain scalable ETL/ELT pipelines delivering high-quality data
- Develop curated, business-ready datasets supporting reporting and self-service analytics
- Optimize data models, SQL queries and pipelines for efficiency and scalability
- Implement data quality, monitoring and governance controls for trusted data
- Collaborate with BI Developers to build backend data models supporting visualisations
- Translate business requirements into robust technical solutions with stakeholders
- Contribute to continuous improvement of the data platform and explore modern tooling
- Strong SQL skills with data model experience
- Experience designing and maintaining ETL/ELT pipelines
- Exposure to data warehousing, data lakes, and modern data architecture
- Experience with cloud data platforms (AWS Redshift, Athena, S3, Glue; Azure accepted)
- Understanding of workflow orchestration and automation tools
- Python experience (PySpark) is beneficial but not essential
- Exposure to BI platforms (Power BI, Tableau, QuickSight) and backend data models for reporting
- Strong communication with technical and non-technical stakeholders
- Collaborative and cross-functional mindset
- Interest in modern data engineering practices and emerging technologies
- SQL
- ETL/ELT design and maintenance
- Data warehousing and data lake concepts