Data Analyst Intern

More than 9,000 organisations use our HR and payroll suite, from regional hospitals to school districts. Product, engineering and support teams work out of offices in New York City, New York and two nearshore delivery centres. Most engineers work remotely and come into the office one week a quarter for planning.

The internship

Piedmont Data needs a data analytics intern to build reports and dashboards for the Growth Analytics team. 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. Clear written English is a must, as the team works across time zones.

Day to day

• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Check numbers across sources and flag mismatches before reports go out.
• 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.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Create charts and short slide decks for the monthly review call.

Requirements

• Based in Colombia for the duration of the internship.
• Available for the full internship period.
• Must be able to follow up on data requests without constant reminders.
• Comfort with numbers and strong attention to detail.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Clear written English for reports and status updates.
• Basic SQL, enough to write SELECT queries with joins and filters.

Duration: 4 months

Start date: Immediately

Stipend: $750 - $800/month

Perks

• Certificate of completion.
• Paid public holidays.
• Company laptop.
• Internet allowance.
• Mentorship.

Please submit your CV in English.

Duration: 4 months. Start: Immediately.

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