Senior Business Intelligence Analyst

Cincinnati, OH (USA)

Pay: Pay not listedSimilar roles state $94K–$143K
Work setting: Not stated
Employment: Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

Before you apply

Sponsorship: Visa sponsorship not confirmed — sponsorship source

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.
Read the full posting

Apply at American Financial Group

What you’ll work on

Full posting

Design and maintain semantic models, business logic, and metric definitions
Validate and reconcile data to ensure integrity and accuracy
Provide technical guidance and design reviews for fellow analysts

From the employer’s posting

Designs and maintains semantic models, business logic, and metric definitions

Ensures data integrity and accuracy through rigorous validation, reconciliation, and business-focused quality checks.

Provides technical guidance and supports peer development to analysts through design reviews, knowledge sharing, and problem solving.

Education & alternatives

Job Requirements Education: Bachelor’s Degree required; master’s degree or professional license/certification a plus. Field of Study: Business Analytics, Finance, Accounting, Computer Science, or a related quantitative or technology discipline preferred.

Tools in this posting

Python
SQL
Power BI
Snowflake
Tableau

Source

- Strong experience developing business intelligence solutions using Tableau, Power BI, or comparable platforms; Tableau experience preferred. - Experience using Python or other scripting languages for analytics, automation, or data exploration. - Working knowledge of cloud based analytics platforms; Snowflake experience preferred.

Great American Risk Solutions (GARS) is a growing wholesale excess & surplus (E&S) insurance business focused on complex and specialized commercial risks. As a dynamic and expanding business, GARS combines the entrepreneurial spirit of a growth-oriented organization with the stability and resources of Great American Insurance Group. The GARS Analytics Team develops reporting and analytics that enable better decision-making across a complex and evolving commercial portfolio. We are seeking a Senior Business Intelligence Analyst to serve as a technical leader and strategic partner driving analytics delivery, advancing our use of modern tools, and helping scale our capabilities as demand continues to grow. This role emphasizes advanced SQL-based analytics in Snowflake, ownership of core reporting domains, and thoughtful adoption of new tools and methodologies. The ideal candidate combines technical depth with strong business judgment and a continuous-learning mindset. Great American’s culture is built on connection, shared learning, and strong relationships. To support this, employees in this role are expected to be on‑site four days a week, with the flexibility to work one day remotely. Core in‑office days are Tuesday–Thursday, with the fourth day determined by business needs.

Scope of Job/Qualifications: - Advanced proficiency in SQL and relational database concepts. - Strong experience developing business intelligence solutions using Tableau, Power BI, or comparable platforms; Tableau experience preferred.

- Advanced proficiency in SQL and relational database concepts. - Strong experience developing business intelligence solutions using Tableau, Power BI, or comparable platforms; Tableau experience preferred. - Experience using Python or other scripting languages for analytics, automation, or data exploration.

- Experience using Python or other scripting languages for analytics, automation, or data exploration. - Working knowledge of cloud based analytics platforms; Snowflake experience preferred. - Knowledge of data extraction, transformation, and loading (ETL) processes.

Benefits in the posting

Full benefits wording

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.

From the employer’s posting.

Posting record

Report an error

Status in our records: Live
First seen by us: Sep 19, 2026 · 39 days ago
Recorded sightings: 112
Last seen by us: Oct 29, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

Your next step

Have your resume and examples of relevant work ready.
Check the listed location, eligibility and core experience before starting.
Ask the employer about the pay range before committing time to the process.

Complete your application on gaig.wd1.myworkdayjobs.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

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.

Great American Risk Solutions (GARS) is a growing wholesale excess & surplus (E&S) insurance business focused on complex and specialized commercial risks. As a dynamic and expanding business, GARS combines the entrepreneurial spirit of a growth-oriented organization with the stability and resources of Great American Insurance Group. The GARS Analytics Team develops reporting and analytics that enable better decision-making across a complex and evolving commercial portfolio. We are seeking a Senior Business Intelligence Analyst to serve as a technical leader and strategic partner driving analytics delivery, advancing our use of modern tools, and helping scale our capabilities as demand continues to grow.

