Product Analyst Intern

About this internship

Skills you'll use

What you'll do

• Collect, clean and validate data so it is accurate and analysis-ready
• Write and optimise SQL queries to extract and transform data
• Build dashboards, KPIs and reports using SQL, Product Analytics, A/B Testing, Python
• Analyse data for product funnel, retention and A/B-test analysis and surface actionable insights
• Translate business questions into clear, data-backed recommendations
• Present findings to product, growth, finance and operations partners

Who can apply

• Pursuing or recently completed B.E./B.Tech/B.Sc/BCA/B.Com/BBA/MBA/Economics/Statistics or a related analytical discipline — 2026 freshers & final-year students welcome
• Working knowledge of SQL, Product Analytics, A/B Testing (or a strong willingness to learn them)
• Comfort with spreadsheets, basic statistics and clear data storytelling
• Strong analytical thinking, attention to detail and communication skills
• Based in or willing to work from Chennai

Perks & benefits

Interview & selection process

4 rounds — typical selection flow for this role:

1. 1Application screening & resume shortlisting by the talent team
2. 2Team-fit / behavioural interview with the data team
3. 3Online aptitude, SQL and Excel assessment
4. 4HR discussion — stipend, start date, expectations and offer

About Effica Technologies

Searching for “Effica Technologies internships” or “internship at Effica Technologies”? You’re in the right place.