Senior Data Business Analyst

Posted 4 Days Ago
Cincinnati, OH, USA
In-Office
Senior level
Insurance
The Role
Lead detection, triage, and resolution of processing errors to protect compliance and finances; manage daily error queues; draft technical specifications and test plans; validate and reconcile data using intermediate-to-advanced SQL; maintain documentation and knowledge base; coordinate cross-functional delivery of crop insurance requirements; provide responsive customer support and drive automation/improvement initiatives.
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 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 D​ivision 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 implementation
-     Data analysis experience with demonstrated SQL and analytical capabilities
- Strong analytical and problem-solving abilities
- Excellent written and verbal communication skills
- Proficiency with Microsoft Office Suite
- Ability to learn new technical tools and methodologies quickly

Preferred Qualifications:
- 10+ years of combined business analysis and data analysis experience
- Knowledge of crop insurance programs, agricultural risk management, or farming operations
- Experience leading complex, enterprise-level initiatives
- Experience with both Agile and Waterfall methodologies
- Data visualization tools experience (Tableau, Power BI)
- Previous mentoring or team leadership experience

Business Unit:

Crop

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.

Skills Required

  • Bachelor's degree in Business, IT, Computer Science, Agriculture, Agronomy, Agricultural Economics, or related field
  • 5+ years combined business analysis and data analysis experience
  • Business analysis experience including requirements elicitation, process modeling, and system implementation
  • Data analysis experience with demonstrated SQL and analytical capabilities
  • Strong analytical and problem-solving abilities
  • Excellent written and verbal communication skills
  • Proficiency with Microsoft Office Suite
  • Ability to learn new technical tools and methodologies quickly
  • 10+ years combined business analysis and data analysis experience
  • Knowledge of crop insurance programs, agricultural risk management, or farming operations
  • Experience leading complex, enterprise-level initiatives
  • Experience with both Agile and Waterfall methodologies
  • Data visualization tools experience (Tableau, Power BI)
  • Previous mentoring or team leadership experience

Great American Insurance Group Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Great American Insurance Group and has not been reviewed or approved by Great American Insurance Group.

  • Leave & Time Off Breadth PTO, paid holidays, and paid parental leave are positioned as generous from the first year. These time‑off provisions are seen as core strengths of the total package.
  • Healthcare Strength Health coverage includes comprehensive medical, dental, and vision options supported by HSA and FSA programs. Wellness resources such as EAP access, fitness facilities or reimbursements, and instructor‑led classes broaden the offering.
  • Retirement Support Immediate 401(k) eligibility with a competitive company match and potential discretionary retirement contributions support long‑term savings. An employee stock purchase option and various discounts further reinforce financial benefits.

Great American Insurance Group Insights

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

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

Vertiv Logo Vertiv

Senior Business Analyst

Hardware • Software • Analytics
In-Office
Westerville, OH, USA
8435 Employees

OpenX Technologies Logo OpenX Technologies

Senior Data Analyst

AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Easy Apply
Remote or Hybrid
US
420 Employees
106K-125K Annually
In-Office
Cincinnati, OH, USA
4738 Employees
60K-90K Annually
In-Office
Columbus, OH, USA
471 Employees

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 Employees
MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account