Business Analytics Intern

About Spruceford Partners:

Clients are mostly family-owned manufacturers and distributors in Maine. Small projects are welcome, including one-day workshops and short assessments. Travel runs Monday through Thursday on most projects, with Fridays in the home office.

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. The company is based in South Portland, the US. We are a distributed team spread across a few time zones. You will intern remotely with our team in South Portland. We have hosted remote interns from several countries before. Core hours are 9:00 AM to 1:00 PM US Eastern.

What you'll do:

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Maintain the data dictionary and keep dashboard filters up to date.
• Check numbers across sources and flag mismatches before reports go out.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• 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.

Who can apply:

• Are able to join within 15 days.
• Available for a full-time (work from home) internship for the full duration.
• Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2027 batch)
• Own a laptop and have stable internet at home.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Must be able to follow up on data requests without constant reminders.
• Available 20 to 40 hours a week, Monday to Friday.
• Laptop with Excel or Google Sheets and a stable internet connection.
• A sample dashboard or analysis project you can share.

Duration: 2 months

Start date: Immediately

Stipend: ₹42,000 - ₹45,000 monthly

What we offer:

• Certificate.
• Internet allowance.
• Job offer on successful completion.
• Mentorship from senior team members.
• Pre-placement offer (PPO) for strong performers.

Duration: 2 months. Start: Immediately.

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