DWH Engineer

Gypsy Collective
Municipality of Madrid, Spain
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Municipality of Madrid, Spain

Tech stack

Airflow
Amazon Web Services (AWS)
Azure
Google BigQuery
Cloud Computing
Information Engineering
Data Governance
ETL
Data Transformation
Data Vault Modeling
Data Warehousing
Database Queries
Python
Meta-Data Management
Scripting (Bash/Python/Go/Ruby)
Snowflake
GIT
Kubernetes
Infrastructure Automation Frameworks
Star Schema
Vertica
Terraform
Data Pipelines
Docker
Redshift

Job description

sources (APIs, third-party systems, raw data) without disrupting existing pipelines. Collaborating with analysts, engineers, BI teams, and business stakeholders to translate requirements into scalable data solutions. Reviewing code, mentoring engineers, and contributing to data engineering standards and best practices. Requirements Strong SQL skills: complex queries, CTEs, window functions, analytical queries (5+ years experience). Knowledge of Python or other scripting languages for data transformations (4+ years experience). Deep understanding of DWH concepts: ETL/ELT, Data Vault, Kimball, Star/Snowflake schemas (5+ years experience). Experience with Airflow or other data pipeline orchestrators (5+ years experience). Hands-on experience with modern DWH and query engines: BigQuery, Snowflake, Redshift, ClickHouse, Vertica, AWS Athena, Trino (5+ years experience). Confident use of Git; experience with team workflows (pull requests, rebasing, merge conflict resolution) (5+ years experience).

Requirements

Understanding of server and cloud infrastructure: basic skills in configuration, maintenance, monitoring, and load control (3+ years experience). Nice to Have Experience with CDC tools and streaming data sources. Knowledge of Docker, Kubernetes, and Infrastructure as Code (Terraform). Experience with cloud platforms such as AWS, GCP, or Azure. Familiarity with data governance, data cataloging, and lineage tools. Benefits Flexible payment options: choose the method that works best for you. Financial perks: Bonuses for holidays, birthdays, work milestones, and more - just to show we care. Learn & grow: We cover courses and certifications, and offer real opportunities to grow your career with us. Cafeteria benefits: Choose what suits you - sports, language courses, therapy sessions, and more. Stay connected: From team-building events to industry conferences - we bring people together online, offline, and on stage. Modern equipment: We provide new laptops along with essential peripherals

About the company

Gypsy Collective is looking for a DWH Engineer to join our team and help build scalable, reliable, and high-performance data warehouse solutions that support analytics and business decision-making. We are looking for an experienced and proactive engineer who can work across the full data lifecycle-from ingestion and modeling to optimization, monitoring, and automation-while collaborating closely with analysts, developers, and business stakeholders. Responsibilities Designing, building, and maintaining scalable Data Warehouse architectures aligned with business needs. Developing and optimizing ETL/ELT pipelines using Python, Airflow, and custom solutions. Working with DWH/Data Lake technologies including PostgreSQL, Trino, and BigQuery. Implementing incremental loads, CDC, backfills, and reprocessing strategies. Optimizing query performance, data models, and pipeline execution. Ensuring data quality through validation, automated testing, monitoring, and alerting. Integrating new data

Apply for this position