Tech Lead / Data Engineering

Project overview

This contract role will lead the architecture and delivery of a scalable Snowflake data platform, including standards, pipelines, governance, and DataOps. The core requirements are hands-on Snowflake, data warehousing and modeling, advanced SQL, dbt-based ETL/ELT, data architecture, CI/CD, and AWS, alongside technical leadership and stakeholder collaboration. Airflow, lakehouse experience, Tableau or Power BI, and pharmaceutical or healthcare experience are preferred. The structured experience band is 6–8 years, and the location is Europe; the work mode is not specified.

Clinical stakeholders and pharma-specific standards indicate a pharmaceutical or healthcare data context, although prior experience in that domain is preferred rather than mandatory.

Responsibilities

• Define and enforce data architecture standards, including modeling, naming conventions, and best practices.
• Design and implement robust ETL/ELT pipelines using DBT and cloud-native tools.
• Collaborate with global stakeholders (business, analytics, clinical, and IT teams) to translate requirements into scalable solutions.
• Drive data governance, lineage, cataloging, and quality frameworks across the platform.
• Ensure compliance with European data regulations (e.g., GDPR) and pharma-specific standards.
• Implement CI/CD pipelines and DataOps practices for automated testing, deployment, and monitoring of data workflows.
• Optimize Snowflake performance, including query tuning, clustering, and cost management.
• Provide technical leadership, architectural guidance, and mentorship to engineering teams.
• Evaluate emerging tools and technologies to continuously improve the data ecosystem.
• Work closely with DevOps and infrastructure teams to ensure high availability, scalability, and security.
• Deep understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas).
• Advanced proficiency in SQL and complex query optimization.

Requirements

• Hands-on Snowflake data warehousing, performance tuning, security, and cost optimization
• Data warehousing concepts, including dimensional modeling and star or snowflake schemas
• Advanced SQL and complex query optimization
• ETL/ELT development, especially with dbt
• Data architecture and distributed data systems design
• CI/CD pipelines and tools such as Git, Jenkins, GitHub Actions, or Azure DevOps
• AWS cloud platform experience
• Data governance, lineage, cataloging, and data quality frameworks
• Technical leadership, architecture guidance, and team mentorship
• Stakeholder management and communication across business and technical teams

Project details

• Start: flexible
• Remote: hybrid
• Location: Europe, GB