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...