Product Analytics Intern

About us:

Wealth management, mortgage and treasury services each operate as separate lines of business.

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 the US. We do not have many meetings. Most updates happen in writing.

What you'll do:

• Analyse funnel drop-offs and summarise findings in a one-page note.
• Check numbers across sources and flag mismatches before reports go out.
• Create charts and short slide decks for the monthly review call.
• Track marketing campaign results using Google Analytics 4 data.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Maintain the data dictionary and keep dashboard filters up to date.

Requirements:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Based in the US for the duration of the internship.
• A sample dashboard or analysis project you can share.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Duration: 12 weeks

Start date: Summer 2027

Stipend: $29.00 - $38.00/hr

Perks:

• Company laptop.
• Return offer opportunities.
• Flexible hours.

Send us your resume. No cover letter needed.

Duration: 12 weeks. Start: Summer 2027.

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