Great American Insurance Group
Great American Insurance Group
5,001 – 10,000 Employees
B2BInsurance
Great American Insurance Group is a U.S.-based specialty insurer serving businesses and niche industries with commercial coverage and related insurance services. Its offerings span property and inland marine, transportation, professional liability, trade credit, cyber risk, equine mortality, and employer health solutions. The organization operates through specialty divisions and international branches, combining industry-focused underwriting with claims expertise for business customers. Great American Insurance Group is part of American Financial Group and has more than 150 years of insurance experience.

Senior Business Intelligence Analyst - Cincinnati, OH (Hybrid)

Lead SQL-driven analytics, Snowflake reporting, and semantic modeling for Great American Risk Solutions’ complex commercial insurance portfolio. Translate data into insights that support informed business decisions.

Description

  • Analyze and interpret complex data from multiple sources to support strategic business initiatives
  • Validate, reconcile, and quality-check data to maintain accuracy and integrity
  • Work with stakeholders to define complex questions, clarify reporting needs, uncover insights, and deliver data-driven solutions
  • Present analytical findings and recommendations to management and business stakeholders
  • Coordinate with IT Data Mart teams to align business logic, data definitions, and reporting practices with enterprise standards
  • Use AI-assisted analytics and coding tools responsibly, validating outputs and applying sound governance and professional judgment
  • Build and maintain semantic models, business rules, and metric definitions for reliable reporting, analytics, and emerging AI-assisted BI capabilities
  • Improve processes for data collection, analysis, and reporting
  • Document data processes, workflows, reporting standards, and definitions
  • Offer technical guidance and support colleague development through design reviews, knowledge sharing, and problem-solving
  • Stay current with analytics best practices and emerging industry trends
  • Complete other assigned responsibilities

Requirements

  • Bachelor’s degree required
  • At least seven years of experience in analytics, reporting, business intelligence, or a related discipline
  • Advanced SQL skills and a strong understanding of relational database concepts
  • Substantial experience creating business intelligence solutions with Tableau, Power BI, or similar platforms; Tableau preferred
  • Experience with Python or another scripting language for analytics, automation, or data exploration
  • Working knowledge of cloud analytics platforms; Snowflake preferred
  • Understanding of data extraction, transformation, and loading (ETL) processes
  • Advanced analytical and problem-solving ability with strong attention to detail
  • Ability to work with limited supervision and use experience and judgment to plan and deliver work
  • Strong communication and presentation skills, including the ability to explain complex insights to nontechnical audiences
  • Demonstrated ability to collaborate with business stakeholders, clarify ambiguous problems, interpret data in context, and influence decisions
  • Willingness to learn new tools, methods, and analytics best practices
  • Agile or Scrum experience is a plus
  • Must be authorized to work in the United States without current or future sponsorship

Benefits

  • Medical, dental, and vision insurance
  • Wellness programs
  • Parental leave
  • Adoption assistance
  • Tuition reimbursement
  • Paid time off
  • Paid holidays
  • 401(k) with company match
  • Employee stock purchase plan
  • Commuter benefits

Related Jobs