Power BI Intern (Work From Home)

Capstanwell Lending is an independent wealth management firm advising families, business owners and retirees. Clients pay a flat annual fee, and the firm takes no commissions. Still family owned, 55 years on. Compliance reviews outgoing client email, so expect to write carefully.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. Fully remote. You can work from anywhere in India. Normal working hours, Monday to Friday. A stable internet connection and a backup power option are required.

What you'll do

• Document metric definitions so everyone calculates churn and conversion the same way.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Maintain the data dictionary and keep dashboard filters up to date.
• Track marketing campaign results using Google Analytics 4 data.
• Create charts and short slide decks for the monthly review call.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.

Who can apply

• Women returning to work after a career break are welcome to apply.
• Available for a full-time (work from home) internship for the full duration.
• Are able to join within 15 days.
• Have their own laptop and a reliable internet connection.
• Available 20 to 40 hours a week, Monday to Friday.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Clear written English for reports and status updates.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028.

Bonus points

• Python with pandas for data cleaning.
• Experience with Google Analytics 4 or Mixpanel.
• Familiarity with DAX in Power BI.

What you'll learn

• You will build at least one dashboard that managers use every week.
• 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: Dec 2026

Stipend: ₹21,000-₹23,000 monthly

What we offer

• Certificate.
• 5 days a week.
• Flexible work hours.
• Pre-placement offer (PPO) for strong performers.
• Laptop provided for the internship.
• Internet allowance.

Duration: 3 months. Start: Dec 2026.

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