Business Analytics Intern

About us

Founded as a farmers' mutual in 1920, the company is now one of the larger mutual insurers in Sri Lanka.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote position. Most of the team is in Jaffna, but nobody is required to come in. We keep meetings to a minimum and work mostly async. You get a company laptop and a headset before you start.

Responsibilities

• Build and update dashboards in Power BI, Tableau or Looker Studio
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Join a weekly call with the analytics lead to review your work
• Check numbers across sources and flag mismatches before reports go out
• Document metric definitions so everyone calculates churn and conversion the same way
• Track marketing campaign results using Google Analytics 4 data
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

Requirements

• Undergraduates or recent graduates in IT, computer science, management or a related field
• Own laptop and a reliable internet connection
• Clear written English for reports and status updates
• Must be able to follow up on data requests without constant reminders
• Some familiarity with Power BI or Tableau, even from a course or certification

Nice to have

• Python with pandas for data cleaning
• Prior project with real business data from a college club, family business or freelance client
• Google Data Analytics or Microsoft PL-300 certification

What you get out of it

• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening
• Presenting numbers in a way non-technical people can act on
• Certificate, letter of recommendation and flexible hours

Duration: 4 months

Start date: Immediately

Stipend: LKR 42,000 - LKR 44,000 per month

Perks

• Performance bonus
• Internet allowance
• Pre-placement offer (PPO) for strong performers

Please submit your CV in English.

Duration: 4 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Island Mutual Insurance (Pvt) Ltd.