Data Analyst

PREPCA Eduserv Private Limited; Pune District; On-site; INR 180,000 - 240,000; Full time

Job summary

PREPCA Eduserv Private Limited is seeking a Data Analyst / MIS professional to join our Pune team. Location is Baner (Work from Office) with office hours 10:30 AM to 7:30 PM. You will collect, organize, and maintain business data, and prepare MIS reports and dashboards to track KPIs and trends.

The ideal candidate has strong Advanced Excel skills and experience with data analysis and reporting. Freshers with excel skills are welcome; 0-3 years experience preferred.

Qualifications

• Must have strong knowledge of Advanced Excel.
• Experience in data analysis and MIS reporting.
• Familiarity with VLOOKUP and XLOOKUP.
• Ability to organize and maintain business data.

Responsibilities

• Collect, organize, and maintain business data
• Prepare daily, weekly, and monthly MIS reports
• Create Sales and Revenue dashboards using Advanced Excel
• Track KPIs and performance metrics
• Identify trends and highlight improvement areas
• Ensure data accuracy and consistency

Skills

Advanced Excel

Data analysis

Problem solving

VLOOKUP / XLOOKUP

Job description

Location: Baner - Pune (Work from Office)

Office Timing- 10:30 AM - 7:30 PM

Salary: 1.8 upto 2.4 CTC (based on skills & experience)

Experience: 0-3 Years

Company: PREPCA

About PREPCA

PREPCA is a Leading Mentorship Platform for Chartered Accountancy Aspirants across India focused on Quality Education, Smart Learning Strategies, and Strong Career Guidance.

KEY RESPONSIBILITIES

• Collect, organize, and maintain business data
• Prepare daily, weekly, and monthly MIS reports
• Create Sales and Revenue dashboards using Advanced Excel
• Track KPIs and performance metrics
• Identify trends and highlight improvement areas
• Ensure data accuracy and consistency

SKILLS & REQUIREMENTS

Strong knowledge of Advanced Excel:

• Conditional Formatting
• Data Cleaning
• Strong analytical and logical thinking ability
• Comfortable working with numbers and structured data

PREFERRED

• 0-3 years of experience in Data Analysis / MIS / Reporting
• Experience from any industry or domain welcome
• Freshers with strong Excel skills are encouraged to apply

Weekly Off - Rotational

Mode of Working- Work From Office

Office Location -

Sai Heritage, 3'rd floor, Baner Rd, near State Bank of Mysore, Baner, Pune, Maharashtra 411045

Life at PREPCA: https://youtu.be/C0P4uQQZj5A

Google Reviews: https://g.co/kgs/b9SsJf

Website: https://www.prepca.com

Required Skills

Problem solving Mindset Conditional Formatting Strong analytical and logical thinking ability Strong knowledge of Advanced Excel Basic Dashboard Creation VLOOKUP / XLOOKUP