Business Intelligence Intern

About Woolpost

Government clients use us for program management, grant administration and audits. The practice also handles change management and end-user training for large system rollouts.

The internship

Woolpost needs a data analytics intern to build reports and dashboards for the Business Intelligence team. Remote, open to candidates across the US. Standard office hours, Monday to Friday, with flexibility around them.

Day to day

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Track marketing campaign results using Google Analytics 4 data
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Answer ad hoc data requests from sales and support within a day or two
• Create charts and short slide decks for the monthly review call
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Prepare the weekly MIS report and send it to the team lead every Monday

What we're looking for

• Based in the US for the duration of the internship
• Available 40 hours a week for the full internship
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028
• 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

What you'll learn

• Certificate, letter of recommendation and flexible hours
• How business metrics like CAC, churn and retention are actually calculated
• You will build at least one dashboard that managers use every week
• Top interns are considered for a junior analyst opening

Duration: 6 months

Start date: Mar 2027

Stipend: $33.00 - $44.50 per hour

What we offer

• Flexible hours
• Intern events and speaker sessions (virtual)
• Company laptop
• Home office setup stipend
• Return offer opportunities
• Final presentation to leadership

This position requires a background check.

Duration: 6 months. Start: Mar 2027.

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