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.
- Analyzes, evaluates, and interprets large volumes of complex data from diverse sources to drive s trategic 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 stake holders 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 analytic s logic and metrics in Snowflake to support exploration, prototyping, and business decision-making .
- Partners with IT D ata M art 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.
- 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. P revious experience in insurance or financial services a plus .
- 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