Location
lahore
Posted
June 17, 2026
Commute
Local Area
Local Opportunity Near You!
This job is in your area. Enjoy a short commute and work close to home.
Job Description
The Data Warehouse Engineer will be responsible for designing and maintaining a scalable data warehouse on ClickHouse, building and managing ETL/ELT pipelines using Apache Airflow and Airbyte, integrating data from ERPNext (FMCG operations) . The role requires close collaboration with supply chain, operations, finance, and farm management teams to ensure timely, accurate, and business-relevant reporting. All data infrastructure β including ClickHouse, Apache Airflow, Airbyte, dbt, and Apache Superset, Power BI β is deployed and maintained entirely on the company's own servers.
Core Responsibilities:
Β· Design, build, and maintain the ClickHouse data warehouse; manage schema design, partitioning, and query optimization for FMCG datasets (sales, inventory, procurement, farm yield).
Β· Develop, schedule, and monitor ETL/ELT pipelines using Apache Airflow and Airbyte; integrate data from ERPNext, Retail, and Distribution system flat files, APIs, and external farm management syste...
Core Responsibilities:
Β· Design, build, and maintain the ClickHouse data warehouse; manage schema design, partitioning, and query optimization for FMCG datasets (sales, inventory, procurement, farm yield).
Β· Develop, schedule, and monitor ETL/ELT pipelines using Apache Airflow and Airbyte; integrate data from ERPNext, Retail, and Distribution system flat files, APIs, and external farm management syste...