Senior DWH Engineer (PostgreSQL)

TL;DR

Senior DWH Engineer (PostgreSQL): Designing and maintaining scalable data warehouse solutions and data engineering pipelines with an accent on ETL/ELT optimization, data modeling, 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, Prague (Czechia)

Company

hirify.global is an IT consultancy firm delivering innovative software solutions including AI, ML, BI, and automation for diverse industries such as Telecom, Energy, and Finance.

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 FastAPI-based data services and system integrations.
• Perform data validation, reconciliation, and SQL query optimization.
• Collaborate with cross-functional teams in an Agile delivery lifecycle.

Requirements

• Strong experience in Data Engineering and DWH development.
• Advanced proficiency in Python and SQL.
• Hands-on experience with PostgreSQL, Redshift, Athena, Trino, or SQLite.
• Experience with DBT, Airflow, and FastAPI.
• Solid understanding of data modeling, OLTP, and OLAP concepts.
• Experience working in Agile environments.