SQL Developer – Data Lake & Cloud Analytics

Crum & Forster

New Jersey

On-site

USD 65,000 - 105,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive compensation package

401K employer match

Employee stock purchase plan

Generous paid time off

Comprehensive benefits

Job summary

Crum & Forster is a leading national insurance company seeking a SQL Developer to accelerate our Deductible Tracking System (DTS) modernization. You will work across Finance, Claims, and Digital Data Services to design, implement, and optimize data pipelines and reporting within Snowflake and AWS.

Strong SQL, data modeling, and collaboration skills are essential. We value a candidate with 2-5+ years in SQL development, experience with Snowflake or similar data lakehouse tools, and a proactive,

Qualifications

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

Responsibilities

Get up to speed quickly on our Deductible Tracking System (DTS) and share development and support responsibilities
Include SQL development, front end and back end support, and backlog management with the deductible collections team
Collaborate with Finance, Claims, and Digital Data Services teams to support the system
Work with MS SQL Server tools (SSMS, SSIS, SSRS)
Work with databases such as MS SQL Server, Oracle, PostgreSQL, and DynamoDB
Work with data pipelines in Snowflake Data Lake House
Utilize AWS services (CLI, EC2, S3, Lambda, DMS, Glue, etc.)
Engage in Data Lake development for reporting, analytics and ML
Ingest data using Fivetran, CData, Openflow or other near-real-time tools
Collaborate with business units to analyze needs and prioritize deliverables
Use Confluence and JIRA to manage tasks and documentation
Work with Git and Bitbucket for version control
Communicate with Digital teams and Business Units to define goals and timelines
Be an agent of change, applying new technology and skills

Skills

SQL Developer

Snowflake

SDLC

Query optimization

Complex joins

Python/JavaScript/Java

AI tooling

AWS

APIs

Communication

Vendor management

Ownership

Git/Bitbucket

Education

CS/Statistics/Math degree

Tools

Snowflake

SQL Server

Oracle

PostgreSQL

DynamoDB

SSMS

SSIS

SSRS

Git

Bitbucket

Confluence

JIRA

Job description

Strong SQL, data modeling, and collaboration skills are essential. We value a candidate with 2-5+ years in SQL development, experience with Snowflake or similar data lakehouse tools, and a proactive,

Get your free, confidential resume review.

or drag and drop your file here.