Business Analyst 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.

About the role:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote internship with a team based in Birmingham. The stipend is paid at the end of each month. You will need at least 4 hours of overlap with US Central time.

What you'll do:

• Track marketing campaign results using Google Analytics 4 data
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Analyse funnel drop-offs and summarise findings in a one-page note
• Create charts and short slide decks for the monthly review call
• Prepare the weekly MIS report and send it to the team lead every Monday

Who can apply:

• Women wanting to start or restart their career can also apply
• Have their own laptop and a reliable internet connection
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Some familiarity with Power BI or Tableau, even from a course or certification
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028
• Basic SQL, enough to write SELECT queries with joins and filters
• Available 20 to 40 hours a week, Monday to Friday
• Must be able to follow up on data requests without constant reminders

Preferred:

• Python with pandas for data cleaning
• Google Data Analytics or Microsoft PL-300 certification
• Knowledge of basic statistics such as medians, percentiles and correlation

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
• Presenting numbers in a way non-technical people can act on
• Certificate, letter of recommendation and flexible hours

Duration: 2 months

Start date: Immediately

Stipend: ₹42,000 to ₹50,000/month

What we offer:

• Pre-placement offer (PPO) for strong performers
• Job offer on successful completion
• Performance bonus

We are reviewing applications as they arrive, so apply early.

Duration: 2 months. Start: Immediately.

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