Data Analyst Intern

About Coalloft

Small projects are welcome, including one-day workshops and short assessments. Training starts with a two-week bootcamp, then continues on the job.

The internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. We are headquartered in Los Angeles and have been hiring remotely since 2020. You will intern remotely with our team in Los Angeles. We have hosted remote interns from several countries before. Our standups are at 9:00 AM Pacific.

Day to day

• Document metric definitions so everyone calculates churn and conversion the same way
• Maintain the data dictionary and keep dashboard filters up to date
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out
• Create charts and short slide decks for the monthly review call

Requirements

• Women starting or restarting their careers are encouraged to apply
• Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026, 2027 or 2028 batch)
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Basic SQL, enough to write SELECT queries with joins and filters
• Available 20 to 40 hours a week, Monday to Friday
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028
• Laptop with Excel or Google Sheets and a stable internet connection
• Comfort with numbers and strong attention to detail

Preferred

• Python with pandas for data cleaning
• Knowledge of basic statistics such as medians, percentiles and correlation
• Google Data Analytics or Microsoft PL-300 certification

What you'll learn

• You will build at least one dashboard that managers use every week
• Presenting numbers in a way non-technical people can act on
• Top interns are considered for a junior analyst opening

Duration: 3 months

Start date: Immediately

Stipend: $400 - $550/month

What we offer

• Pre-placement offer (PPO) for strong performers
• Internet allowance
• Job offer on successful completion
• Flexible work hours

Duration: 3 months. Start: Immediately.

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