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.

‍

Key Roles & 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.

‍