Excel & Data Analysis Intern

About us:

No pitching for work we cannot actually handle. Deadlines move when clients change their minds, so plans have some slack built in.

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. You can work from home anywhere in India. We have no office requirement. We do not have many meetings. Most updates happen in writing. Please make sure you have dependable internet and backup power.

Responsibilities:

Answer ad hoc data requests from sales and support within a day or two. Document metric definitions so everyone calculates churn and conversion the same way. Create charts and short slide decks for the monthly review call. Prepare the weekly MIS report and send it to the team lead every Monday. Join a weekly call with the analytics lead to review your work. 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.

Requirements:

Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2028 batch). Are available for a full-time work from home internship for the entire duration. Comfort with numbers and strong attention to detail. Must be able to follow up on data requests without constant reminders. Laptop with Excel or Google Sheets and a stable internet connection. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts. Clear written English for reports and status updates. Basic SQL, enough to write SELECT queries with joins and filters.

Preferred:

Google Data Analytics or Microsoft PL-300 certification.

What you'll learn:

Writing SQL against a real production warehouse. Certificate, letter of recommendation and flexible hours. Top interns are considered for a junior analyst opening.

Duration: 2 months

Start date: Jan 2027

Stipend: ₹19,000-₹21,000 per month

Perks:

Flexible work hours. Performance bonus. Certificate. Free access to paid learning courses. Job offer on successful completion.

Duration: 2 months. Start: Jan 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Fernport.