Analytics Intern

We support about 60 local businesses, most within 30 minutes of the office. No call center and no offshore help desk. When clients call, one of us picks up. Company vehicles are provided for techs who drive to client sites.

Overview:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Fully remote. You can work from anywhere in the US. Flexible schedule. We have one team call a day, usually in the morning. Equipment is provided, including a laptop.

Responsibilities:

• Analyse funnel drop-offs and summarise findings in a one-page note.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Maintain the data dictionary and keep dashboard filters up to date.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Answer ad hoc data requests from sales and support within a day or two.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Requirements:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.
• Must be able to follow up on data requests without constant reminders.
• Clear written English for reports and status updates.

Duration: 6 months

Start date: Feb 2027

Stipend: $30.00-$38.50 per hour

Perks:

• Flexible hours.
• Paid sick time.
• Company laptop.
• Mentorship from a dedicated buddy and manager.
• Paid company holidays.
• Learning and development stipend.

Duration: 6 months. Start: Feb 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at St. Paul Computer Services LLC.