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
Strong 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
