Data ITSM Analyst Intern - Summer 2027

Great American Insurance Company; Cincinnati (OH); Hybrid; USD 28,000 - 34,000; Part time

Benefits offered by this job

Medical, dental, and vision coverage

Wellness plans

Paid time off and holidays

401(k) with company match

Employee stock purchase plan

Commuter benefits

Job summary

Great American Insurance Company is seeking a Data Analytics Intern for Summer 2027 in Cincinnati, OH. You will assist with data analysis and reporting using Snowflake, collaborate to define data requirements, and document processes while presenting insights to stakeholders.

You will also participate in team meetings and lead our Change Advisory Board Meetings (pCAB, dCAB), gaining exposure to data improvements and change opportunities.

Qualifications

• Background in data analytics or a related field.
• Experience with Snowflake or SQL databases is desirable.
• Familiarity with Power BI or Tableau is a plus.
• Strong analytical and problem-solving skills are required.
• Excellent communication and presentation skills expected.

Responsibilities

• Assist with data analysis and reporting using Snowflake and other tools.
• Collaborate with team to gather and understand data requirements.
• Document workflow processes and project progress.
• Present findings and insights to stakeholders.
• Lead Change Advisory Board Meetings weekly (pCAB, dCAB).

Skills

Data analytics

SQL databases

Power BI

Tableau

Analytical thinking

Communication skills

Presentation skills

Collaboration

Education

Pursuing a degree in Data Analytics or related field

Tools

Snowflake

Power BI

Tableau

Job description

Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group's member companies are subsidiaries of American Financial Group. We combine a \"small company\" culture where your ideas will be heard with \"big company\" expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow.At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors.Great American’s culture is built on connection, shared learning, and strong relationships. This is a hybrid role that combines in-office and remote work. Employees are expected to maintain a meaningful on-site presence to support collaboration, relationship building, and business success.The Data team within P&C IT Services is seeking an intern for the summer 2027.Responsibilities:Assist with data analysis and reporting using a combination of ServiceNow, UC4 and SnowflakeCollaborate with team members to gather and understand data requirementsHelp support teams prioritize work focus based on data findingsDocument workflow processes and project progressPresent findings and insights to stakeholdersParticipate in team meetings and contribute to discussions on data improvements and opportunities for changeLead our Change Advisory Board Meetings weekly (pCAB, dCAB)Requirements:Ability to work in the office at minimum three days a week.Education:Pursuing a degree in Data Analytics, Business, Information Technology, Computer Science, or related2029 or 2030 graduation yearExperience/skills:Background in data analytics or a related fieldExperience with Snowflake or other SQL databases is highly desirableFamiliarity with data visualization tools such as Power BI or Tableau is a plusStrong analytical and problem-solving skillsExcellent communication and presentation skillsKeen interest in learning and developing soft skills, such as presenting, collaborating, and documenting workOpen to change and excited about improvement opportunitiesBusiness Unit:Property & Casualty IT ServicesBenefits:We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.*Excludes seasonal employees and interns.