Associate (Contractual/Off role)

Lupin; Mumbai; On-site; INR 600,000 - 800,000; Full time

Job summary

Lupin in Mumbai is seeking a data-savvy professional to build monthly dashboards and manage MIS reporting for SFE parameters across zones and territories. You will maintain Route Hygiene, update Customer Master, ensure outlets coverage as per visit pattern, and design data formats to meet reporting needs.

Strong Excel skills and cross-functional collaboration are essential for success. This role offers exposure to sales analytics and performance tracking, with regular interaction with field

Qualifications

• Strong communication and interpersonal skills.
• Advanced knowledge of MS Excel, including Pivot Tables, VLOOKUP, and dashboards.
• Ability to coordinate with cross-functional teams and ensure timely follow-up.
• Experience in MIS reports, dashboards, and data-driven decision making.

Responsibilities

• Create monthly dashboards to update SKUwise SFE parameters from zone to territory level.
• Maintain Route Hygiene and Customer Master.
• Ensure outlets coverage as per visit pattern.
• Prepare and track daily, weekly and monthly effort performance.
• Design data formats based on requirements.
• Resolve SFE-related data issues.
• Onboard employees on SFA by creating their masters.

Skills

MS Excel

Pivot Tables

VLOOKUP/XLOOKUP

Dashboards

Data analysis

Tools

MS Excel

Job description

Role & responsibilities

1. Creating Monthly Dashboard to give update on SKUwise SFE parameters (like TC, PC, ECO, POB) from zone level till territory level.

2. Maintaining Route Hygiene & Maintaining Customer Master.

3. Ensuring outlets coverage as per visit pattern.

4. Preparation & Tracking of Daily, Weekly & Monthly efforts performance.

5. Designing various data format based on the requirements.

6. Resolution of fields SFE related issues.

7. Onboarding employee on SFA by creating their masters.

Preferred candidate profile

• Strong communication and interpersonal skills.
• Advanced knowledge of MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas, dashboards, and data analysis).
• Ability to coordinate with cross-functional teams and ensure timely follow-up on deliverables.
• Experience in preparing MIS reports, developing dashboards, and managing business data for reporting and decision-making.