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.
The Great American Risk Solutions (GARS) Analytics Team develops reporting and analytics that enable better decision making across a complex and evolving commercial insurance 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 proactive adoption of new tooling and methodologies. The ideal candidate brings strong technical depth, business curiosity, 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 comprehensive data audits and advanced validation techniques.
Conducts in-depth analysis of data trends and patterns to identify opportunities for optimization and inform strategic decisions.
Collaborates cross-functionally with various departments to understand and address their complex data reporting requirements, delivering customized solutions.
Presents findings and strategic recommendations to management and other business stakeholders in a clear, impactful manner.
Identifies, recommends, and implements advanced process improvements to enhance data collection, analysis, and reporting efficiency and effectiveness.
Maintains advanced, updated knowledge of industry best practices and emerging trends in data analytics and reporting, integrating new methodologies as appropriate.
Develops and maintains clear documentation for data processes, workflows, reporting standards, and data definitions to support governance and reuse.
Owns delivery of complex analytics, reports, and dashboards, developing analytics logic and metrics in Snowflake to support exploration, prototyping, and business decision-making.
Partners with IT Data Mart teams to align business logic, data definitions, and reporting usage with enterprise data models, standards, and production implementations.
Uses AI-assisted analytics and coding tools responsibly to accelerate analytics delivery and improve quality where they provide clear business value.
Provides technical guidance and supports peer development to analysts through design reviews, knowledge sharing, and problem solving.
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: 8 years of experience in analytics, reporting, or business intelligence roles. Previous experience in insurance or financial services a plus.
Scope of Job/Qualifications
Advanced proficiency in SQL and relational database concepts.
Strong experience with Business Intelligence tools (Tableau preferred, Power BI).
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 SolutionsBenefits:
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.
Skills Required
- Bachelor's Degree required; master's degree or professional license/certification a plus
- 8 years of experience in analytics, reporting, or business intelligence roles
- Advanced proficiency in SQL and relational database concepts
- Strong experience with Business Intelligence tools (Tableau preferred, Power BI)
- Experience using Python or other scripting languages for analytics
- Working knowledge of cloud based analytics platforms; Snowflake experience preferred
- Knowledge of data extraction, transformation, and loading (ETL) processes
- Excellent communication and presentation skills
- Experience working in Agile/Scrum environments
Great American Insurance Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Great American Insurance Group and has not been reviewed or approved by Great American Insurance Group.
-
Leave & Time Off Breadth — PTO, paid holidays, and paid parental leave are positioned as generous from the first year. These time‑off provisions are seen as core strengths of the total package.
-
Healthcare Strength — Health coverage includes comprehensive medical, dental, and vision options supported by HSA and FSA programs. Wellness resources such as EAP access, fitness facilities or reimbursements, and instructor‑led classes broaden the offering.
-
Retirement Support — Immediate 401(k) eligibility with a competitive company match and potential discretionary retirement contributions support long‑term savings. An employee stock purchase option and various discounts further reinforce financial benefits.
Great American Insurance Group Insights
What We Do
Based in Cincinnati, Ohio, the operations of Great American Insurance Group are engaged primarily in property and casualty insurance, focusing on specialty commercial products for businesses. We have more than 30 specialty property and casualty insurance businesses, and in 2021, approximately 50% of our gross written premium in our property and casualty operations was generated by business units with a Top 10 market ranking. Great American Insurance Company has received an "A" (Excellent) or higher rating from the AM Best Company for more than 110 years (most recent rating evaluation of "A+" (Superior) affirmed December 3, 2021). The members of Great American Insurance Group are subsidiaries of American Financial Group, Inc. (AFG), also based in Cincinnati, Ohio.
