Analytics Intern

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

About the internship

Lee Community Bank is hiring an Analytics Intern for Immediately. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. You can work from home anywhere in the US. We have no office requirement. We do not have many meetings. Most updates happen in writing.

What you'll do

• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Maintain the data dictionary and keep dashboard filters up to date
• Check numbers across sources and flag mismatches before reports go out

What we're looking for

• Currently enrolled in a bachelor's or master's program, graduating 2027
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Basic SQL, enough to write SELECT queries with joins and filters
• Available 20 to 40 hours a week, Monday to Friday
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Comfort with numbers and strong attention to detail

Preferred qualifications

• Prior project with real business data from a college club, family business or freelance client
• Experience with Google Analytics 4 or Mixpanel

What you get out of it

• Writing SQL against a real production warehouse
• Certificate, letter of recommendation and flexible hours
• Presenting numbers in a way non-technical people can act on

Program dates: Immediately, 3 months.

Pay: $34.50 - $35.00 per hour

What we offer

• Home office setup stipend
• Return offer opportunities
• Mentorship from a dedicated buddy and manager
• Company laptop
• Paid sick time
• Final presentation to leadership

Send us your resume. No cover letter needed.

Duration: 3 months. Start: Immediately.

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