SQL Developer – Digital Data Services

This is a fully remote position, open to applicants in New Jersey.

📋 Description

• This position will assist in both in-house and cloud-based, data-driven development projects, which entails:

• Your initial main goal is to rapidly acclimate to our Deductible Tracking System (DTS) and share development and support duties. This will involve SQL development, front-end and back-end assistance, as well as managing the backlog with the deductible collections team.

• Collaborate with the Finance team, the Claims team, and members of the Digital Data Services team to support this system.

• Utilize Microsoft SQL Server tools (SSMS, SSIS, SSRS).

• Work with databases such as Microsoft SQL Server, Oracle, PostgreSQL, and DynamoDB.

• Engage with databases and data pipelines in our Snowflake Data Lake House.

• Utilize the complete suite of AWS Services (CLI, EC2, S3, Lambda, DMS, Glue, etc.).

• Participate in Data Lake development for reporting, analytics, and machine learning objectives.

• Conduct data ingestion using Fivetran, CData, Openflow, or other near-real-time data intake tools.

• Collaborate with various business units to assess needs, recommend solutions, and coordinate with the team to prioritize, plan, and execute deliverables.

• Use Confluence and JIRA for task, project, and documentation management.

• Work with version control systems such as Git and Bitbucket.

• Communicate with other Digital teams and Business Units to clearly outline project goals, discuss timelines, and offer feedback on solutions.

• Act as a catalyst for change, leveraging your creativity and skills to implement new technologies and methodologies.

⛳️ Requirements

• A degree or certification in Computer Science, Statistics, Mathematics, Business, or a related field, with career aspirations focused on IT.

• 2-5+ years of professional experience as a SQL Developer.

• Experience with Snowflake or other data lake house tools is a plus.

• Solid understanding of the Software Development Life Cycle (SDLC) process.

• Knowledge of efficiency techniques for building queries, along with proficiency in query and reporting analysis tools.

• Strong capability in writing complex queries that include nested joins, derived tables, and common table expressions.

• In-depth knowledge of one or more programming languages such as Python, JavaScript, Java, or similar is a plus.

• Experience with AI tools for code analysis, writing, and testing, as well as accelerating development.

• Familiarity with Production Support and Troubleshooting is an advantage.

• Experience working with external vendors is beneficial.

• Ability to take ownership and see tasks through to completion.

• Familiarity with Amazon Web Services is a plus.

• Commitment to adhering to departmental policies and procedures, including authority levels, to comply with C&F’s management controls.

• Experience with APIs is an asset.

• A strong passion for learning.

• A dedication to thriving in a dynamic and fast-paced environment.

• An enthusiastic and positive attitude.

• An innovative and entrepreneurial mindset.

🏝️ Benefits

• Competitive compensation package.

• Generous 401K employer match.

• Employee Stock Purchase plan with employer matching.

• Generous Paid Time Off.

• Excellent benefits that extend beyond health, dental, and vision.

• Our programs focus on the wellness of your entire family, including physical, mental, and financial wellbeing.

• A core value at C&F is supporting your career development, providing numerous opportunities for continued learning, including tuition reimbursement, industry-related certifications, and professional training to keep you advancing on your chosen path.

• A dynamic, ambitious, fun, and exciting work atmosphere.

• We believe in doing well by doing good, fostering a spirit of social and community responsibility through a matching donation program, volunteer opportunities, and an employee-driven corporate giving program that allows you to participate and support your community.