- Turn day-to-day business questions (SKU performance, sales trends, funnel drop-off, inventory/demand signals) into SQL-driven analysis in BigQuery

- Build and maintain ETL/automation pipelines (Airflow/Composer, scheduled BQ jobs, Google Sheets syncs)

- Design and productionize dashboards and visualizations for non-technical stakeholders

- Apply statistical/ML methods where practical — forecasting (Prophet/XGBoost), cohort analysis, anomaly detection — not just reporting

- Partner directly with Supply Chain, Product, and Sales leads to scope requests

- Write clean, documented SQL and Python; care about query cost/performance

Skills:

- 2–4 yrs in analytics engineering / data analytics, ideally D2C, e-commerce, or retail

- Strong SQL (window functions, CTEs, query optimization) — BigQuery specifically is a big plus

- Python for data manipulation (pandas) and automation/scripting

- Comfortable working with messy, real-world business data and translating vague requests into structured analysis

- Basic statistics/ML exposure (regression, time-series forecasting, hypothesis testing)

📌 Senior Data Analyst (Mumbai)
🏢 Pilgrim
📍 Mumbai