Job Description
🌟 About the Role & Team:
Flipkart is India's leading e-commerce ecosystem. In this role within our Supply Chain & Growth Analytics team, you will unlock deep behavioral insights from terabytes of user transaction logs, optimize warehouse fulfillment turnaround times, and build executive dashboards for leadership.
🎯 Key Responsibilities:
• Write complex SQL queries, window functions, and stored procedures across BigQuery, Snowflake, and PostgreSQL warehouses.
• Build automated, interactive PowerBI and Tableau dashboards tracking Big Billion Day sales metrics, GMV, and inventory health.
• Perform statistical hypothesis testing, churn analysis, and cohort modeling using Python (Pandas, Matplotlib, Seaborn).
• Translate ambiguous business requirements from Category Managers into structured quantitative problem statements.
• Automate recurring reporting pipelines and data validation scripts to ensure 100% data integrity.
💼 Qualifications & Technical Requirements:
• Degree in Engineering, Mathematics, Statistics, Economics, or Computer Applications.
• Exceptional mastery of SQL (joins, aggregations, windowing, query optimization) and relational data modeling.
• Hands-on proficiency with Microsoft Excel (VLOOKUP, INDEX/MATCH, Pivot Tables, PowerQuery) and PowerBI.
• Working knowledge of Python for automated data extraction and exploratory data analysis (EDA).
🚀 Preferred & Bonus Skills:
• Familiarity with cloud data warehouses (Google BigQuery, AWS Redshift, or Snowflake).
• Understanding of e-commerce funnel metrics (CAC, LTV, Retention, CTR, Return Rates).
• Certification in Google Data Analytics, PowerBI, or SQL Specialist.
🎁 Compensation, Benefits & Career Growth:
• CTC: ₹7,50,000 per annum + Annual Performance Incentive.
• Group Medical Insurance coverage for employee and parents.
• Subsidized Flipkart Campus Cafeteria, gym access, and recreation facilities.
• Accelerated career transition into Senior Data Scientist or Product Manager tracks.
⚡ Hiring & Evaluation Process:
1. ATS Profile & Academic Evaluation
2. Live SQL Challenge & Business Case Study (45 mins)
3. Data Visualization & Analytical Problem Solving Round
4. HR & Culture Fitment Round