Senior Business Intelligence Analyst

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

Job summary

Great American Risk Solutions (GARS) seeks a Senior Business Intelligence Analyst to lead analytics delivery and advance our BI capabilities. The role emphasizes advanced SQL in Snowflake, ownership of core reporting domains, and adoption of new tools while maintaining governance and best practices.

The ideal candidate combines technical depth with strong business judgment and a continuous-learning mindset. On-site four days a week with one remote day, collaborating across teams.

Qualifications

• Bachelor’s Degree required; master’s degree a plus.
• Experience in BI analytics, data modeling and reporting.
• Proven ability to translate business questions into analytics solutions.

Responsibilities

• Analyzes large, complex data to drive strategic initiatives.
• Ensures data integrity through validation and quality checks.
• Partners with stakeholders to frame questions and deliver data-driven insights.
• Presents findings and recommendations to management clearly.

Skills

SQL

Data analysis

Business analytics

Data visualization

Education

Bachelor's degree

Master's degree preferred

Tools

Snowflake

Python

Power BI

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.

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