Business Intelligence Intern, Summer 2027

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

Internship overview

Lee Community Bank is hiring a Business Intelligence Intern for Summer 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. This role is fully remote within the US. We do not have many meetings. Most updates happen in writing.

Responsibilities

• Analyse funnel drop-offs and summarise findings in a one-page note
• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Document metric definitions so everyone calculates churn and conversion the same way
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Create charts and short slide decks for the monthly review call
• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work

Basic qualifications

• 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
• Must be able to follow up on data requests without constant reminders
• Clear written English for reports and status updates
• Basic SQL, enough to write SELECT queries with joins and filters

Nice to have

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

What you'll learn

• Certificate, letter of recommendation and flexible hours
• How business metrics like CAC, churn and retention are actually calculated
• Writing SQL against a real production warehouse

Program dates: Summer 2027, 10-12 weeks.

Intern pay: $30.50 to $33.00 per hour

Benefits for interns

• Intern events and speaker sessions (virtual)
• Return offer opportunities
• Learning and development stipend
• Company laptop

Lee Community Bank is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

We are unable to sponsor visas for this position.

Duration: 10-12 weeks. Start: Summer 2027.

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