Product Analytics Intern (Remote)

Healthcare construction, including occupied hospital renovations with infection control, is a specialty. The concrete division pours foundations, slabs, tilt-up walls and site paving. OSHA 30 is required for superintendents and paid for by the company.

About the role

Chestnutspring Construction needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Remote, open to candidates across the US. Most of our work is async, and meetings are kept short. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day

Answer ad hoc data requests from sales and support within a day or two. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Document metric definitions so everyone calculates churn and conversion the same way. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query. Track marketing campaign results using Google Analytics 4 data.

Who can apply

Available 40 hours a week for the full internship. Currently enrolled in a bachelor's or master's program, graduating 2027. Authorized to work in the US. CPT and OPT candidates are welcome to apply. Available 20 to 40 hours a week, Monday to Friday. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts. Clear written English for reports and status updates. A sample dashboard or analysis project you can share.

What you'll learn

Writing SQL against a real production warehouse. You will build at least one dashboard that managers use every week. Presenting numbers in a way non-technical people can act on. Certificate, letter of recommendation and flexible hours.

Duration: 3 months

Start date: Immediately

Stipend: $31.50 - $35.50 per hour

What we offer

Paid sick time. Return offer opportunities. Home office setup stipend. Final presentation to leadership. Learning and development stipend.

This position requires a background check.

Duration: 3 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Chestnutspring Construction, Inc..