Senior Data & Analytics Lead - Hybrid (Crop Insurance)

Summit Consulting; Cincinnati (OH); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Parental leave

Tuition reimbursement

401(k) match

Employee stock purchase plan

Job summary

Great American Insurance Group's Crop Division is seeking a strategic data-focused professional to lead analysis, monitor error feeds, and ensure compliance with MPCI requirements. You will coordinate with IT and business teams to implement fixes and champion prevention initiatives, leveraging SQL to access and validate data across sources.

In this hybrid role, you will draft technical specs, test plans, and maintain documentation while driving process improvements and providing proactive

Qualifications

• Bachelor's degree in Business, IT, CS, Agriculture, Agronomy, Agricultural Economics, or related field
• 5+ years of business analysis and data analysis experience
• Strong analytical and problem-solving abilities
• Excellent written and verbal communication skills
• Proficiency with Microsoft Office Suite

Responsibilities

• Protect compliance and minimize financial exposure by detecting, triaging, and resolving processing errors with rigor and speed
• 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
• 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

Skills

Business analysis

SQL

Data analysis

Communication

Problem solving

Education

Bachelor's degree in Business/IT/CS/Agriculture or related field

Tools

Tableau

Power BI

Excel

Job description

Great American Insurance Group's Crop Division is seeking a strategic data-focused professional to lead analysis, monitor error feeds, and ensure compliance with MPCI requirements. You will coordinate with IT and business teams to implement fixes and champion prevention initiatives, leveraging SQL to access and validate data across sources.

In this hybrid role, you will draft technical specs, test plans, and maintain documentation while driving process improvements and providing proactive