Area: Country India
Department: Sales
Direct Reporting Line: Sr. Manager DP&A - DPC
Indirect/secondary reporting line: n/a
Subsidiary/country: India
Location: Gurgaon
GSMS Grade: M4
Number of Personnel Managed: n/a
Cost Center/Budget and/or Revenue Responsibility: n/a
Purpose & Overall Relevance for the Organization:
- To build and own a scalable, automated data and reporting ecosystem for Digital Commerce, enabling accurate, real-time and actionable visibility into business performance across partners, own e-commerce and quick commerce channels.
- The role will be responsible for transforming fragmented data into integrated dashboards, automated reporting solutions and decision-ready insights.
- This role works in close collaboration with multiple teams across KAMs, Merchandising and DPC partners’ Brand Ads and Category teams.
Key Responsibilities:
Data Solutions
- Build and own a robust, end-to-end Power BI dashboard suite for digital sales, integrating data from partners, own e-commerce and quick commerce
- Create unified views to track sell-out, digital sales, product KPIs and partner/platform performance across all channels
- Design and maintain scalable data models to support consistent and accurate reporting across sources
Data Engineering & Automation
- Develop and optimize SQL queries to extract, clean and transform large datasets from multiple data sources
- Build automated reporting pipelines and workflows to reduce manual intervention and improve speed, accuracy and scalability
- Identify and implement opportunities to streamline, standardize and automate recurring reporting processes
Reporting & Performance Tracking
- Maintain, track and share detailed reports on product and performance KPIs across all accounts
- Ensure strong reporting cadence (weekly/monthly) with high data accuracy, quality checks and governance
- Drive data consistency across sources and ensure alignment on KPI definitions and reporting frameworks
Platform & Partner Data Integration
- Leverage platform tools such as Amazon Pi, Flipkart Insights and Myntra Insights for data extraction and analysis
- Integrate partner-level data into centralized dashboards to enable holistic performance tracking
Business Insights & Stakeholder Management
- Drive a regularized reporting cadence for Sell-Out & sell-through insights across DPC accounts : Pre sell-in account specific inputs, In-season product GV & conversion analysis, Campaign sell-out analysis
- Replenishment model tracking & analysis
- Work closely with cross functional teams especially Sales, Brand, Merchandising and provide stakeholders with actionable recommendations and calls for action, based on your gathered insights
- Establish a regularized reporting cadence for brand performance indicators : Share of Search, Top keywords performance, Brand Recall, Awareness, Consideration metrics, N2B customer insights and R&R analysis
- Translate data into clear, business-relevant insights and recommendations
- Continuously identify new ways of analysing business performance and uncovering growth opportunities
- Drive a fact-based, data-driven decision-making culture across stakeholders
- Drive various Emerging Markets (EM) projects & initiatives and ensure on-time reporting of performance against required digital metrics
- Work closely with cross functional teams especially Sales, Brand, Merchandising and provide stakeholders with actionable recommendations and calls for action, based on your gathered insights
Key Relationships:
- External: DPC Partner teams (Category)
- Internal: Sales Teams, Merchandising, EM/Global Digital Analytics team
Knowledge, Skills and Abilities:
- Full knowledge of power BI, SQL, query joining & data visualization techniques
- A growth-led mindset
- Data Analytics & Interpretation: Comfortable with data and ability to interpret what it says
- Highly numerate with strong attention to detail
- Confident with web analytics and digital metrics
- Constantly curious, always asking the right questions, whilst at the same time having a passion for data
- Excellent visualization, storytelling and presentation skills
- Consumer-obsessed & always on the lookout for ways to experiment, test and measure
- A passion for delivering data-based recommendations for quantifiable improvements in business results
- Independent working style: Able to work independently on his/her own and drive organizational goals
- Demonstrating creativity and initiative and acting in a result orientated way
- Ability to meet critical deadlines with planning and organization skills
Requisite Educational and Professional Background:
- Proficient in Power BI, Tableau, SQL & Advanced MS Excel- expert with all
- Functional: 7 years+ experience in Digital Analytics / E-commerce Sales
- Industry: Ideally from Apparel/Fashion/Shoes or FMCG background
- Prior exposure: Sports, eCommerce, Analytics, Digital Ads, Digital Marketing & Strategy
- Tertiary qualification in business with Marketing & Analytics focus
- Fluent in English, both verbal and written
