SQL Developer - Digital Data Services

About the role

Crum & Forster is a leading national property & casualty insurance company with a large, diversified specialty platform. Founded in 1822, the company prides itself on its history and commitment to providing customized products with superior customer service. Our people are at the heart of our success, with 2000+ employees across the United States dedicated to managing risk and delivering innovative solutions.

Responsibilities

• Support in-house and cloud-based, data-driven development initiatives
• Get up to speed quickly on the Deductible Tracking System (DTS) and share development and support responsibilities
• Work with the Finance team, the Claims team, and the Digital Data Services team members to support the DTS
• Work with Microsoft SQL Server tools (SSMS, SSIS, SSRS)
• Work with databases such as Microsoft SQL Server, Oracle, PostgreSQL, and DynamoDB
• Work with databases and data pipelines in our Snowflake Data Lake House
• Work with the full suite of AWS Services (CLI, EC2, S3, Lambda, DMS, Glue, etc…)
• Develop data lakes for reporting, analytics, and machine learning purposes
• Ingest data using Fivetran, CData, Openflow, or other near-real-time data intake tools
• Work with various business units to analyze needs, recommend solutions, and prioritize deliverables
• Manage tasks, projects, and documentation using Confluence and JIRA
• Communicate with other Digital teams and Business Units to define project goals, timelines, and solutions
• Implement new technology and skills as an agent of change

Requirements

• 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 (software development life cycle)
• In-depth knowledge of one or more programming languages (Python, JavaScript, Java, etc…)
• 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
• Experience working with external vendors
• Ability to take ownership and see tasks through to completion
• Experience with Amazon Web Services
• A passion for learning
• An innovative, entrepreneurial spirit

Qualifications

• Passionate about a dynamic, fast-changing environment
• An enthusiastic and positive attitude
• A core C&F tenet is supporting your career development, so we provide a wealth of ways for you to keep learning, which may include tuition reimbursement, industry-related certifications, and professional training
• 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

Skills

• SQL Development
• Data Lake Development
• AWS Services (CLI, EC2, S3, Lambda, DMS, Glue, etc…)
• AI Tools
• Version Control Software (Git, Bitbucket)
• Confluence and JIRA
• APIs

Benefits

• Generous 401K employer match
• Employee Stock Purchase Plan with employer matching
• Generous Paid Time Off
• Excellent benefits that go beyond health, dental, and vision
• Programs focused on your whole family’s wellness, including physical, mental, and financial wellbeing
• Corporate giving program that lets you participate and support your community

Pay

The annualized base pay for the advertised position, located in the specified area, ranges from a minimum of $65,000 to a maximum of $105,000. 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.

Schedule

Full-time position