Day-to-Day Responsibilities
Data Ownership & ETL : -
- Take end-to-end ownership of high-frequency datasets (e.g., seller discoverability, catalogue quality, order funnels, SLA / TAT adherence, compliance).
- Build and maintain automated ETL pipelines using SQL, Python, and Power Automate.
- Ensure datasets are accurate, reliable, and regularly refreshed.
- Validate and optimize datasets to make them trusted single sources of truth.
Dashboarding & Reporting : -
Develop and manage Power BI dashboards with role-level security.Provide real-time visibility into order journeys, operational KPIs, and category growth.Improve dashboard usability, performance, and accuracy.Automate insight emails / reports highlighting trends, anomalies, and actions for leadership.Operational, API & Growth Analytics : -
Monitor key operational metrics — TAT breach, fill rate, cancellations, delivery aging, SLA adherence.Analyze API logs and event-driven datasets to understand order lifecycle behavior.Ensure log compliance across buyer and seller platforms.Build frameworks like Network Participant (NP) Scorecards to track performance.Partner with category teams to identify order drop-offs, visibility gaps, and growth opportunities.Stakeholder Engagement : -
Collaborate across internal teams to solve operational and strategic challenges.Work closely with Buyer Apps, Seller Apps, and Logistics Partners to improve catalogue onboarding, order flow, and fulfillment.Present insights and recommendations to senior leadership in a business-focused manner.Ideal Candidate Profile
Education & Experience : -
Master's degree in Computer Science, Statistics, Data Science, Economics, or related field.5+ years in data processing and pipeline building.Experience with DAX queries or BI pipeline creation.Preferably 2+ years in e-commerce, retail, or logistics analytics.Strong understanding of digital commerce funnel — catalog → search → cart → order → fulfillment → resolution.Technical Skills : -
Advanced SQL / PostgreSQL for querying, modeling, and ETL.Strong Power BI skills (dashboarding, optimization, security).Python for data automation and analysis.Excel (advanced) for ad-hoc analysis.Experience with API or transactional datasets (order lifecycle events, SLAs, logs).Behavioral & Soft Skills : -
Business-first mindset and analytical problem-solving.Ownership mindset for data accuracy and reliability.Strong communication — turning data into actionable insights.Collaborative in fast-paced, cross-functional environments.Skills Required
Power Bi, Postgresql, Api, Excel, Sql, Python