Senior Technical Business Analyst

Great American Insurance Group; Cincinnati (OH); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Wellness programs

Paid Time Off and holidays

401(k) with company match

Employee stock purchase plan

Commuter benefits

Job summary

Great American Insurance Group in Cincinnati, OH seeks a Senior Technical Business Analyst to translate complex business needs into scalable IT and data solutions. You will partner with stakeholders and technical teams across the SDLC to deliver robust specifications, configurations, and automated processes.

The role focuses on SQL analytics, reporting (Power BI/Tableau), and security, with a hybrid on-site/remote work arrangement.

Qualifications

• Bachelor’s degree in Information Systems, Information Technology, Computer Science, Business, or a related field.
• 10+ years of related experience in business and systems analysis, and hands-on application support, configuration, or development.
• Desirable professional designations (e.g., Azure Administrator Associate, ITIL Foundation, CBIP, CISSP).

Responsibilities

• Translate complex business needs into detailed IT and data solution requirements.
• Collaborate with stakeholders and technical teams to model requirements and develop solution specifications.
• Lead configuration and maintenance of enterprise applications and optimize performance and reliability.
• Respond to service requests, troubleshoot issues, and document resolutions for business/technical audiences.
• Develop technical specs for enhancements and implement automated system protocols to reduce manual work.
• Lead testing, debugging, and deployment of updates with minimal business disruption.
• Use SQL and analytics tools to analyze data and support decision-making; create reports/dashboards as needed.
• Manage application security, including user access and data protection compliance.

Skills

Business Analysis

SDLC

ITIL Practices

SQL

Power BI

Tableau

Scripting

Education

Bachelor's degree in IS/IT/CS

Tools

Power BI

Tableau

SQL

Scripting Languages

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 can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors.

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.

The Great American Risk Solutions IT team is seeking a Senior Technical Business Analyst. This individual will combine advanced business analysis with hands-on technical expertise to translate complex business needs into reliable, scalable IT and data solutions. They will partner with business stakeholders and technical teams throughout the requirements and software development life cycles, with responsibilities spanning technical specifications, application configuration, SQL and data analysis, automation, testing, deployment, and production support.

Essential Job Functions And Responsibilities

• Analyzes complex business issues, gathers and defines business and technical requirements, and translates them into detailed specifications for IT and data solutions aligned with organizational goals.
• Collaborates with business stakeholders, program and project managers, and cross-functional technical teams to model system requirements, evaluate capabilities, and develop workflow charts, diagrams, and solution specifications.
• Leads configuration and maintenance of enterprise applications, tunes systems for efficiency, and implements enhancements to improve performance, reliability, functionality, and scalability.
• Responds to complex application service requests, troubleshoots system and data issues, and documents findings and resolutions clearly for business and technical audiences.
• Develops technical specifications for system enhancements, contributes to coding and advanced bug fixes, and develops and implements automated system protocols and scripts to reduce manual processes.
• Leads testing, debugging, and deployment of application updates, verifying alignment with business and technical requirements while ensuring quality and minimal disruption to business operations.
• Uses SQL and analytical tools to gather and analyze data, investigate issues, and support solution decisions. May develop and maintain complex reports and dashboards to support business needs and decision-making.
• Manages application-level security, including user access and compliance with data protection standards.
• May have responsibility for performance and coaching of staff and may have a participatory role in decisions regarding talent selection, development, and performance management for direct reports.
• Performs other duties as assigned.

Job Requirements

Education: Bachelor’s degree in Information Systems, Information Technology, Computer Science, Business, or a related field.

Experience: Generally, a minimum of 10 years of related experience spanning business and systems analysis and hands-on application support, configuration, systems administration, or application development. Experience includes defining requirements and designing, coding, testing, debugging, documenting, maintaining, or configuring enterprise applications in a business setting. Completion of or continuing progress toward a professional designation preferred, such as Azure Administrator Associate or equivalent cloud certification, ITIL Foundation Certification, Certified Business Intelligence Professional (CBIP), or Certified Information Systems Security Professional (CISSP).

Scope of Job/Qualifications: Advanced knowledge of business and systems analysis, ITIL practices, and the software development lifecycle (SDLC). Advanced proficiency in enterprise platforms, SQL, reporting tools (e.g., Power BI, Tableau), and scripting languages, with the ability to translate business needs into actionable technical requirements and practical system solutions. Provides requirements guidance and participates in all phases of the requirements life cycle for complex programs and projects. Recommends best practices and introduces effective analysis techniques, tools, and approaches. Requires a high level of understanding of the organization’s business and technology operations, advanced analytical skills, and excellent communication, stakeholder engagement, and business relationship skills. Communicates complex topics clearly, aligns solutions with business needs, and anticipates downstream impacts. Viewed as a senior resource on the team; provides technical advice and support to lower-level positions. May serve as a Scrum Master, facilitating and coaching an agile team and helping others understand how to interact with the team, or as an agile development team member creating and testing the product increment.

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.