01
TRCI-26-05387
Engineering Technical Lead (Data Transformation / Redshift to Snowflake Migration)
Hands-on Engineering Technical Lead needed for a high-visibility data transformation program in Barcelona (hybrid), leading a small team (3–4) and acting as the technical bridge to business stakeholders. The core deliverable is migrating a data warehouse from Amazon Redshift to Snowflake, with strong focus on scalable architecture, governance, and strict data retention/archival for compliance. The role blends solution architecture, product ownership/backlog management, business analysis, and hands-on data engineering (SQL/Python and modern orchestration/tools such as dbt/Airflow).
Position summary
- Location
- Spain
- Workplace
- Hybrid
- Employment
- Contract
- Experience
- Minimum 4 years and Maximum 6 years
Role overview
Why This Role Matters.
Hands-on Engineering Technical Lead needed for a high-visibility data transformation program in Barcelona (hybrid), leading a small team (3–4) and acting as the technical bridge to business stakeholders. The core deliverable is migrating a data warehouse from Amazon Redshift to Snowflake, with strong focus on scalable architecture, governance, and strict data retention/archival for compliance. The role blends solution architecture, product ownership/backlog management, business analysis, and hands-on data engineering (SQL/Python and modern orchestration/tools such as dbt/Airflow).
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
02
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.
03
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.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
Amazon Redshift
Required
02
Snowflake
Required
03
SQL
Required
04
Python
Required
05
dbt
Required
06
Airflow
Required
07
data warehouse
Required
08
data governance
Required
09
data retention
Required
10
archival
Required
11
schema design
Required
12
partitioning
Required
13
orchestration
Required
14
ETL
Required
15
ELT
Required
16
backlog
Required
17
user stories
Required
18
epics
Required
19
sprint
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Amazon Redshift to Snowflake migration (hands-on)
Snowflake data warehousing architecture
Data governance and data retention/archival policy design for compliance
Schema design and partition strategy design
SQL (advanced)
Python for data engineering
Data pipeline design and orchestration (e.g., Airflow or similar)
Modern data transformation tooling (e.g., dbt or similar)
Requirements gathering and translating business needs into epics/user stories/technical backlog
Stakeholder management and customer-facing communication
Leading/mentoring engineers (code reviews, pair programming, technical guidance)
Preferred
Nice to Have
Business change frameworks / change management experience during platform migrations
Snowflake cost optimization strategies
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Engineering Technical Lead (Data Transformation / Redshift to Snowflake Migration)
One page, about two minutes. We only ask for what we actually need to have a first conversation.