Data Analytics Intern

Summary: Toyota Insurance is an independent agency specializing in property and casualty insurance for Toyota vehicle owners. The Data Analytics Intern will support the Agency Operations Department by helping shift from manual reporting to more efficient, query‑based analytics using AWS Athena. 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 Qualifications: - 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) - 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: - Familiarity with AWS services, especially Athena (preferred but not required if willing to learn) - Experience working with large datasets - Understanding of data warehousing concepts - Familiarity with cloud-based data tools or BI platforms Required Skills: SQL, AWS Athena, Power BI, Excel VLOOKUP, Excel XLOOKUP, Excel pivot tables, Excel formulas, Excel data tools, Python, Data Analytics, Data Cleaning, Data Validation, Data Transformation, Analytical Thinking, Task Management