Business Analyst Intern

About Glenmark Labs:

Small accounting firms in Colorado use our engagement letter and e-signature tool, and most heard about us from a colleague.

The internship:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across the US.

Day to day:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Create charts and short slide decks for the monthly review call.
• Maintain the data dictionary and keep dashboard filters up to date.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Check numbers across sources and flag mismatches before reports go out.

Who can apply:

• Available 40 hours a week for the full internship.
• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Must be able to follow up on data requests without constant reminders.
• Comfort with numbers and strong attention to detail.
• Laptop with Excel or Google Sheets and a stable internet connection.
• A sample dashboard or analysis project you can share.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.

What you'll learn:

• You will build at least one dashboard that managers use every week.
• How business metrics like CAC, churn and retention are actually calculated.

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $29.50-$32.50 per hour

What we offer:

• Paid sick time.
• Mentorship from a dedicated buddy and manager.
• Learning and development stipend.
• Return offer opportunities.

Applications are reviewed as they come in.

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

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Glenmark Labs Inc..