Tech lead

W3Global; Barcelona; On-site; EUR 90,000 - 130,000; Full time

Job summary

W3Global in Barcelona, Spain is seeking a Tech Lead to drive a Redshift to Snowflake migration with strong data governance and business change experience. You will own the technical backlog, engage with stakeholders, and lead a small engineering team through design and delivery.

role requires hands-on capability, excellent communication, and ability to translate business needs into technical tasks. Short-notice availability is preferred.

Qualifications

• Experience migrating Redshift to Snowflake.
• Design data schemas with retention policies for regulatory compliance.
• Translate business goals into epics, user stories and actionable tasks.
• Mentor engineers and lead code reviews to improve delivery quality.
• Strong customer-facing communication with business stakeholders.

Responsibilities

• Client & Stakeholder Engagement: act as the technical point of contact for business stakeholders and lead discovery workshops.
• Architecture & Product Ownership: review migration roadmap and ensure scalable data architecture with governance and retention.
• Team Leadership & Mentorship: lead 3-4 engineers through reviews and guidance.
• Hands-on Execution: assist in pipelines when needed and validate designs.

Skills

Data migration leadership

Data governance

SQL / Python

Stakeholder management

Team leadership

Tools

dbt

Airflow

Snowflake

Job description

• It's for a redshift to snowflake migration involving extensive data retention requirements and business change elements. Project is needing a bit of TLC and requires an engineering tech lead available at short notice.
• A Tech Lead who is good at customer-facing interactions, willing to dive into business requirements, create a technical backlog, and lead three or four less experienced engineers.

Ask From The Manager

• It's for a redshift to snowflake migration involving extensive data retention requirements and business change elements. Project is needing a bit of TLC and requires an engineering tech lead available at short notice.
• A Tech Lead who is good at customer-facing interactions, willing to dive into business requirements, create a technical backlog, and lead three or four less experienced engineers.

Key Responsibilities

• Client & Stakeholder Engagement: Act as the primary technical point of contact for business stakeholders. Lead discovery workshops, unpack business requirements, and manage change expectations across teams.
• Architecture & Product Ownership: Review Review the migration roadmap from Redshift to Snowflake, ensuring the data architecture supports long-term scalability, governance, and strict data retention policies. Translate high-level business goals into structured epics, user stories, and actionable technical tasks; manage the team's sprint backlog.
• Team Leadership & Mentorship: Lead and mentor a team of 3-4 engineers through code reviews, technical guidance, and pair programming to elevate overall delivery quality.
• Hands-on Execution: Step into the code/pipelines when needed to unblock engineers, validate technical designs, and establish best practices for data modeling and transformation.

Technical Requirements

Required Experience & Qualifications:

• Data Warehousing: Proven hands-on experience migrating legacy data platforms (specifically Amazon Redshift) to modern cloud warehouses (Snowflake).
• Data Governance & Retention: Expertise in designing schema architectures, partition strategies, and automated data retention/archival policies for regulatory compliance.
• Data Engineering & Pipeline Design: Proficiency in SQL, Python, and modern data stack tools (e.g., dbt, Airflow, or similar orchestration platforms).
• Leadership & Delivery Requirements
• Cross-Functional Background: Strong dual capability across technical solution design and product/business analysis (backlog grooming, requirements gathering, stakeholder alignment).
• People Leadership: Demonstrated experience mentoring and guiding early-career/mid-level data engineers.
• Communication & Change Management: Excellent customer-facing skills with the ability to articulate complex technical decisions to non-technical business leaders.

Desirable Skills

• Familiarity with business change frameworks or experience navigating organizational shift during large-scale platform migrations.
• Experience with cost-optimization strategies in Snowflake.