Senior Data Analyst
Pilgrim
- Location
- Mumbai, Maharashtra, India
- Job type
- Full-time
Required skills
- Airflow
- BigQuery
- data analytics
- e-commerce
- ETL
- forecasting
- Pandas
- regression
- statistics
About the role
Pilgrim
Website:
discoverpilgrim.com
Job details:
- 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 useful — 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)
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.