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. 

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