Senior Business Intelligence Analyst - Great American Risk Solutions

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