Senior DWH Engineer

TL;DR

Senior DWH Engineer: Designing and developing scalable data warehouse solutions and ETL/ELT pipelines with an accent on data modeling, performance optimization, and system integration. Focus on building robust DBT-based transformation layers, developing FastAPI data services, and ensuring high data quality within an Agile environment.

Location: Hybrid in Prague, Czechia

Company

hirify.global is an IT consultancy firm providing innovative software solutions across diverse industries including telecom, banking, and automotive.

What you will do

• Design and maintain data warehouse solutions, data marts, and complex data models.
• Build and optimize automated ETL/ELT pipelines and data workflows.
• Develop DBT-based transformation layers and maintain technical documentation.
• Create and support FastAPI-based data services and system integrations.
• Perform data validation, reconciliation, and SQL query optimization.
• Collaborate with cross-functional teams to support Agile delivery and release readiness.

Requirements

• Must be based in or able to work from Prague, Czechia
• Advanced proficiency in Python and SQL.
• Strong experience in Data Engineering and DWH development.
• Hands-on experience with PostgreSQL, Redshift, Athena, or Trino.
• Experience with DBT, Airflow, and FastAPI.
• Solid understanding of OLTP and OLAP concepts.

Culture & Benefits

• Work in a modern Agile environment.
• Exposure to diverse projects across multiple industries.
• Focus on continuous improvement of data architecture practices.
• Opportunity to work on full product lifecycle solutions.