SQL Developer – Digital Data Services

🔥 1 hour ago

🏖️ New Jersey – Remote

🏖️ New Jersey – Remote

💵 $65k - $105k / year

⏰ Full Time

🟢 Junior

🟡 Mid-level

🖥 Software Engineer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Crum & Forster

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🛡️ Insurance

⚕️ Healthcare Insurance

Insurance • Healthcare Insurance

Crum & Forster (C&F) is a leading national property & casualty insurance company with a large, diversified specialty platform. Established in 1822, C&F provides specialty and standard commercial lines insurance products through its admitted and surplus lines insurance companies. With a written premium of $5. 3 billion as of 2023, C&F has an A. M. Best financial strength rating of “A” (Excellent). The company prides itself on creative, flexible, and client-focused solutions, recognized for superior customer service, claims, and risk engineering services. C&F employs over 2000 people across the United States and has earned several workplace awards for its employee-first focus and commitment to diversity, equity, and inclusion. C&F is part of Fairfax Financial Holdings Limited, engaged in property and casualty insurance and reinsurance.

📋 Description

• 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

🎯 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 (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 • 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 comply with C&F’s management controls. • Experience working with APIs a plus • A passion for learning • A passion for a dynamic, fast changing environment • An enthusiastic and positive attitude • An innovative, entrepreneurial spirit

🏖️ Benefits

• 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 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 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