Business Analyst Intern

Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer.

About the internship:

Kilnbank IT is hiring a Business Analyst Intern for Jan 2027. Kilnbank IT needs a data analytics intern to build reports and dashboards for the Growth Analytics team. Remote, open to candidates across the US. We send you a laptop and the accessories you need on day one.

Your projects:

• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Maintain the data dictionary and keep dashboard filters up to date.
• Answer ad hoc data requests from sales and support within a day or two.
• Check numbers across sources and flag mismatches before reports go out.

Basic qualifications:

• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028.
• A sample dashboard or analysis project you can share.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification.
• Prior project with real business data from a college club, family business or freelance client.

What you'll learn:

• Top interns are considered for a junior analyst opening.
• Presenting numbers in a way non-technical people can act on.

Program dates: Jan 2027, 16 weeks.

Pay: $32.50 to $37.00 per hour

Benefits for interns:

• Final presentation to leadership.
• Learning and development stipend.
• Home office setup stipend.
• Flexible hours.
• Mentorship from a dedicated buddy and manager.
• Company laptop.

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

New hires usually start two to three weeks after accepting an offer.

Duration: 16 weeks. Start: Jan 2027.

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