Data Analyst Intern

About Spruceforge:

Most of what we build is back-office software for property managers, including lease tracking, work orders and tenant payments. Releases go out Tuesday mornings, never on Fridays.

The internship:

Spruceforge needs a data analytics intern to build reports and dashboards for the Business Intelligence team. Remote, open to candidates across the US. You get a company laptop and a headset before you start.

Day to day:

• Track marketing campaign results using Google Analytics 4 data
• Prepare the weekly MIS report and send it to the team lead every Monday
• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• 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

Requirements:

• Based in the US for the duration of the internship
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028
• Available 40 hours a week for the full internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• A sample dashboard or analysis project you can share

Nice to have:

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

What you'll learn:

• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening

Duration: 16 weeks

Start date: Jan 2027

Stipend: $29.50-$34.00/hr

Perks:

• Paid sick time
• Home office setup stipend
• Paid company holidays
• Return offer opportunities
• Final presentation to leadership
• Mentorship from a dedicated buddy and manager

Please include a short note on why this role interests you.

Duration: 16 weeks. Start: Jan 2027.

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