Senior DWH Engineer
Primary stack
Job description
About the Position
We are seeking a Senior DWH Engineer to design and maintain scalable data models and ETL pipelines in Prague, Czech Republic.
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
Role Overview
The Senior Data / Data Warehouse (DWH) Engineer is responsible for delivering end-to-end data engineering and data warehouse solutions across the full product lifecycle. This role focuses on designing scalable data models, building reliable ETL/ELT pipelines, ensuring data quality, and enabling analytics and application integration in an Agile environment.
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
- Proficiency in Python and SQL
- Experience with DBT, Airflow, FastAPI, PyTests, Qlik Sense, and AWS CLI
- Strong understanding of Data Warehouse (DWH), OLTP, and OLAP
- Familiarity with Agile methodologies and Jira
We Expect You to Have
- Senior level experience in data engineering and data warehousing
- Demonstrated ability to design and implement scalable data models and ETL/ELT pipelines
- Excellent problem-solving skills and attention to detail
- Strong communication and collaboration skills
We Offer
- Opportunity to work in a dynamic and innovative environment
- Hybrid work model
- Competitive compensation package
About the Company
The Workly s.r.o.
4D CENTER, Kodaňská 1441/46,
101 00, Praha 10.
Contact:
[email protected]
- 420 775 371 991
©2023, All right reserved.
Apply for this position
Our team will review your application within the next 5 days.
© The Workly. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.