Senior Data & Analytics Analyst - Crop Insurance

GAIC Great American Insurance Company; Cincinnati (OH); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Great American Insurance Group is seeking a strategic, data-focused analyst to join its Crop Insurance team in a hybrid role. You will detect processing errors, analyze data with SQL, and coordinate cross-functional fixes while ensuring compliance with insurance requirements.

You will draft specifications, build test plans, and maintain documentation, collaborating with IT and business units to drive improvements and automation.

Qualifications

• Bachelor's degree in Business, Information Technology, Computer Science, Agriculture, Agronomy, Agricultural Economics, or related field.
• Combined 5+ years of business analysis experience including requirements elicitation, process modeling, and system implementation.

Responsibilities

• Detect, triage, and resolve processing errors to minimize financial exposure with urgency and accuracy.
• Monitor, prioritize, analyze, and resolve daily error feeds and queues; keep stakeholders informed.
• Coordinate with upstream/downstream teams to implement fixes and drive prevention initiatives.
• Ensure timely, accurate, and compliant Crop Insurance requirements by tracking changes, coordinating delivery, and validating changes.
• Draft technical specifications with record layouts, field definitions, validations, and cross-field rules.
• Author test plans/cases (positive/negative, regression) and document results; maintain knowledge base and documentation.
• Facilitate demos or reviews with IT and business teams.
• Leverage SQL to access, analyze, and validate data; write intermediate to advanced queries with performance in mind.
• Validate and reconcile data across sources; troubleshoot data discrepancies, quality, and performance issues.
• Document query logic and assumptions; develop reusable query assets for recurring analysis.
• Deliver reliable, responsive customer support by managing queues, resolving user issues, and improving self-service resources.
• Manage requests, discussions, and workflows; act as point of contact for key business partners.
• Drive automation and AI-assisted triage where appropriate.

Skills

SQL

Data analysis

Business analysis

Stakeholder communication

Education

Bachelor's degree

Job description

Great American Insurance Group is seeking a strategic, data-focused analyst to join its Crop Insurance team in a hybrid role. You will detect processing errors, analyze data with SQL, and coordinate cross-functional fixes while ensuring compliance with insurance requirements.

You will draft specifications, build test plans, and maintain documentation, collaborating with IT and business units to drive improvements and automation.