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.

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

• 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, and empowered to thrive and where our social impact efforts help strengthen the communities where we live and work.

For California Residents Only:  Information collected and processed as part of your career profile and any job applications you choose to submit are subject to our privacy notices and policies, visit https://www.cfins.com/onlineprivacypolicy/ca/noticeatcollection/  for more information.

Crum & Forster is committed to ensuring a workplace free from discriminatory pay disparities and complying with applicable pay equity laws.  Salary ranges are available for all positions at this location, taking into account roles with a comparable level of responsibility and impact in the relevant labor market and these salary ranges are regularly reviewed and adjusted in accordance with prevailing market conditions. The annualized base pay for the advertised position, located in the specified area, ranges from a minimum of  $78,900 to a maximum of $115,700. The actual compensation is determined by various factors, including but not limited to the market pay for the jobs at each level, the responsibilities and skills required for each job, and the employee’s contribution (performance) in that role. To be considered within market range, a salary is at or above the minimum of the range. You may also have the opportunity to participate in discretionary equity (stock) based compensation and/or performance-based variable pay programs.