Excel & Data Analysis Intern

Internship details

Remote internship for a student who likes spreadsheets and is not scared of messy data. Selected intern's day-to-day responsibilities include:

1. Answer ad hoc data requests from sales and support within a day or two.

2. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

3. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

4. Create charts and short slide decks for the monthly review call.

5. Build and update dashboards in Power BI, Tableau or Looker Studio

Skill(s) required: Data Analytics, Power BI, MS-Excel, Google Sheets, SQL, English Proficiency (Written), Looker Studio

Who should apply

1. Based in Sri Lanka

2. Available for the full internship period

3. Own laptop and a reliable internet connection

Stipend: LKR 40,000 - LKR 49,000 per month

Duration: 4 months

Start date: Immediately

Perks: Pre-placement offer (PPO) for strong performers, Laptop provided for the internship, Mentorship from senior team members

Number of openings: 2

About Colombo Management Consultants

Travel is regional, usually driving distance, and rarely more than two nights a week.

We look at every application, usually within a week.

Duration: 4 months. Start: Immediately.

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