Business Analyst

About Doodhvale Farms

Doodhvale Farms is a premium direct-to-consumer dairy & daily essentials brand delivering fresh, pure, and ethically-produced milk and dairy products straight from their own farms to customers’ homes. We champion transparency, single-sourcing, and wellness for families.

About the Role

Doodhvale Farms is seeking a Data Analyst who is exceptionally strong in Excel/Google Sheets, reporting automation, SQL-based data extraction, and dashboard building. This role requires someone who is hands-on, detail-oriented, and able to support daily operations through reliable data insights.

Key Responsibilities

• Develop and manage automated dashboards and reports for operations, sales, procurement, production, and logistics.
• Perform daily/weekly/monthly data refreshes and ensure clean, accurate datasets.
• Use advanced Excel / Google Sheets (Pivot, Power Query, LOOKUPs, What-if Analysis, formatting automation, Data Studio integration if required).
• Write SQL queries for data extraction, filtering, validation, and joining multiple tables.
• Build Power BI dashboards with clear KPIs and drill-down insights.
• Maintain and organize data in Google Drive, ensuring proper folder structure and accessibility.
• Support process teams by identifying data gaps, improving data flow, and creating easy-to-use reporting templates.
• Assist management with ad-hoc analysis, forecasting sheets, performance trackers, and MIS reporting.
• Work closely with operations, finance, procurement, and city teams to understand ground-level KPIs and build relevant insights.