Sr. Data Solutions Analyst

Crum & Forster Company Overview

Crum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. C&F enjoys a financial strength rating of "A+" (Superior) by AM Best and is proud of our superior customer service platform. Our claims and risk engineering services are recognized as among the best in the industry.

Our most valuable asset is our people: more than 2500 employees in locations throughout the United States. The company is increasingly winning recognition as a great place to work, earning several workplace and wellness awards for four years running, including the 2025 Great Place to Work® Award for our employee-first focus and our steadfast commitment to diversity, equity and Inclusion.

C&F is part of Fairfax Financial Holdings, a global, billion dollar organization.  For more information about Crum & Forster, please visit our website: www.cfins.com.

 

 

Job Description

 

Information About the role:

 

We are seeking a Sr. Data Solutions Analyst to join the digital data services team at Crum & Forster. As a Data Solutions Analyst, you will play a crucial role in turning complex data into actionable insights for the Surplus & Specialty Team by designing and developing data solutions. The ideal candidate should have a strong background in conceptualizing, developing, and documenting data solutions using complex SQL functionality.

 

What you will do:

• Performing and documenting data analysis, data validation, and data mapping/design.
• Conceptualizing and implementing ETL processes within Snowflake using Procedures, Tasks, Dynamic Tables, etc.
• Supporting Data Analysts with building high performing queries to be used for reporting.
• Working with other departments to provide data solutions (Data Marts, Ad Hoc Queries, etc.) that meet user requirements.
• Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.
• Communicating with all levels of the organization to design and develop data solutions
• Utilizing JIRA to track and manage the progress of tasks, ensuring timely completion and adherence to weekly sprints.

 

What you will bring to C&F:

• Bachelors in mathematics, computer science, information systems, or related field.
• 5+ years of extensive work experience with relational databases (SQL Server, PostgreSQL, DB2, etc.).
• Experience developing solutions (procedures, functions, views, ETL processes, etc.) using complex SQL concepts.
• Knowledge of techniques used for query efficiency (Time & Cost).
• Excellent verbal and written communication skills to effectively convey data insights and collaborate with stakeholders
• Ideal Candidate will have experience developing queries, procedures, functions, and tasks within Snowflake
• Desired skills:
  • Insurance industry knowledge
  • Experience with data manipulation tools (e.g. Python, R)

#LI-MS

#LI-REMOTE

What C&F will bring to you

 

• Competitive compensation package
• Generous 401K employer match
• Employee Stock Purchase plan with employer matching
• Generous Paid Time Off
• Excellent benefits that go beyond health, dental & vision. Our programs are focused on your whole family’s wellness, including your physical, mental and financial wellbeing
• A core C&F tenet is owning your career development, so we provide a wealth of ways for you to keep learning, including tuition reimbursement, industry-related certifications and professional training to keep you progressing on your chosen path
• A dynamic, ambitious, fun and exciting work environment
• We believe you do well by doing good and want to encourage a spirit of social and community responsibility, matching donation program, volunteer opportunities, and an employee-driven corporate giving program that lets you participate and support your community

 

 

At C&F you will BELONG

 

If you require special accommodations, please let us know. We value inclusivity and diversity. We are committed to equal employment opportunity and welcome everyone regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you require special accommodations, please let us know. Belonging at C&F, is a mindset. It’s about fostering a culture of inclusion and connection, where everyone feels valued, heard,