This role emphasizes advanced SQL-based analytics in Snowflake, ownership of core reporting domains, and thoughtful adoption of new tools and methodologies. The ideal candidate combines technical depth with strong business judgment and a continuous-learning mindset.

Great American’s culture is built on connection, shared learning, and strong relationships. To support this, employees in this role are expected to be on‑site four days a week, with the flexibility to work one day remotely. Core in‑office days are Tuesday–Thursday, with the fourth day determined by business needs.

Essential Job Functions and Responsibilities

Analyzes, evaluates, and interprets large volumes of complex data from diverse sources to drive strategic business initiatives

Ensures data integrity and accuracy through rigorous validation, reconciliation, and business-focused quality checks.

Partners with stakeholders across the business to frame complex questions, clarify reporting requirements, uncover insights, and deliver solutions that support data-driven action.

Presents findings and strategic recommendations to management and other business stakeholders in a clear, impactful manner.

Partners with IT Data Mart teams to align business logic, data definitions, and reporting usage with enterprise data models, standards, and production implementations.

Responsibly uses AI-assisted analytics and coding tools to improve delivery speed and quality while applying appropriate validation, governance, and professional judgment.

Designs and maintains semantic models, business logic, and metric definitions that enable trusted reporting, analytics, and emerging AI-assisted BI capabilities.

Identifies and implements process improvements that increase the efficiency and effectiveness of data collection, analysis, and reporting.

Maintains documentation for data processes, workflows, reporting standards, and definitions to support governance and reuse.

Provides technical guidance and supports peer development to analysts through design reviews, knowledge sharing, and problem solving.

Maintains knowledge of analytics best practices and emerging trends and applies relevant methods to the team’s work.

Performs other duties as assigned.

Job Requirements

Education: Bachelor’s Degree required; master’s degree or professional license/certification a plus.

Field of Study: Business Analytics, Finance, Accounting, Computer Science, or a related quantitative or technology discipline preferred.

Experience: Seven or more years of experience in analytics, reporting, business intelligence, or a related field. Previous experience in insurance or financial services a plus.

Scope of Job/Qualifications:

Advanced proficiency in SQL and relational database concepts.

Strong experience developing business intelligence solutions using Tableau, Power BI, or comparable platforms; Tableau experience preferred.

Experience using Python or other scripting languages for analytics, automation, or data exploration.

Working knowledge of cloud based analytics platforms; Snowflake experience preferred.

Knowledge of data extraction, transformation, and loading (ETL) processes.

Advanced analytical and problem-solving skills with high attention to detail.

Performs work under limited supervision and relies on experience and judgment to plan and accomplish goals.

Excellent communication and presentation skills, with the ability to explain complex data insights to nontechnical stakeholders.

Proven ability to partner with business stakeholders to frame ambiguous problems, interpret data within business context, and influence decisions.

Demonstrated interest in learning new tools, techniques, and analytics best practices.

Experience working in Agile/Scrum environments a plus

Business Unit:

Great American Risk Solutions

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.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Cincinnati, OH (USA)

Working pattern and location restrictions need checking in the full posting.

Work authorization

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. Great American Risk Solutions (GARS) is a growing wholesale excess & surplus (E&S) insurance business focused on complex and specialized commercial risks. As a dynamic and expanding business, GARS combines the entrepreneurial spirit of a growth-oriented organization with the stability and resources of Great American Insurance Group. The GARS Analytics Team develops reporting and analytics that enable better decision-making across a complex and evolving commercial portfolio. We are seeking a Senior Business Intelligence Analyst to serve as a technical leader and strategic partner driving analytics delivery, advancing our use of modern tools, and helping scale our capabilities as demand continues to grow.

Open source at gaig.wd1.myworkdayjobs.com ↗Read the full description ↓

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Upload resume Add LinkedIn