Senior Data Business Analyst

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

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.

This position is not eligible for employment visa sponsorship. Applicants must be authorized to work in the United States without the need for current or future sponsorship.

The Crop Division of Great American has been helping generations of farmers take control of their risks since 1915. The Division is also one of a select few private companies authorized by the United States Department of Agriculture Risk Management Agency (USDA RMA) to write MPCI policies. With six regional offices throughout the U.S., the teams provide tremendous expertise in the specific needs of farmers and crops.

As one of the largest Crop insurers in the country, Great American is recognized as a leader in this specialized marketplace. We are seeking a strategic and dynamic leader to join our GREAT team.

https://www.greatamericancrop.com/

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.

Essential Job Functions and Responsibilities:

• Protect compliance and minimize financial exposure by detecting, triaging, and resolving processing errors with rigor and speed, prioritizing items with imminent cutoff impacts, communicating status and decisions to stakeholders, and identifying and implementing prevention measures that reduce error incidence over time.
• Monitor, prioritize, analyze, and resolve daily error feeds/queues, keeping stakeholders informed of progress.
• Coordinate with upstream/downstream teams to implement fixes and champion prevention initiatives

• Ensure timely, accurate, and compliant implementation of Crop Insurance requirements by proactively tracking changes, coordinating cross-functional delivery, validating technical changes with rigorous testing, communicating downstream impacts to stakeholders, and keeping the knowledge base and documentation current.
• Draft clear technical specifications referencing record layouts, field definitions, validations, and cross-field rules.
• Author test plans/cases (positive/negative, regression) and document results.
• Maintain knowledge base and system documentation.
• Facilitate demos or reviews with IT and business teams.

• Leverage SQL effectively to access, analyze, and validate data by writing accurate, efficient queries; applying appropriate performance techniques; and continuously improving data quality, insight delivery, and business outcomes.
• Write intermediate to advanced SQL queries, with security and optimization given the highest attention.
• Validate and reconcile data across multiple sources and business expectations.
• Troubleshooting data discrepancies, quality, and/or performance issues.
• Document query logic and assumptions clearly.
• Develop reusable query assets for recurring analysis or reporting.

• Deliver reliable, responsive, and compliant customer support by managing and prioritizing requests, resolving user issues and questions, improving self-service resources, and analyzing trends to proactively reduce incidents and improve customer experience and business outcomes.
• Manage request queues, discussions, and workflows.
• Serve as point-of-contact for key business partners; manage expectations and timelines.
• Solve issues and requests for responsbility areas.
• Drive automation and AI-assisted triage where appropriate.

Minimum 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 impl