Analytics Intern, Summer 2027

Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer.

Internship overview:

Kilnbank IT is hiring an Analytics Intern for Summer 2027. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Fully remote. You can work from anywhere in the US. Flexible schedule. We have one team call a day, usually in the morning.

Your projects:

• Track marketing campaign results using Google Analytics 4 data
• Maintain the data dictionary and keep dashboard filters up to date
• Analyse funnel drop-offs and summarise findings in a one-page note
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Answer ad hoc data requests from sales and support within a day or two
• Prepare the weekly MIS report and send it to the team lead every Monday

Who you are:

• Currently enrolled in a bachelor's or master's program, graduating 2028
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Available 20 to 40 hours a week, Monday to Friday
• Laptop with Excel or Google Sheets and a stable internet connection
• Must be able to follow up on data requests without constant reminders

Preferred qualifications:

• Knowledge of basic statistics such as medians, percentiles and correlation
• Experience with Google Analytics 4 or Mixpanel
• Prior project with real business data from a college club, family business or freelance client

What you'll learn:

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

Program dates: Summer 2027, 12 weeks.

Intern pay: $32.50 - $33.00 an hour

Benefits for interns:

• Intern events and speaker sessions (virtual)
• Final presentation to leadership
• Company laptop

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Duration: 12 weeks. Start: Summer 2027.

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