Business Analyst

Summit Consulting; Cincinnati, Northern (OH, KY); 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

Commuter benefits

Employee stock purchase plan

Job summary

Great American Insurance Group, a leader in P&C IT Services, seeks a Business Analyst for a hybrid role in Cincinnati. You will gather and document requirements, liaise between business and IT, and contribute to test planning, data quality, and production support.

The role emphasizes AI-assisted workflow improvements and strong collaboration with stakeholders. Ideal candidates will have requirements gathering, test case creation, SQL skills, and excellent communication.

Qualifications

• Experience in requirements gathering and documenting requirements.
• Test case creation and test execution experience.
• Proficient in SQL writing.
• Strong written and verbal communication skills.
• Agile methodologies preferred.

Responsibilities

• Formulates and defines system scope and objectives based on business needs.
• Interviews end users to determine data, reports, analyses, and training needs.
• Develops and executes UI and API-level test plans and regression suites.
• Creates and maintains application documentation and training materials.
• Identifies and implements AI-assisted workflow improvements to boost productivity.
• Partners with business and IT to ensure solutions meet stakeholder goals.

Skills

Requirements gathering

Documentation

Test case creation

SQL writing

Communication skills

Tools

Postman

Rally

Jira

ServiceNow

GitHub Copilot

Microsoft 365 Copilot

Job description

## Business AnalystApply: Hybrid: Cincinnati, OH (USA): Full time: Posted Today: R9531**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**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.**