Job Role: Data Analyst

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

Solid knowledge of Advanced Excel:

- CountIFs, SumIFs, Array Formla, Querry, Etc
- VLOOKUP / XLOOKUP
- Conditional Formatting
- Data Cleaning
- Interactive Dashboard Creation
- Strong analytical and logical thinking ability
- Good attention to detail




- 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

Location Link: https://maps.app.goo.gl/GVizJDZQrHTnk6CB8

Know More About Us

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

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

Glassdoor: https://www.glassdoor.co.in/Reviews/Prepca-Eduserv-Reviews-E5173239.html

AmbitionBox: https://www.ambitionbox.com/reviews/prepca-eduserv-reviews

Website: https://www.prepca.com

📌 Data Analyst (India)
🏢 Lime Learn Eduserv
📍 India