Senior Data Business Analyst

Dempsey & Siders Agency•Cincinnati, OH

2d•Hybrid

About The Position

Great American Insurance Group is a leader in the insurance industry, offering opportunities for growth and learning within its diverse specialty and property and casualty operations. The company fosters a "small company" culture with "big company" expertise, valuing diverse backgrounds and experiences to achieve business results. This role is within the Crop Division, which has been a leader in crop insurance since 1915 and is authorized by the USDA RMA to write MPCI policies. The division is seeking a strategic and dynamic leader for this hybrid role, which combines in-office and remote work, emphasizing the importance of on-site presence for collaboration and relationship building.

Requirements

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
Combined 5+ years of: 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
Applicants must be authorized to work in the United States without the need for current or future sponsorship.

Nice To Haves

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

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.
Troubleshoot 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 responsibility areas.
Drive automation and AI-assisted triage where appropriate.