Analytics Intern

About Inland Empire Christian School

Inland Empire Christian School is a public school district with more than 40,000 students and 330 employees. As a charter network of 25 schools, the organization runs campuses in several cities. Teachers work 187 days a year, with summers off.

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, open to candidates across the US. Flexible hours with a daily team call in the morning. Communication happens mostly in Slack and short video calls.

Day to day

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Analyse funnel drop-offs and summarise findings in a one-page note
• Answer ad hoc data requests from sales and support within a day or two
• Track marketing campaign results using Google Analytics 4 data

Requirements

• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Available 40 hours a week for the full internship
• Based in the US for the duration of the internship
• Some familiarity with Power BI or Tableau, even from a course or certification
• Comfort with numbers and strong attention to detail
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts

Nice to have

• Knowledge of basic statistics such as medians, percentiles and correlation
• Familiarity with DAX in Power BI
• Experience with Google Analytics 4 or Mixpanel

What you get out of it

• Writing SQL against a real production warehouse
• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening
• You will build at least one dashboard that managers use every week

Duration: 12 weeks

Start date: Spring 2027

Stipend: $33.00-$35.00 per hour

Perks

• Paid company holidays
• Company laptop
• Final presentation to leadership
• Flexible hours
• Mentorship from a dedicated buddy and manager
• Return offer opportunities

Duration: 12 weeks. Start: Spring 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Inland Empire Christian School LLC.