Product Data and Compliance Intern - Year Round

Posted 5 Days Ago
Be an Early Applicant
Cincinnati, OH
Internship
Insurance
The Role
Assist in user acceptance testing of underwriting systems, modify Excel workbooks, execute test plans, and verify rate tables. Experience in data reporting preferred.
Summary Generated by Built In

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 diversity and recognize the benefits gained when people from different cultures, backgrounds and experiences work collaboratively to achieve business results. We are intentionally focused on fostering an inclusive culture and know valuing diversity is an essential leadership quality. Our goal is to create a workplace where all employees feel included, empowered and enabled to perform at their best.

Data Reporting and Compliance (DRC) specializes in supporting systems work and regulatory reporting for P&C insurance products. Major responsibilities include statistical reporting, "data call" reporting, user acceptance testing, reporting requirements and implementation, and subject matter expertise for commercial lines processing and data reporting.

The intern program provides college students the opportunity to learn about the insurance industry, as well as experience Great American’s corporate culture that values integrity, leadership, customer focus and accountability.

The Data Reporting & Compliance team is looking for an intern to assist with testing our underwriting systems. This position will be in Cincinnati, OH and offer a hybrid schedule during the school year and will be required to work full-time during the summer.

Essential Job Functions and Responsibilities:

  • Assist in user acceptance testing of our underwriting systems

  • Modify Excel Workbooks formulas and rates

  • Execute test plans (entering policies in our quote and issuance system and checking results)

  • Manually verify rate tables

  • Perform other duties as assigned

Job Requirements:

  • Strong oral and written communication skills.

  • Strong problem-solving skills and analytical skills.

  • High level of attention to detail.

  • Strong planning and organizing skills and can meet deadlines.

  • Experience in Excel including but not limited to Formula manipulation, Filtering & Sorting, Defined Name Ranges, etc.

  • Ability to interpret and create written instructions.

  • Programming and/or SQL knowledge is preferred but not required.

Business Unit:

Property & Casualty Product Data & Compliance

Benefits:

Compensation varies by role, position level, and location. Individual pay is influenced by skills, education, training, certifications, experience, and the role's scope and complexity, along with business needs.

We offer a competitive Total Rewards package, including medical, dental, and vision plans starting on day one, PTO, paid holidays, commuter benefits, an employee stock purchase plan, education reimbursement, paid parental leave/adoption assistance, and a 401(k) plan with company match. These benefits are available to eligible full-time and part-time employees.

Your recruiter can provide more details about our total rewards and specific compensation ranges during the hiring process.

Top Skills

Excel
SQL
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Cincinnati, OH
4,738 Employees
On-site Workplace

What We Do

Based in Cincinnati, Ohio, the operations of Great American Insurance Group are engaged primarily in property and casualty insurance, focusing on specialty commercial products for businesses. We have more than 30 specialty property and casualty insurance businesses, and in 2021, approximately 50% of our gross written premium in our property and casualty operations was generated by business units with a Top 10 market ranking.

Great American Insurance Company has received an "A"​ (Excellent) or higher rating from the AM Best Company for more than 110 years (most recent rating evaluation of "A+"​ (Superior) affirmed December 3, 2021). The members of Great American Insurance Group are subsidiaries of American Financial Group, Inc. (AFG), also based in Cincinnati, Ohio.

Similar Jobs

Hybrid
Columbus, OH, USA
289097 Employees

The PNC Financial Services Group Logo The PNC Financial Services Group

Business Systems Analyst Consultant - Data Analyst/Tableau/SQL

Machine Learning • Payments • Security • Software • Financial Services
Hybrid
Strongsville, OH, USA
56000 Employees

PwC Logo PwC

Managed Services - Data Technical Lead - Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
41 Locations
370000 Employees
104K-233K Annually

Similar Companies Hiring

Flume Health Thumbnail
Software • Insurance • Healthtech
US
22 Employees
Spark Advisors Thumbnail
Software • Sales • Other • Insurance • Healthtech
New York, NY
89 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account