Data Analyst Intern

Who we are:

Clients include hospitals, school districts and local governments. We represent small businesses in contracts, employment disputes, real estate and succession planning. Founded in 2011, we now have 140 employees. Billable target for associates is 1,800 hours.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. Fully remote. You can work from anywhere in the US. Weekday working hours, with room to shift your day when needed. Good written English matters here, since most updates are written.

Responsibilities:

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Join a weekly call with the analytics lead to review your work
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Track marketing campaign results using Google Analytics 4 data
• Create charts and short slide decks for the monthly review call

Who can apply:

• Available 40 hours a week for the full internship
• Based in the US for the duration of the internship
• Available 20 to 40 hours a week, Monday to Friday
• Comfort with numbers and strong attention to detail
• Basic SQL, enough to write SELECT queries with joins and filters
• Must be able to follow up on data requests without constant reminders
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Some familiarity with Power BI or Tableau, even from a course or certification

What you get out of it:

• Presenting numbers in a way non-technical people can act on
• How business metrics like CAC, churn and retention are actually calculated

Duration: 6 months

Start date: Immediately

Stipend: $29.00-$41.00 per hour

What we offer:

• Final presentation to leadership
• Paid sick time
• Return offer opportunities
• Flexible hours
• Company laptop
• Paid company holidays

Most hires start within two to three weeks of an offer.

Duration: 6 months. Start: Immediately.

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