Excel & Data Analysis Intern

More than 9,000 organisations use our HR and payroll suite, from regional hospitals to school districts. Our engineering group is split into roughly 60 product teams, each owning its services end to end, with on-call shared across time zones. We started in 1996 and have grown to about 270 people.

About the role:

Chandrasekara Apps needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Remote within Sri Lanka. The team meets in Colombo once a quarter, travel covered. Few meetings, lots of written updates.

Day to day:

• Maintain the data dictionary and keep dashboard filters up to date
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Answer ad hoc data requests from sales and support within a day or two
• Check numbers across sources and flag mismatches before reports go out
• Track marketing campaign results using Google Analytics 4 data
• 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
• Prepare the weekly MIS report and send it to the team lead every Monday

Requirements:

• Based in Sri Lanka
• Undergraduates or recent graduates in IT, computer science, management or a related field
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028
• Available 20 to 40 hours a week, Monday to Friday
• Basic SQL, enough to write SELECT queries with joins and filters
• Must be able to follow up on data requests without constant reminders

Bonus points:

• Experience with Google Analytics 4 or Mixpanel

What you get out of it:

• How business metrics like CAC, churn and retention are actually calculated
• Certificate, letter of recommendation and flexible hours
• Top interns are considered for a junior analyst opening
• Writing SQL against a real production warehouse

Duration: 4 months

Start date: Within 2 weeks

Stipend: LKR 40,000 - LKR 49,000 pcm

What we offer:

• Internet allowance
• Certificate
• Mentorship from senior team members

Please submit your CV in English.

Duration: 4 months. Start: Within 2 weeks.

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