Excel & Data Analysis Intern

Grant reporting covers dozens of federal, state and private funders, each with its own outcomes. Since 1929, the organisation has grown from one shelter into a network of sites across Alabama.

Overview

Birmingham Community Services needs a data analytics intern to build reports and dashboards for the Business Intelligence team. This is a remote internship. You will work with our team in Birmingham, and the stipend is paid monthly in USD. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT. You will need a stable internet connection and a backup power source (UPS or inverter).

Responsibilities

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Maintain the data dictionary and keep dashboard filters up to date
• Create charts and short slide decks for the monthly review call
• Document metric definitions so everyone calculates churn and conversion the same way
• Check numbers across sources and flag mismatches before reports go out
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery

Who can apply

• Women wanting to start or restart their career can also apply
• Are available for a full-time work from home internship for the entire duration
• Available 20 to 40 hours a week, Monday to Friday
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share

What you'll learn

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

Duration: 3 months

Start date: Within 2 weeks

Stipend: $500 - $550 monthly

What we offer

• Flexible work hours
• Free access to paid learning courses
• Job offer on successful completion

Duration: 3 months. Start: Within 2 weeks.

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