Senior Data Analyst
Pilgrim · Mumbai · onsite · Posted 71d ago
Not disclosed2–4 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
- 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)
Sourced from foundit
Skills
statistical ML methodsEtl Automationprophetapache airflowXgboostbigqueryAnomaly Detectioncohort analysisPythonSQLPandasGoogle ComposerForecasting
About Pilgrim
Pilgrim
Internet
620
employees
2019
7 years old
Mumbai,Maharashtra
India
₹9.8L PA avg
Avg at Pilgrim
About
Pilgrim is an innovative and one of the fastest growing businesses in the beauty space. Founded by entrepreneurs from IIT Bombay and IIM Ahmedabad, it offers a dynamic, fast paced and fun culture.
Industries
Internet
Employee ratings
10 reviews
3.7/ 5
Culture
3.0
Career growth
2.9
Work-life
3.6
Employees rate it well for
Overall Company37Work-Life Balance36
Find them on