Who we are
Certifications include ISO 27001 and SOC 2 Type II, and we hold partner status with Microsoft, Cisco and VMware.
About the role
Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across India. Few meetings, lots of written updates.
Day to day
- Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
- Prepare the weekly MIS report and send it to the team lead every Monday.
- Document metric definitions so everyone calculates churn and conversion the same way.
- Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
- Create charts and short slide decks for the monthly review call.
- Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
- Analyse funnel drop-offs and summarise findings in a one-page note.
- Answer ad hoc data requests from sales and support within a day or two.
Requirements
- Women returning to work after a career break are welcome to apply.
- Are able to join within 15 days.
- Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2027 batch)
- Available for a full-time (work from home) internship for the full duration.
- Basic SQL, enough to write SELECT queries with joins and filters.
- Laptop with Excel or Google Sheets and a stable internet connection.
- Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
- Comfort with numbers and strong attention to detail.
- Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027.
Nice to have
- Prior project with real business data from a college club, family business or freelance client.
- Familiarity with DAX in Power BI.
- Python with pandas for data cleaning.
What you'll learn
- How business metrics like CAC, churn and retention are actually calculated.
- Top interns are considered for a junior analyst opening.
Duration: 3 months
Start date: Within 2 weeks
Stipend: ₹21,000 - ₹27,000/month
What we offer
- Internet allowance.
- Job offer on successful completion.
- Laptop provided for the internship.
- Pre-placement offer (PPO) for strong performers.
- Informal dress code.
- Mentorship from senior team members.
Duration: 3 months. Start: Within 2 weeks.
Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ironwoodkit IT.