Insight Analyst Intern

About Holcomb

Dentists, insurance agents and law offices make up most of the client list. We support about 60 local businesses, most within 30 minutes of the office. Tickets live in ConnectWise and everyone logs time to the quarter hour.

The internship

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 Israel. Weekday working hours, with room to shift your day when needed. Equipment is provided, including a laptop.

Day to day

• 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
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Create charts and short slide decks for the monthly review call
• Join a weekly call with the analytics lead to review your work
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Maintain the data dictionary and keep dashboard filters up to date
• Prepare the weekly MIS report and send it to the team lead every Monday

What we're looking for

• Eligible to work in Israel
• Currently enrolled in a bachelor's or master's degree, graduating 2028
• A sample dashboard or analysis project you can share
• Basic SQL, enough to write SELECT queries with joins and filters
• Some familiarity with Power BI or Tableau, even from a course or certification
• Must be able to follow up on data requests without constant reminders
• Available 20 to 40 hours a week, Monday to Friday

Preferred

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

What you get out of it

• 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

Duration: 4 months

Start date: Mar 2027

Stipend: ₪6,500 - ₪7,700 monthly

What we offer

• Paid public holidays
• Online learning budget
• Certificate of completion
• Flexible hours
• Possibility of a full-time offer

Duration: 4 months. Start: Mar 2027.

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