Data Analyst Intern

Certifications include ISO 27001 and SOC 2 Type II, and we hold partner status with Microsoft, Cisco and VMware. Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer. Tickets live in ConnectWise and everyone logs time to the quarter hour.

About the role

This role is about accuracy first. A wrong number in a report is worse than a late one. You can work from home anywhere in the US. We have no office requirement. Normal business hours, Monday to Friday, with some flexibility.

Responsibilities

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Join a weekly call with the analytics lead to review your work
• Maintain the data dictionary and keep dashboard filters up to date
• Analyse funnel drop-offs and summarise findings in a one-page note
• Create charts and short slide decks for the monthly review call

Who can apply

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Must be able to follow up on data requests without constant reminders
• 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

Bonus points

• Familiarity with DAX in Power BI

What you'll learn

• 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: 10-12 weeks

Start date: Summer 2027

Stipend: $30.00 - $36.00 per hour

Perks

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

Applicants must be authorized to work in the U.S.

Duration: 10-12 weeks. Start: Summer 2027.

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