Senior DWH Engineer (Python)

TL;DR

Senior DWH Engineer (Python): Designing and maintaining scalable data warehouse solutions and ETL/ELT pipelines with an accent on data modeling and performance optimization. Focus on building DBT-based transformation layers, developing FastAPI data services, and optimizing complex SQL queries for high scalability.

Location: Hybrid in Prague, Czechia

Company

IT consultancy firm that helps startups and large corporations implement innovative technologies across sectors like Telecom, Energy, Banking, and Automotive.

What you will do

• Design and develop scalable data warehouse solutions, data marts, and data models.
• Build and optimize ETL/ELT pipelines and automated data workflows.
• Develop DBT-based transformation layers and maintain DWH models.
• Create source-to-target mappings and maintain detailed technical documentation.
• Develop and support data services and integrations using FastAPI.
• Optimize SQL queries and PL/pgSQL stored procedures for maximum performance and scalability.

Requirements

• Strong professional experience in Data Engineering and Data Warehouse development.
• Advanced proficiency in Python and SQL.
• Hands-on experience with databases such as PostgreSQL, Redshift, Athena, Trino, or SQLite.
• Practical experience with DBT, Airflow, and FastAPI.
• Deep understanding of data modeling, OLTP, and OLAP concepts.
• Experience working in Agile environments using Jira.

Culture & Benefits

• Work in a modern Agile environment with structured delivery processes.
• Opportunity to work on diverse projects across multiple industries.
• Collaborative culture involving close cooperation between technical and business teams.