Product Analytics Intern

We run one of the larger SaaS platforms for commercial insurance carriers, processing millions of policy transactions a year. Annual releases gave way to two-week sprints years ago, and the platform now handles over 200 million API calls a day. On-call rotates weekly and pays a flat stipend whether or not the pager goes off.

Internship overview:

Frisco Data is hiring a Product Analytics Intern for Jan 2027. Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in Frisco once a quarter, travel covered. Few meetings, lots of written updates.

What you'll do:

• Maintain the data dictionary and keep dashboard filters up to date
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Track marketing campaign results using Google Analytics 4 data
• Analyse funnel drop-offs and summarise findings in a one-page note
• Answer ad hoc data requests from sales and support within a day or two
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Check numbers across sources and flag mismatches before reports go out

Basic qualifications:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Laptop with Excel or Google Sheets and a stable internet connection
• Must be able to follow up on data requests without constant reminders
• Some familiarity with Power BI or Tableau, even from a course or certification

Preferred qualifications:

• Familiarity with DAX in Power BI

What you'll learn:

• How business metrics like CAC, churn and retention are actually calculated
• Writing SQL against a real production warehouse

Program dates: Jan 2027, 16 weeks.

Intern pay: $32.00-$34.50 an hour

Benefits for interns:

• Paid company holidays
• Paid sick time
• Intern events and speaker sessions (virtual)

Frisco Data is an Equal Opportunity Employer, including disability and protected veteran status.

Duration: 16 weeks. Start: Jan 2027.

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