SQL Developer - Digital Data Services

Crum & Forster Company Overview

Crum & Forster (C&F) provides market leading property & casualty, accident & health, specialty and standard commercial lines insurance solutions. A true underwriting company, we have a 200-year history of helping our customers manage risk with laser-focused expertise, integrity and discipline. Our people are empowered to make decisions and problem-solve with you smartly and swiftly. Our annual gross written premium is 6.2 billion.

C&F enjoys a financial strength rating of "A+" (Superior) by AM Best.

Our most valuable asset is our people. We have 3000 employees, and locations throughout the United States and India. With our employee-first focus, the Company is consistently recognized as a great place to work, earning multiple workplace and wellness awards, including the Great Place to Work Award, Fortune 100 Best Companies to Work For, Fortune Best Workplaces for Parents, Fortune Best Workplaces for Millennia ls, and many others.

C&F is part of Fairfax Financial Holdings. For more information about C&F, please visit our website:

Crum & Forster is a leading national property & casualty insurance company with a large, diversified specialty platform. With deep roots going back to 1822, we are proud of our history and excited about our future. Our most valuable asset is our staff - 2000+ employees, and growing, in locations throughout the United States - committed to delivering customized products with superior customer service.

For more information about Crum & Forster, please visit our website:

The Specialty & Surplus Digital Data Services team leverages Agile software development principles to achieve success in its support of the business. We are a dynamic organization always on the lookout for intelligent, capable employees who are passionate about their career. We seek a Developer to join our team and help us continue to provide a high level of support to our business partners, while continuing forward to our exciting future in the cloud.

If you are interested in contributing to an organization utilizing cutting edge tools then this is the place for you!

The Digital Data Services Developer will work with a group of highly motivated and experienced technologists who have spent the past several years working hard to implement innovative tools to the C&F Surplus & Specialty Division for quick and scalable business solutions.

What you will do:

This role will support in-house and cloud-based, data driven development initiatives, which includes:

• Your initial primary objective is to get up to speed quickly on our Deductible Tracking System (DTS) and share the development and support responsibilities.
• This will include SQL development, front end and back end support, as well as management of the backlog with the deductible collections team
• You will work with the Finance team, the Claims team, as well as with the Digital Data Services team members working to support this system.
• Working with Microsoft SQL Server tools (SSMS, SSIS, SSRS)
• Working with databases such as Microsoft SQL Server, Oracle, PostgreSQL, and DynamoDB
• Working with databases and data pipelines in our Snowflake Data Lake House
• Working with the full suite of AWS Services (CLI, EC2, S3, Lambda, DMS, Glue, etc.)
• Data Lake development for reporting, analytics and machine learning purposes
• Data ingestion using Fivetran, CData, Openflow or other near-real-time data intake tools
• Working with the various business units to analyze need, recommend solutions, and work with the team to prioritize, plan, and execute on deliverables
• Using Confluence and JIRA to manage tasks, projects, and documentation
• Working with version control software such as Git and Bitbucket
• Communicate with other Digital teams, as well as the Business Units, to clearly define project goals, discuss timelines, and provide input on solutions
• Become an agent of change and use your creativity and skills to implement new technology and skills

What you will bring to C&F:

• Degree or certification in Computer Science, Statistics, Mathematics, Business, or equivalent, with a career path and/or career goals centered in IT
• 2-5+ years of professional working experience as a SQL Developer
• Experience working with Snowflake or other data lake house tools a plus
• Good understanding of the SDLC process (how software is built)
• Knowledge of efficiency techniques when building queries and proficiency in use of query and reporting analysis tools
• Strong in writing complex queries that involve nested joins, derived tables and common table expressions.
• In-depth knowledge of one or more of these programming languages a plus:
  Python, JavaScript, Java and similar
• Experience using AI tools to analyze, write, and test code, as well as expediting development
• Great communication, note taking, and organizational skills
• Experience with Production Support and Troubleshooting a plus
• Experience working with external vendors a plus
• Ability to take ownership and see tasks through to completion
• Experience with…