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 Policy Center, Claim Center, or Billing Center.

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.

• 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.

• Generally, 5 or more years of related experience.

• Strong knowledge of Workers Compensation Insurance
  .

• General insurance industry knowledge is required.

• Experience with
  Guidewire Policy Center, Claim Center, or Billing Center
  .

• 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.

• 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.

RICA Republic Indemnity Company of America

$ -$

Compensation varies by role, position level, and location. Individual pay is influenced by skills, education, training, certifications, experience, and the role's scope and complexity, along with business needs.

We offer a competitive Total Rewards package, including medical, dental, and vision plans starting on day one, PTO, paid holidays, commuter benefits, an employee stock purchase plan, education reimbursement, paid parental leave/adoption assistance, and a 401(k) plan with company match. These benefits are available to eligible full‑time and part‑time employees.

Your recruiter can provide more details about our total rewards and specific compensation ranges during the hiring process.