Insight Analyst Intern

More than 9,000 organisations use our HR and payroll suite, from regional hospitals to school districts. We're looking for an Insight Analyst Intern. Piedmont Data needs a data analytics intern to build reports and dashboards for the Analytics team. We are headquartered in New York City and have been hiring remotely since 2020. The internship is fully remote. Interns join our New York City team on daily calls and get a named mentor. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET. We use Slack, Notion and Google Meet. Cameras on for team calls.

You'll help with

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Create charts and short slide decks for the monthly review call
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Track marketing campaign results using Google Analytics 4 data

About you

• Eligible to work in Colombia
• Currently enrolled in a bachelor's or master's degree, graduating 2027
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027
• Available 20 to 40 hours a week, Monday to Friday
• Basic SQL, enough to write SELECT queries with joins and filters

4 months, starting immediately. Stipend: COP 3,500,000 to COP 3,800,000 per month.

Perks: Online learning budget, Internet allowance, Mentorship, Company laptop, Letter of recommendation, Paid public holidays.

We will only contact shortlisted applicants.

Duration: 4 months. Start: Immediately.

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