Data Analyst - Sales Planning ( Third Party Payroll )

Sales Planning

Analyzing large datasets and converting them into actionable insights for leadership.

• Develop macro & dashboards according to need of team & higher authority.
• Collect The data from All region and Making their Multiple kinds of reports.

Role & responsibilities

• Automation: Using Excel VBA/Macros to automate daily, weekly, and monthly reports to increase efficiency.
• Reporting & Analysis: Generating, maintaining, and consolidating MIS reports.
• Data Visualization: Designing dashboards and presentations (PPT) with charts .
• Compilation and management of data, and visualizations, to track key performance indicators (KPIs) such as stock nos, retail, enquiries, and bookings.
• Creating daily and monthly MIS reports and presenting them to top management.
• Preparing MIS Reports like Target Vs Achievement report daily and monthly, Trend sheet for Customer order and Enquiry for Analysis and Management decision
• Coordinating with sales team to collect and clean data as required.

Note : This role is on Third party payroll, its a permanent position on payroll of staffing vendor

Preferred candidate profile

Graduate/Postgraduate in Business, Statistics, Data Analytics, or related field.

•Should have 4+ years of relevant experience in MIS, sales analytics, or business reporting.

• Strong working knowledge of MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas). VBA .