Senior Data / DWH Engineer — Prague (Hybrid, Contract)

You will be responsible for designing and maintaining a modern data warehouse, building reliable ETL/ELT pipelines with DBT and Airflow, and developing FastAPI-based data layers that connect business applications to structured, high-quality data.

What you'll be doing:

• Designing and maintaining data models, data marts, and table structures for OLTP and OLAP use cases
• Developing scalable DBT-based transformation layers with full documentation and quality checks
• Building and enhancing automated data pipelines for loading and transformation end-to-end
• Implementing data validation, reconciliation, and post-load quality checks using SQL
• Developing and maintaining FastAPI data layers to support application integration
• Preparing and maintaining source-to-target mapping documentation
• Working within an Agile delivery model, tracking tasks and releases in Jira

What we're looking for:

• Strong hands-on experience with Python and advanced SQL
• Practical knowledge of DBT and modern ELT/ETL pipeline design
• Experience with cloud data warehousing — Redshift, AWS Athena, or similar
• Ability to deliver independently across multiple workstreams with minimal oversight
• Nice to have: Trino, Airflow, FastAPI, PostgreSQL / PL/pgSQL, Qlik Sense, PyTest, AWS CLI