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:

• 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

• 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 Amazon Web Services a plus
• Will abide by departmental policies and procedures, including authority levels, to…