Product Analytics Intern - Spring 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 a Product Analytics Intern for Spring 2027. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. This role is fully remote within the US.

Responsibilities

• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Analyse funnel drop-offs and summarise findings in a one-page note
• Join a weekly call with the analytics lead to review your work
• Create charts and short slide decks for the monthly review call

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
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• A sample dashboard or analysis project you can share
• Laptop with Excel or Google Sheets and a stable internet connection

Nice to have

• Experience with Google Analytics 4 or Mixpanel
• Familiarity with DAX in Power BI
• Prior project with real business data from a college club, family business or freelance client

What you get out of it

• Certificate, letter of recommendation and flexible hours
• Top interns are considered for a junior analyst opening

Program dates: Spring 2027, 16 weeks.

Compensation: $32.50 - $35.50 per hour

What we offer

• Company laptop
• Mentorship from a dedicated buddy and manager
• Final presentation to leadership
• Learning and development stipend
• Return offer opportunities

We are an equal opportunity employer. If you need an accommodation during the application process, let us know.

Duration: 16 weeks. Start: Spring 2027.

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