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...
Apply for This Position
Ready to take the next step? Click the button below to submit your application.
Submit Application