Senior Data Engineer

Job Description Job Title: Senior Data Engineer Location: London (Hybrid – minimum 2 days per week in the office) Day Rate: Market rate (Inside IR35) Contract Duration: 6 months Role Overview We are seeking an experienced Senior Data Engineer to design, develop and maintain scalable data pipelines that ensure high-quality, reliable data is available for business decision-making. You will work closely with data architects, product teams, analysts and data scientists to deliver robust data solutions that power analytics, reporting and advanced data products across our retail organisation. This role requires strong hands-on experience in modern cloud data platforms including Snowflake, DBT and AWS/Azure, alongside expertise in data modelling, ETL/ELT processes and pipeline orchestration. You will also act as a technical mentor within a collaborative and innovative data engineering team. Key Responsibilities • Design, develop, optimise and maintain scalable ETL/ELT data pipelines using modern cloud technologies. • Monitor, troubleshoot and enhance production data pipelines to ensure performance, reliability and data integrity. • Write and optimise complex SQL queries to support high-performance analytics workloads. • Implement flexible Data Vault models in Snowflake to support enterprise-scale analytics and business intelligence. • Build and maintain scalable cloud-based data solutions using Snowflake, DBT, AWS and/or Azure. • Support infrastructure and deployment automation using Terraform and CI/CD platforms. • Implement and enforce data quality controls and governance processes to ensure accurate and consistent data flows. • Support governance frameworks such as Alation and ensure adherence to regulatory and organisational standards. • Provide technical leadership, mentor junior engineers and promote engineering best practice. • Collaborate with data scientists to deploy analytical and AI models in production environments. • Engage with business and product stakeholders to translate requirements into scalable technical solutions. • Contribute to architecture discussions and recommend improvements based on emerging data engineering trends. Essential Skills And Experience • Strong experience building and maintaining ETL/ELT pipelines using DBT, Snowflake, Python, SQL, Terraform and Airflow. • Proven experience designing and implementing data solutions on cloud-based architectures. • Experience working with cloud data warehouses and analytics platforms such as Snowflake and AWS or Azure. • Proficiency using GitHub for version control, collaboration and release management. • Experience implementing data governance frameworks, including data quality management and compliance practices. • Advanced SQL skills including complex query writing, optimisation and analytics-focused database design. • Strong communication and stakeholder engagement skills, with the ability to present technical concepts clearly. • Excellent problem-solving skills and the ability to translate business requirements into technical solutions. Languages: Python (primary), SQL, Bash Cloud: Azure, AWS Tools: Airflow, DBT Data Platforms: Snowflake, Delta Lake, Redis, Azure Data Lake Infrastructure and Operations: Terraform, GitHub Actions, Azure DevOps, Azure Monitor Desirable Skills And Experience • Experience with enterprise data platforms such as Snowflake and Azure Data Lake. • Understanding of monitoring, model performance tracking and observability best practices. • Familiarity with orchestration tools such as Airflow or Azure Data Factory.