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.
Analytics Manager managing analytics solutions and delivering insights for AI & Data Engineering team. Collaborating across teams and handling client engagements in Bangalore, India.
Senior Data Analyst collaborating with teams to generate data - driven insights for financial health strategy at Monzo. Focused on improving customer support and operational processes.
Senior Data Analyst managing data pipelines and Looker solutions at Kpler. Collaborating across teams to shape data strategies for commercial and strategic decision - making.
Junior Data Analyst supporting data insights and dashboard creation for Immediate's popular consumer brands. Collaborating within a hybrid environment and learning through hands - on experience.
Apprentice Revenue operations data analyst at A2MAC1 analyzing and integrating business operations data. Designing data models, workflows, and dashboards for actionable insights in a hybrid environment.
Quantitative Analyst Climate at Rabobank analyzing climate - related risks and producing sustainability insights. Collaborating on climate risk assessments with a focus on geospatial models and analytics.
Junior BI Data Analyst creating crucial information products for decision - making at Rabobank. Collaborating in an agile team and delivering insights on strategic KPIs in the Retail domain.
Sustainability Data Analyst managing the collection of sustainability data and assisting corporate real estate sustainability initiatives. Contributing to innovative data - driven solutions for sustainability objectives at Sun Life.
Senior Associate in Data Analytics at PwC assisting clients with technology solutions and data analysis. Leading small teams and providing insights using advanced analytics tools.