SQL Developer - Digital Data Services

Developer Position at Crum & ForsterCrum & 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.The Specialty & Surplus Digital Data Services team leverages Agile software development principles to achieve success in its support of the business. We are a dynamic organization always on the lookout for intelligent, capable employees who are passionate about their career. We seek a Developer to join our team and help us continue to provide a high level of support to our business partners, while continuing forward to our exciting future in the cloud. If you are interested in contributing to an organization utilizing cutting edge tools then this is the place for you!The Digital Data Services Developer will work with a group of highly motivated and experienced technologists who have spent the past several years working hard to implement innovative tools to the C&F Surplus & Specialty Division for quick and scalable business solutions.What You Will Do:This role will support in-house and cloud-based, data driven development initiatives, which includes:Getting up to speed quickly on our Deductible Tracking System (DTS) and sharing the development and support responsibilities.SQL development, front end and back end support, as well as management of the backlog with the deductible collections team.Working 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 DynamoDBWorking with databases and data pipelines in our Snowflake Data Lake HouseWorking with the full suite of AWS Services (CLI, EC2, S3, Lambda, DMS, Glue, etc…)Data Lake development for reporting, analytics and machine learning purposesData ingestion using Fivetran, CData, Openflow or other near-real-time data intake toolsWorking with the various business units to analyze need, recommend solutions, and work with the team to prioritize, plan, and execute on deliverablesUsing Confluence and JIRA to manage tasks, projects, and documentationWorking with version control software such as Git and BitbucketCommunicate with other Digital teams, as well as the Business Units, to clearly define project goals, discuss timelines, and provide input on solutionsBecome an agent of change and use your creativity and skills to implement new technology and skillsWhat You Will Bring To C&F:Degree or certification in Computer Science, Statistics, Mathematics, Business, or equivalent, with a career path and/or career goals centered in IT2-5+ years of professional working experience as a SQL DeveloperExperience working with Snowflake or other data lake house tools a plusGood 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 toolsStrong 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 similarExperience using AI tools to analyze, write, and test code, as well as expediting developmentGreat communication, note taking, and organizational skillsExperience with Production Support and Troubleshooting a plusExperience working with external vendors a plusAbility to take ownership and see tasks through to completionExperience with Amazon Web Services a plusWill abide by departmental policies and procedures, including authority levels, to comply with C&F's management controls.Experience working with APIs a plusA passion for learningA passion for a dynamic, fast changing environmentAn enthusiastic and positive attitudeAn innovative, entrepreneurial spiritWhat C&F Will Bring To You:Competitive compensation packageGenerous 401K employer matchEmployee Stock Purchase plan with employer matchingGenerous Paid Time OffExcellent benefits that go beyond health, dental & vision. Our programs are focused on your whole family's wellness, including your physical, mental and financial wellbeingA 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 pathA dynamic, ambitious, fun and exciting work environmentWe 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 communityAt C&F You Will BelongIf you require special accommodations, please let us know. We value inclusivity and diversity. We are committed to equal employment opportunity and welcome everyone regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you require special accommodations, please let us know. Belonging at C&F, is a mindset. It's about fostering a culture of inclusion and connection, where everyone feels valued, heard, and empowered to thrive and where our social impact efforts help strengthen the communities where we live and work.For California Residents Only: Information collected and processed as part of your career profile and any job applications you choose to submit are subject to our privacy notices and policies.Crum & Forster is committed to ensuring a workplace free from discriminatory pay disparities and complying with applicable pay equity laws. Salary ranges are available for all positions at this location, taking into account roles with a comparable level of responsibility and impact in the relevant labor market and these salary ranges are regularly reviewed and adjusted in accordance with prevailing market conditions. 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. To be considered within market range, a salary is at or above the minimum of the range. You may also have the opportunity to participate in discretionary equity (stock) based compensation and/or performance-based variable pay programs.