Data Engineer

Stott and May
Charing Cross, United Kingdom
6 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Charing Cross, United Kingdom

Tech stack

Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Data analysis
Azure
Bash
Cloud Computing
Continuous Integration
Information Engineering
Data Governance
Data Integrity
ETL
Data Systems
Data Vault Modeling
Data Warehousing
Database Design
Github
Python
Operational Databases
Redis
Release Management
Azure
SQL Databases
Data Streaming
Azure
Cloud Monitoring
Snowflake
Data Lake
Information Technology
Deployment Automation
Data Management
Terraform
Software Version Control
Data Pipelines

Job description

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., * 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., * Strong experience building and maintaining ETL/ELT pipelines using DBT, Snowflake, Python, SQL, Terraform and Airflow.

Requirements

  • 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, * 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.

Apply for this position