Senior Business Analyst - Guidewire

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 35 specialty 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.

We are seeking a highly motivated and technically skilled Business Analyst with a strong emphasis on database development to join our dynamic team. The ideal candidate will bring deep expertise in insurance systems, particularly Workers Compensation insurance, and hands-on experience with Guidewire applications such as PolicyCenter, ClaimCenter, or BillingCenter.

This role is best suited for someone who thrives at the intersection of business analysis and data engineering. You will be responsible for designing, developing, and optimizing complex database solutions that support analytical and operational reporting needs. A strong command of SQL and experience working with modern data platforms such as Snowflake is essential. Familiarity with data visualization tools like Tableau and Cognos is a plus.

The successful candidate will be a proactive individual who thrives in a collaborative environment and is eager to take on new challenges. This role bridges business needs with technical solutions, ensuring data-driven decision-making and process optimization.

This position will be located in our Calabasas office. This position will work on a hybrid schedule with working 1 day in office and 4 days from home. Remote candidates will be considered if not local to Calabasas.

Key Responsibilities:

• Collaborate with stakeholders to gather reporting requirements and translate them into actionable insights through the design and development of dashboards and reports using Cognos and Tableau.

• Perform data analysis and querying using Microsoft SQL Server, Snowflake and other database platforms.

• Translate complex data into actionable insights for business stakeholders.

• Conduct detailed business analysis to understand and document business requirements.

• Collaborate with stakeholders to gather, analyze, and validate business needs.

• Develop and maintain comprehensive documentation for business processes, systems, and workflows.

• Work closely with IT and development teams to ensure requirements are understood and implemented correctly.

• Continuously seek opportunities to improve business processes and systems.

Preferred Experience:

• Generally, 5 or more years of related experience.

• Strong knowledge of Workers Compensation Insurance.

• General insurance industry knowledge is required.

• Experience with Guidewire PolicyCenter, ClaimCenter, or BillingCenter.

• Proficiency in SQL and working with relational databases.

• Hands-on experience with Cognos, Tableau, and Snowflake.

• Familiarity with data modeling and ETL processes is a plus.

Qualities We Are Looking For:

• Self-Learner: Ability to quickly learn new concepts and technologies.

• Adaptable: Willingness to take on new challenges and adapt to changing environments.

• Team Player: Excellent collaboration skills and ability to work well with teams.

• Tech-Savvy: Comfortable with learning and using new technologies and tools.

• Proactive: Eager to identify opportunities for improvement and take initiative.

• Analytical Thinker: Strong problem-solving skills and attention to detail.

Company:

RICA Republic Indemnity Company of America

Salary Range:

$134,000.00 -$165,000.00

Benefits:

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 .

*Excludes seasonal employees and interns.