Data Engineer

You will design, build, and maintain a scalable Enterprise Data Warehouse using Amazon Redshift alongside a Data Lake architecture (S3), developing robust ELT/ETL pipelines to ingest and transform data from multiple sources. You'll ensure data quality, consistency, and performance across all layers, while optimising cost and scalability within AWS.

Alongside core data engineering responsibilities, you will play a key role in reporting and analytics, developing and maintaining Power BI datasets, dashboards, and semantic models. You'll enable self-service BI while ensuring governance, performance, and consistency of metrics across the organisation.

You will also automate data pipelines and reporting workflows, leveraging AWS services such as Glue, Lambda, and orchestration tools, while implementing monitoring, logging, and CI/CD practices. Working closely with stakeholders, you'll translate business requirements into scalable data solutions and provide ongoing analytical support., You'll be joining a business where data is a key strategic priority, with the opportunity to shape and develop a modern analytics platform from the ground up. This role offers a strong blend of data engineering and analytics, giving you real ownership and visibility, alongside the flexibility of remote working and the chance to work with modern AWS data technologies.

• Strong experience as a Data Engineer with exposure to BI/reporting
• Hands-on experience with Amazon Redshift and Data Lake architectures (S3)
• Advanced SQL skills for data transformation and optimisation
• Proven experience with Power BI (data modelling, DAX, reporting)
• Strong understanding of dimensional data modelling (fact/dimension design)
• Experience building and optimising ETL/ELT pipelines
• Knowledge of AWS analytics ecosystem (Redshift, S3, Glue, IAM, CloudWatch)
• Understanding of data governance, security, and access control
• Strong stakeholder engagement and ability to translate data into insights