Business Analyst

gaig; Cincinnati (OH); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Wellness program

Parental leave

Tuition reimbursement

Paid time off

Paid holidays

401(k) match

Employee stock purchase plan

Commuter benefits

Job summary

Great American Insurance Group is seeking a Business Analyst to drive requirements, collaborate with IT, and apply AI-enabled workflow improvements. The role supports production systems, develops test plans, and creates documentation to improve data quality and delivery.

The position is hybrid, combining in-office collaboration with remote work, and emphasizes strong communication with business partners to deliver efficient technology solutions.

Qualifications

• Requirements gathering and documentation experience.
• Test case creation and execution experience.
• SQL writing experience.
• Strong written and verbal communication skills.

Responsibilities

• Business Analysis & Requirements: define scope, capture user requirements, and liaison between business and IT.
• Testing & Quality Assurance: develop test plans, regression suites, and participate in Agile ceremonies.
• Production Support: prepare analyses, create ad hoc reports, identify root causes.
• Documentation & Knowledge Management: create and maintain docs, share knowledge, manage change requests across CERT and PROD.
• AI & Automation: identify AI-enabled workflow improvements and leverage tools like Copilot to speed documentation and testing.
• Business & Customer Engagement: partner with business, communicate clearly, offer thoughtful options and timely responses.

Skills

Requirements gathering & documentation

SQL writing

Strong communication

Agile experience

Tools

Postman

Rally

Jira

ServiceNow

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.

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

• 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

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.