Consultant

Hikvision India; Mumbai; On-site; INR 350,000 - 600,000; Full time

Job summary

Hikvision India seeks a data‑driven analyst to support daily MIS and administrative reporting. You will split time between calling tasks and heavy Excel work, ensuring accurate data entry and up‑to‑date records.

The role emphasizes advanced Excel skills (VLOOKUP, Pivot Tables) and reporting accuracy, with responsibilities including creating reports, tracking tasks, and coordinating with internal teams to meet deadlines.

Qualifications

• Proficient in MS Excel with data entry and reporting experience.
• Experience using VLOOKUP, Pivot Tables, filters and sorting.
• Strong communication and calling skills; attention to detail.

Responsibilities

• Handle 40% calling work including customer/vendor follow-ups and maintaining call records.
• Manage 60% Excel-based work including data entry, data management, reporting, and maintaining daily records.
• Perform VLOOKUP and other Excel functions to analyze, compare, and reconcile data.
• Create and maintain Pivot Tables for reports and data summaries.
• Ensure accuracy and timely updating of Excel sheets and databases.
• Prepare daily, weekly, and monthly reports as required.
• Coordinate with internal teams and follow up on pending tasks via calls.
• Maintain proper documentation and records of all activities.
• Support the team with regular MIS and administrative reporting.

Skills

MS Excel

VLOOKUP

Pivot Tables

Data entry

Communication skills

Tools

Excel functions

Job description

Role & Responsibilities

• Handle 40% calling work, including customer/vendor follow-ups, coordination, and maintaining call records.
• Manage 60% Excel-based work, including data entry, data management, reporting, and maintaining daily records.
• Perform VLOOKUP and other Excel functions to analyze, compare, and reconcile data.
• Create and maintain Pivot Tables for preparing reports and summarizing data.
• Ensure accuracy and timely updating of Excel sheets and databases.
• Prepare daily, weekly, and monthly reports as required.
• Coordinate with internal teams and follow up on pending tasks through calls.
• Maintain proper documentation and records of all assigned activities.
• Support the team with regular MIS and administrative reporting.

Required Skills

• Good working knowledge of MS Excel.
• Hands-on knowledge of VLOOKUP, Pivot Tables, filters, sorting, and basic formulas.
• Good communication and calling skills.
• Good data-entry and documentation skills.
• Ability to manage multiple tasks and meet deadlines.
• Attention to detail and accuracy.
• Basic knowledge of MIS/reporting will be an advantage.