Product Analytics Intern

Across New York, the company runs 14 branch offices and a central depot for hardware staging and imaging. Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer. Lunch is usually whatever is closest to the client site.

About the internship

Lilacbench is hiring a Product Analytics Intern for Spring 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote position. Most of the team is in New York City, but nobody is required to come in. Most of our work is async, and meetings are kept short.

What you'll do

• Check numbers across sources and flag mismatches before reports go out.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• 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.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Basic qualifications

• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028.
• Must be able to follow up on data requests without constant reminders.
• A sample dashboard or analysis project you can share.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Clear written English for reports and status updates.

Nice to have

• Familiarity with DAX in Power BI.
• Knowledge of basic statistics such as medians, percentiles and correlation.

What you'll learn

• How business metrics like CAC, churn and retention are actually calculated.
• Presenting numbers in a way non-technical people can act on.
• Certificate, letter of recommendation and flexible hours.

Program dates: Spring 2027, 16 weeks.

Intern pay: $36.50 - $43.50/hr

Perks

• Intern events and speaker sessions (virtual)
• Home office setup stipend.
• Paid sick time.
• Learning and development stipend.
• Final presentation to leadership.
• Paid company holidays.

This position requires a background check.

Duration: 16 weeks. Start: Spring 2027.

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