Insight Analyst Intern

Who we are:

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 role:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. The internship is fully remote. Interns join our New York City team on daily calls and get a named mentor. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET. We talk mostly in Slack and hop on quick calls when something needs discussing.

Day to day:

• Track marketing campaign results using Google Analytics 4 data.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Join a weekly call with the analytics lead to review your work.

Requirements:

• Available for the full internship period.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Must be able to follow up on data requests without constant reminders.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.

What you'll learn:

• Presenting numbers in a way non-technical people can act on.
• Certificate, letter of recommendation and flexible hours.

Duration: 10-12 weeks

Start date: Jun 2027

Stipend: €2,350 - €2,700 monthly

Perks:

• Possibility of a full-time offer.
• Certificate of completion.
• Letter of recommendation.
• Online learning budget.
• Paid public holidays.
• Mentorship.

Due to the number of applications, only shortlisted candidates will be contacted.

Duration: 10-12 weeks. Start: Jun 2027.

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