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.

Our Claims IT team is looking for a Technical Analyst Intern to work a hybrid schedule (3 days a week in the office, 2 days remote) out of the Cincinnati office for the summer.

Responsibilities:

- Gathering and analyzing business requirements
-Creating and maintaining documentation such as user stories, process flows, and requirements.

Requirements:

-Junior in college, pursuing a bachelor's or master's in computer science or data analytics

-Ability to read/decipher data models/schema
-Ability to read and write SQL queries
-Involved in application testing
-Proficiency in Microsoft Office suite
-Effective oral, written, and interpersonal communication skills
-Ability to work independently and collaboratively.

Pluses:

-Knowledge of TOAD application
-Data warehouse concepts to include understanding of front-end data entry and back-end data consumption
-SQL Server Management Studio experience
-Ability to read and understand XML
-Knowledge of ETL
-Experience with database systems
-Familiarity with project management software

Business Unit:

Benefits:

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.