Tech Lead / Data Engineering (Mandatory: Snowflake)

W3Global; Spain; On-site; EUR 90,000 - 120,000; Full time

Job summary

W3Global is seeking a senior Data Architect to lead end-to-end data platform design on Snowflake, ensuring scalable, compliant systems across Europe. You will drive data governance, modeling standards, and robust ETL/ELT pipelines using DBT and cloud-native tools.

You will collaborate with global stakeholders, mentor engineering teams, and continuously evaluate new technologies to improve performance, security, and cost management of the data ecosystem.

Qualifications

• Strong hands-on expertise in Snowflake (data warehousing, performance tuning, security, cost optimization).
• Deep understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas).
• Advanced proficiency in SQL and complex query optimization.
• Extensive experience in ETL/ELT development, especially with DBT.
• Experience in data architecture and distributed data systems design.
• Strong exposure to CI/CD pipelines (Git, Jenkins, GitHub Actions, Azure DevOps).
• Experience working with cloud platforms (AWS).

Responsibilities

• Lead the end-to-end architecture, design, and implementation of scalable data platforms using Snowflake.
• 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.

Skills

Snowflake expertise

Data warehousing concepts

Advanced SQL

DBT + ETL/ELT

Data architecture

CI/CD pipelines

AWS cloud

Tools

Snowflake

DBT

Git

Jenkins

GitHub Actions

Azure DevOps

Apache Airflow

AWS

Job description

• Lead the end-to-end architecture, design, and implementation of scalable data platforms using Snowflake.
• 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.

Key Responsibilities

• Lead the end-to-end architecture, design, and implementation of scalable data platforms using Snowflake.
• 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.

Mandatory Skills

• Strong hands-on expertise in Snowflake (data warehousing, performance tuning, security, cost optimization).
• Deep understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas).
• Advanced proficiency in SQL and complex query optimization.
• Extensive experience in ETL/ELT development, especially with DBT.
• Experience in data architecture and distributed data systems design.
• Strong exposure to CI/CD pipelines (Git, Jenkins, GitHub Actions, Azure DevOps).
• Experience working with cloud platforms (AWS).

Preferred Skills

• Experience with orchestration tools like Apache Airflow or similar.
• Exposure to data lake / lakehouse architectures.
• Experience with data visualization tools (Tableau, Power BI).
• Prior experience in pharmaceutical / healthcare domain (clinical, R&D, or commercial data).

Leadership & Soft Skills

• Strong stakeholder management and communication skills across business and technical teams.
• Ability to drive architecture decisions and influence enterprise data strategy.
• Experience working in Agile/Scrum environments