Data Analytics Intern

Who are we:

Toyota Insurance is a brand name of Toyota Insurance Management Solutions USA, LLC (TIMS). We are an independent agency specializing in property and casualty insurance for Toyota vehicle owners. We offer insurance through our trusted carrier partners to provide coverage for your Toyota vehicle, home and other assets. Our mission is to improve the Toyota ownership experience by improving the insurance experience.

Why Toyota Insurance? 

At Toyota Insurance, our goal is to grow talent from great to greater! Your internship will include hands-on corporate experience plus our Knowledge Café (corporate training courses). Our team of innovators are world changers looking to disrupt the insurance industry. We envision the impossible and use our intellectual equity to make it possible! Don’t delay, join our team today!

Job Overview:

The Data Analytics Intern will support the Agency Operations Department by helping shift from manual Nexsure reporting to more efficient, query‑based analytics using AWS Athena. The intern will assist with SQL queries, commission statement analysis, and dashboard creation to improve accuracy, streamline reporting, and save time across Operations.

Intern Job 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.

Required Education and Experience:

• Currently pursuing a degree in Data Analytics, Computer Science, Information Systems, Business Analytics, or a related field.

Required Knowledge, Skills, and Abilities:

• 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.

Preferred Qualifications

• Experience working with large datasets.
• Understanding of data warehousing concepts.
• Familiarity with cloud-based data tools or BI platforms.

What You Will Gain

• Hands-on experience with enterprise-level data tools and AWS technologies.
• Real-world analytics skills and reporting experience.
• Exposure to operations and commission structures within the organization.
• Opportunity to contribute to meaningful process improvements.

Compensation

• Base Salary: $20-$24 based on skills and experience
• Minimum experience: Entry-level candidate; current college junior or senior, or pursuing a master’s degree.

Position Type/Expected Hours of work/Compensation:

This is a full-time position for the months of May - August. Days and hours of work are Monday through Friday, 9:00 AM – 5:00 PM. 

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Work Authorization:

Applicants must be authorized to work for any employer in the U.S. This position does not offer sponsorship or the transfer of sponsorship of employment Visa.

Learn More: 

Visit our website Toyota Auto Insurance | Toyota Auto Insurance (toyotaims.com) to learn more about our company culture and career opportunities.

FLSA Job Status:                    ☐ Exempt                           ☒Non-Exempt

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

An Equal Opportunity Employer: Female / Minority / Disability / Protected Veteran / Sexual Orientation / Gender Identity

'EEOC is The Law' Information poster: https://www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf

Candidates must already hold work eligibility for the United States.

Salary : $20 - $24