Business Analyst

Summit Consulting; Cincinnati (OH); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with company match

Paid time off

Tuition reimbursement

Job summary

Great American Insurance Group's P&C IT Services is seeking a Business Analyst in Cincinnati, OH for a hybrid role combining in-office collaboration with remote work. You will work with business partners to gather requirements, document user needs, and support data/reporting needs in a dynamic insurance IT environment.

You will also develop and execute test plans, maintain regression suites, and participate in Agile ceremonies while identifying AI-assisted workflow improvements to boost

Qualifications

• Experience in requirements gathering and documentation.
• SQL writing experience.
• Strong written and verbal communication skills.

Responsibilities

• Formulates and defines systems scope and objectives through research and fact-finding.
• Analyzes, identifies, and writes detailed descriptions of user requirements, program functions, and steps to develop or modify applications.
• Interacts with business and IT; documents change requests through the full release cycle.

Skills

SQL

Requirements gathering

Test case creation

Communication skills

Agile experience

Tools

Postman

Jira

Rally

ServiceNow

GitHub Copilot

Job description

## Business AnalystApplyremote type: Hybridlocations: Cincinnati, OH (USA)time type: Full timeposted on: Posted Todayjob requisition id: R9329**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.P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services spans a wide range of activities, including software development, data management, Cloud services, IT security, technical support, access governance, infrastructure management, and the procurement and maintenance of equipment and software. The overall goal of IT Services is to deliver technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage.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:****Business Analysis & Requirements*** Formulates and defines systems scope and objectives through research and fact-finding combined with an understanding of applicable business solutions and business requirements* Analyzes, identifies, and writes detailed descriptions of user requirements, program functions, and steps required to develop or modify applications or components* Makes recommendations for business process improvements with an understanding of technical problems and solutions as they relate to technology needs* Acts as a liaison between business and IT; develops and maintains knowledge of the customer's business* Interviews end users to determine requirements for data, reports, analyses, training, data quality, and performance* Formulates systems to parallel overall business strategies**Testing & Quality Assurance*** Develops test plans and executes tests* Creates and maintains regression test suites, including UI and API-level test cases* Participates in Agile ceremonies: daily scrums, sprint reviews, nightly releases, and weekend testing as needed**Production Support*** Prepares analysis for production support of applications and associated documentation* Creates ad hoc reports and executes data queries to support business and operational needs* Identifies root cause of production issues and documents findings and recommendations**Documentation & Knowledge Management*** Creates and maintains application documentation, training materials, and process guides* Actively shares knowledge with team members and business partners to reduce knowledge silos* Manages and documents change requests through the full release cycle (CERT and PROD)**AI & Automation** *(New for 2026)** Identifies and implements AI-assisted workflow improvements to increase productivity and quality in daily BA work* Leverages AI tools (e.g., GitHub Copilot, Microsoft 365 Copilot) to accelerate requirements documentation, test case creation, query writing, and production issue analysis* Stays informed on emerging AI capabilities relevant to business analysis and proactively shares use cases with the team* Approaches work with a continuous improvement mindset, seeking ways to use AI and automation to do better every day**Business & Customer Engagement*** Demonstrates a strong partnership mindset with the business — understands their goals, challenges, and needs* Communicates clearly and transparently in business-relevant terms* Provides thoughtful options to address business needs and challenges; operates as more than an order taker* Responds promptly and professionally to customer needs**Requirements:*** Requirements gathering and documentation experience* Test case creation and execution experience* SQL writing experience* Strong written and verbal communication skills**Strongly Preferred:*** Experience with Agile methodology (daily scrums, sprint planning, retrospectives)* Experience with API testing tools (e.g., Postman)* Experience with project and work management tools (e.g., Rally, Jira, ServiceNow)**Nice to Have:*** Experience with AI productivity tools (GitHub Copilot, Microsoft 365 Copilot, or similar)* Familiarity with insurance industry systems or P&C (Property & Casualty) business domain* Experience creating or maintaining automated test suites**Business Unit:**Property & Casualty IT Services**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.**