Katyayani Organics is one of the fastest-growing agri-input companies in India. We sell directly to farmers and retailers, digital first: our own farmer and retailer apps and websites come first, followed by telecalling teams and a field sales force. This model produces data at real scale.

Why this role exists

Our data has grown faster than our data foundations. Today it sits across MongoDB, several PostgreSQL databases, Shopify, our marketing automation platform, telephony systems and cloud storage exports, built by different teams at different times. As a result, fields go missing, pipelines fail without alerts, the same number can differ between two reports, and our data and infrastructure costs keep rising.

We are looking for one senior engineer to take complete ownership of this data estate: map it, clean it, make it fast and cost-productive, and build a single trusted foundation that the whole company can rely on.

Key responsibilities

1. Map and govern the data estate

- Build a complete map of every database, collection, table, pipeline and integration within the first 60 days, including who writes to it, who reads it and what it costs.
- Define data ownership, naming standards, schemas and a company-wide data dictionary.

2. Data quality and hygiene

- Audit and correct existing data: missing fields, mixed data types, duplicates, orphan records, broken relationships and test or placeholder records in production.
- Set up automated data quality checks, freshness monitoring and alerts so that any failure is caught within hours.
- Ensure that core business numbers (orders, revenue, leads, calls, returns)



reconcile across all systems.

3. Performance and cost optimization

- Review and optimise slow and expensive queries across MongoDB and PostgreSQL, including indexing, aggregation design and data models.
- Reduce data and infrastructure costs through storage tiering, archiving, right-sizing, event-volume control and removal of duplicate data flows, with every saving tracked and reported.

4. Build the data foundation

- Design and build a central data warehouse or lakehouse with reliable ELT pipelines from all source systems.
- Publish clean, documented datasets for analytics, product and marketing teams, so that no one needs to query production systems directly.
- Work with the technology team to ensure new features capture data correctly at the source.

5. Team and leadership

- Build and lead a small data engineering function over time.
- Review, guide and coach the analysts and developers who work with company data.

Required qualifications
- 7 to 12 years of experience in data engineering, including at least 2 years owning a data platform end to end.
- Strong hands-on experience with MongoDB (aggregation pipelines, indexing, schema design at scale).
- Advanced SQL and PostgreSQL skills,



including query plans and performance tuning.
- Experience building and running data pipelines with tools such as Airflow, dbt, Dagster or equivalent, and strong Python.
- A proven record of reducing cloud or database costs, with measurable results.
- Experience handling high-volume event data such as app, clickstream or marketing events.
- A disciplined approach to data accuracy: you reconcile before you trust a number.
- Comfortable using modern AI tools to speed up engineering, documentation and data validation.

Preferred qualifications
- Background in high-volume consumer technology: e-commerce, food delivery, fintech or gaming.
- Experience with Shopify, marketing automation platforms or telephony data.
- Experience cleaning up and restructuring an existing data estate built by others.
- Experience with cloud data warehouses such as BigQuery, ClickHouse, Snowflake or Redshift.

Success in the first 90 days
- 30 days: A complete, documented map of all data sources, flows and costs.
- 60 days: Critical data quality issues fixed, monitoring live on key pipelines, and first cost savings delivered.
- 90 days: First version of the central warehouse live with trusted core tables for orders, customers, leads and calls.

What we offer
- The opportunity to design the data foundation of a fast-growing company, rather than maintain an existing one.
- Visible, measurable impact on cost, accuracy and decision-making.
- Direct access to leadership through the Founder's Office.
- Competitive compensation, based on experience.

📌 Head of Data Engineering (Bhopal)
🏢 Katyayani Organics
📍 Bhopal