Senior Data / Data Warehouse (DWH) Engineer

About the Position

We are seeking a Senior Data / Data Warehouse (DWH) Engineer to join our team in Prague, Czech Republic. This role involves designing scalable data models and building reliable ETL/ELT pipelines.

Responsibilities

• Own end-to-end data engineering and DWH delivery, covering requirement gathering, design, development, validation, documentation, and production deployment.
• Design, develop, and maintain data models, data marts, and table structures to support both OLTP and OLAP reporting and analytics needs.
• Contribute to ETL/ELT architecture and workflow design through active participation in technical discussions and solution reviews.
• Prepare and maintain source-to-target mapping documentation to ensure accurate and consistent ETL development.
• Develop, execute, and document DBT-based DWH models, ensuring scalable, maintainable, and high-quality transformation layers.
• Build and enhance automated data pipelines for data loading and transformation; deliver pipelines end-to-end aligned with business outcomes.
• Develop and maintain FastAPI-based data layers to support application integration and structured data access.
• Implement data validation, reconciliation, and post-load quality checks using SQL scripts to ensure data completeness and accuracy.
• Modify, test, and optimize PL/pgSQL stored procedures to support data transformations and processing requirements.
• Deliver multiple workstreams independently with strategic guidance, ensuring ownership, quality, and timely delivery.
• Coordinate effectively with on-site and off-site teams, managing dependencies and supporting smooth execution.
• Support product demonstrations and user training sessions when required.
• Work within an Agile delivery model, using Jira for task tracking, execution, and release readiness.

Requirements

• Tech Stack / Environment
  • Databases / Engines: AWS Athena, Trino, SQLite, Redshift, PostgreSQL
  • Languages: Python, SQL
  • Tools: DBT, Airflow, FastAPI, PyTests, Qlik Sense, AWS CLI
  • Technologies: Data Warehouse (DWH), OLTP, OLAP, Agile, Jira

We Offer

• Hybrid work environment
• Opportunity to work with cutting-edge technologies and tools

About the Company

The Workly s.r.o.

4D CENTER, Kodaňská 1441/46,

101 00, Praha 10.

Contact: [email protected]

Phone: + 420 775 371 991

©2023, All right reserved.