Looking For HR Analyst (Powai) - Dmart Ready

Job Description

Interested Candidates can share their CV on pranali.dhanawade@dmartindia.com

Company Name: Avenue E-commerce Ltd. (DMart Ready / DMart Online)

Avenue E-Commerce Limited (AEL) is an online extension of Avenue Supermarts Limited's flagship brand. DMart Ready is the mobile application through which our customers order grocery and other utility products. We seek to be a one-stop shopping destination for the entire family, meeting all their daily household needs offering value for money. A wide selection of home utility products is offered at affordable prices, including groceries, foods, toiletries, beauty products, garments, kitchenware, bed and bath linen, home appliances and much more. Currently we are present at Mumbai, Pune, Ahmedabad, Hyderabad and Bangalore locations.

Designation: Executive / Assistant Manager HR Analytics

Role Purpose

The ideal candidate will serve as the HR MIS & Analytics Expert for the HR function. You will own the end-to-end data management, HR predictive analytics, and compliance reporting. This role bridges the gap between raw workforce data and strategic decision-making, ensuring data accuracy across payroll, attendance, productivity, and cost optimization.

Job Description

1. Advanced HR Analytics & Cost Optimization

• Demographic Cost Analysis: Conduct state-wise, city-wise, and designation-wise manpower cost analysis to optimize HR budgeting.
• Incentive Modeling: Model, simulate, and compare various incentive revision structures to predict financial and motivational impacts.
• Workforce Metrics: Analyze crucial HR metrics including Attrition Trends, Resource Utilization, Man-days and Working Hour efficiencies to drive productivity.

2. HRMS (Ramco) & Data Governance

• Scorecard & Performance Tracking: Generate and distribute weekly HR Scorecards, Process Audit scores, and operational dashboards via Ramco.
• System Integrity: Oversee EDB (Employee Database) updates and manage Biomax/Biometric enrollments to maintain flawless system records.
• Audit & Anomalies: Conduct regular Attendance Modification analyses to identify patterns, errors, or policy deviations.

3. Pre-Payroll & Leave Management

• Leave Balances & Ledgers: Audit and compile accurate Leave balances monthly ahead of payroll closure.
• Comp-Off Management: Tracks monthly Compensatory Off (Comp-Off) utilization vs. lapse data to ensure policy compliance.
• Document Compliance: Establish a 100% verification process ensuring all hard-copy leave applications match system data managed by site HROs.

Job Specifications

• Education: Graduate/Post-Graduate in HR, Statistics, Business Administration, or a related field.
• Experience: 3 to 5 years of core experience in HR MIS, data preparation, and automated report generation (Retail or E-commerce experience is a plus).

Technical Competencies (Must-Have)

• Advanced Excel: Mastery of VLOOKUP/XLOOKUP, Pivot Tables, Conditional Formatting, Power Query, and complex formula creation.
• Automation: Proficiency in writing and executing Excel Macros (VBA) to automate repetitive data tasks.

More Info

Education