Interactive Management Solutions Ltd
Senior Data Engineer (Snowflake & dbt)
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Role Title: Senior Data Engineer (Snowflake & dbt)
Location: Lisbon, Portugal (Hybrid / On-site)
Contract Type: 3-Month Rolling Contract
Start Date: September 21st
About the Role
We are seeking an experienced Snowflake & dbt Data Engineer to lead the ingestion, modeling, and architectural optimization of massive data streams for our client in Lisbon. You will be responsible for handling high-volume third-party (e.g., AppsFlyer) and first-party data sources, processing 4–5 TB daily.
In this hands-on contract role, you will design robust direct connections, optimize variant loading, and build scalable, cost-effective ELT pipelines using dbt medallion architecture to supply production-ready data marts for downstream analytics.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Key Responsibilities
- Scalable Pipeline Architecture: Design direct connections and build cost-effective ELT pipelines following the dbt medallion architecture (Bronze/Silver/Gold).
- High-Volume Ingestion: Optimize raw JSON variant data loading into Snowflake, managing daily volumes of 4–5 TB seamlessly.
- Performance Tuning: Implement incremental models, advanced table clustering, and performance optimizations to manage query costs and compute efficiency.
- Data Integrity & Operations: Deploy schema drift protection, automated validation routines using zero-copy cloning, and proactive monitoring to ensure analytics-ready data availability.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Required Skills & Qualifications
- Snowflake Expertise: Extensive experience managing high-throughput data warehouses, raw JSON variant processing, table clustering, and zero-copy cloning.
- dbt Mastery: Deep practical knowledge of building production-grade dbt models, medallion architectures, and incremental loading strategies.
- Big Data Processing: Proven track record handling multi-terabyte daily datasets (4+ TB) from both first-party streams and third-party platforms (e.g., AppsFlyer).
- Data Modeling: Strong foundation in dimensional modeling, schema management, and schema drift mitigation.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Location