Business Analytics Intern

About Arava Behavioral Health:

The psychiatric team includes psychiatrists and psychiatric nurse practitioners who handle medication management. Our community mental health centre offers crisis services, case management, psychiatry and therapy. Clinicians chart in SimplePractice, and most notes are done the same day.

Overview:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Our headquarters is in Jerusalem, and about a third of the team works remotely from other countries. The internship is fully remote. Interns join our Jerusalem team on daily calls and get a named mentor. Core hours are 10:00 to 15:00 CET. Reliable internet and a power backup are a must.

Responsibilities:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Check numbers across sources and flag mismatches before reports go out.
• Maintain the data dictionary and keep dashboard filters up to date.

Requirements:

• Available for at least 30 hours a week, work from home.
• Own a laptop and have stable internet at home, ideally with a UPS backup.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Must be able to follow up on data requests without constant reminders.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.

Bonus points:

• Prior project with real business data from a college club, family business or freelance client.

Duration: 2 months

Start date: Immediately

Stipend: $250 - $300 per month

Perks:

• Laptop provided for the internship.
• Pre-placement offer (PPO) for strong performers.
• Informal dress code.
• Mentorship from senior team members.
• Performance bonus.

Duration: 2 months. Start: Immediately.

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