About the role

  • Data Analytics Intern supporting Agency Operations at Toyota Insurance by migrating to AWS Athena. Involves SQL queries, dashboard updates, and operational insights for efficiency.

Responsibilities

  • Support the development and maintenance of databases using AWS Athena and other AWS tools.
  • Write, optimize, and troubleshoot SQL queries for data extraction and analysis.
  • Assist in building, updating, and automating dashboards in Power BI.
  • Perform data cleaning, validation, and transformation using advanced Excel functions.
  • Collaborate with the Commission team to prepare monthly and ad‑hoc reporting.
  • Analyze trends and provide insights to support operational decision‑making.
  • Document processes, data flows, and reporting procedures.
  • Support various projects within the Operations department as needed.

Requirements

  • Currently pursuing a degree in Data Analytics, Computer Science, Information Systems, Business Analytics, or a related field.
  • Experience with SQL (basic to intermediate query writing required).
  • Familiarity with AWS services, especially Athena (preferred but not required if willing to learn).
  • Strong Power BI skills (building visuals, dashboards, data modeling).
  • Advanced Excel skills include VLOOKUP/XLOOKUP, pivot tables, formulas, and data tools.
  • Basic programming knowledge (Python or similar is a plus).
  • Strong analytical thinking and attention to detail.
  • Ability to manage multiple tasks and meet deadlines.

Benefits

  • Hands-on corporate experience
  • Knowledge Café (corporate training courses)

Job title

Data Analytics Intern

Job type

Experience level

Entry level

Salary

$20 - $24 per hour

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job