Join a leading mentorship platform as a Data Analyst to manage business data and drive insights through advanced reporting and analytics.

About the Company

PREPCA is a renowned mentorship platform dedicated to providing chartered accountancy aspirants across India with quality education, effective learning strategies, and robust career guidance. The organization emphasizes fostering a supportive environment for students aiming for success in their careers.

Role Overview

As a Data Analyst at PREPCA, you will play a crucial role in managing and analyzing business data to support the organization's reporting and analytics needs. You will be responsible for creating accurate MIS reports and insightful dashboards that track key performance indicators (KPIs) and help in identifying trends for better decision-making. The position is office-based in Baner, Pune, with operational hours from 10:30 AM to 7:30 PM.

Key Responsibilities

• Collect, organize, and maintain business data to ensure easy access and reliability.
• Prepare daily, weekly, and monthly Management Information System (MIS) reports to provide stakeholders with timely updates.
• Create and manage advanced Sales and Revenue dashboards using Excel to visualize performance metrics effectively.
• Track key performance indicators (KPIs) and performance metrics to facilitate proactive management decisions.
• Identify patterns and trends within the data to highlight improvement areas for the organization.
• Ensure data accuracy and consistency across all reporting mechanisms.

Tech Stack

• Advanced Microsoft Excel
• Data Visualization Tools (implied through dashboard creation)
• Data Management techniques
• Analytical Tools (not specifically mentioned but implied)

Additional Information

• Office Location: Sai Heritage, 3rd floor, Baner Rd, near State Bank of Mysore, Baner, Pune, Maharashtra 411045.
• Life at PREPCA: YouTube Link
• Company Reviews: Google Reviews, Glassdoor, AmbitionBox.
• Website: prepca.com

• Strong knowledge of Advanced Excel (including CountIFs, SumIFs, Array Formulas, Queries, etc.)
• Proficient in VLOOKUP / XLOOKUP
• Experience with Conditional Formatting
• Skilled in Data Cleaning and Interactive Dashboard Creation
• Strong analytical and logical thinking abilities
• Attention to detail and comfort working with numbers and structured data
• 0–3 years of experience in Data Analysis / MIS / Reporting (Freshers with strong Excel skills are encouraged to apply)

• Work from Office with a collaborative environment
• Rotational weekly off to maintain work-life balance
• Opportunities for skill development and professional growth
• Access to mentorship programs and resources
• Competitive salary based on skills and experience
• Engaging workplace culture with team-building activities