Data Analyst Intern

PREPCA's interview process typically starts with an online aptitude test covering logical reasoning, data interpretation, and basic quantitative skills. Successful candidates move to a technical interview where they are asked to solve Excel or SQL based case studies and discuss data cleaning techniques. The final HR round evaluates cultural fit, communication skills, and motivation. Overall difficulty is moderate, and thorough preparation of data tools and aptitude questions helps candidates stand out.

PREPCA promotes a collaborative and mentorship‑driven culture where learning is encouraged daily. Employees enjoy a balanced work‑life schedule with weekly offs, rotational shifts, and wellness activities like daily meditation. The company emphasizes growth, offering clear career pathways and exposure to senior leadership.

Graduation (any discipline) pursuing or completed; Minimum 60% aggregate (if applicable); No active backlogs; Basic knowledge of Excel, Google Sheets, SQL, and data tools; Strong logical thinking and attention to detail; Willingness to learn in a fast‑paced environment; Certification in Excel or Data Analyst course (optional but preferred).

Round 1: Online Aptitude Test → Round 2: Technical Interview (focus on Excel/SQL and data concepts) → Round 3: HR Interview (culture fit and communication).

PREPCA (Professional Education & Mentorship Platform for Chartered Accountancy Aspirants) is a fast‑growing mentorship platform that serves thousands of CA students across India. Founded with a vision to blend quality education, smart learning strategies, and robust career guidance, PREPCA has built a strong community of aspirants, mentors, and industry experts. The company operates out of its modern office in Baner, Pune, and leverages technology to deliver interactive live sessions, recorded content, and personalized mentorship. Its focus on data‑driven decision making has helped it continuously improve course offerings, student engagement, and overall success rates. The Data Analyst Intern role is a full‑time, work‑from‑office internship designed for fresh graduates or final‑year students who want hands‑on experience in corporate data analysis. Interns will work closely with senior analysts and the business intelligence team to transform raw data into actionable insights that drive strategic decisions. This position offers a unique blend of learning and responsibility, allowing interns to contribute to real projects while sharpening their analytical toolkit. Key responsibilities include: 1. Collecting data from multiple internal and external sources, ensuring completeness and accuracy. 2. Cleaning, normalising, and preparing datasets for analysis using Excel, Google Sheets, or SQL. 3. Conducting exploratory data analysis to identify trends, patterns, and anomalies. 4. Building and maintaining interactive dashboards and visual reports for senior leadership. 5. Assisting in the preparation of weekly and monthly performance reports. 6. Supporting senior team members in tracking key performance indicators (KPIs) and business metrics. 7. Collaborating with cross‑functional teams to understand data requirements and deliver insights. 8. Documenting data pipelines, methodologies, and findings for future reference. 9. Participating in brainstorming sessions to propose data‑driven solutions for business challenges. 10. Continuously learning new data tools and best practices to improve analytical efficiency. The tech stack primarily involves Microsoft Excel, Google Sheets, SQL (MySQL/PostgreSQL), and basic data‑visualisation tools such as Power BI or Tableau. Exposure to Python or R is a plus but not mandatory. Growth path for a high‑performing intern can lead to a full‑time Data Analyst role, with a potential pre‑placement offer (PPO) of up to 4.80 LPA after successful completion of the internship. Why join PREPCA? The internship provides direct exposure to senior leadership, real‑time corporate experience, and a supportive learning environment. Interns benefit from daily meditation sessions, a collaborative culture, and a clear pathway to a full‑time offer. This is an excellent opportunity for aspiring data professionals to apply classroom knowledge in a dynamic, mentorship‑focused setting while contributing to the success of a leading educational platform.