Data Engineer

Crum & Forster Company OverviewCrum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. C&F enjoys a financial strength rating of "A+" (Superior) by AM Best and is proud of our superior customer service platform. Our claims and risk engineering services are recognized as among the best in the industry. Our most valuable asset is our people: more than 2,500 employees in locations throughout the United States. The company is increasingly winning recognition as a great place to work, earning several workplace and wellness awards for four years running, including the 2025-2026 Great Place to Work Award for our employee-first focus and our steadfast commitment to diversity, equity and Inclusion. C&F is part of Fairfax Financial Holdings, a global, billion dollar organization. For more information about Crum & Forster, please visit our website: www.cfins.com.Job DescriptionThe Surplus & Specialty 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 Data Engineer to join our team and help us continue to provide a high level of support to our business partners, while planning for our exciting future in the cloud. If you are interested in contributing to the transformation of an IT organization utilizing innovative tools then this is the place for you! The Digital Data Services Data Engineer will work with a group of highly motivated and experienced technologists who work to create innovative tools to the C&F Surplus & Specialty Organization for quick and scalable business solutions.What You Will DoThis position is to support and develop in-house, cloud-based, data-driven solutions and initiatives, which involve:Build and maintain the pipelines that move and process data from disparate sources into our data lakehouse platformFacilitate data preparation for use cases involving internal reporting, data lakehouse integrations, and predictive analyticsWork closely with our analytics and reporting team to create and maintain curated data marts.Leverage agile software development methods to make iterative enhancements to the data lakehouse infrastructure and ETL processesWorking with the Snowflake Platform (Horizon Catalog, Snowpark, Cortex AI, etc)Data ingestion tools such as Fivetran, CData, AWS Glue, or Apache KafkaWorking with the full suite of AWS Services (S3, Lambda, Glue, Athena, Lake Formation, etc)Working with relational databases such as Microsoft SQL Server and PostgreSQLWorking with version control software such as Git and BitbucketWorking with the various business units to analyze need, recommend solutions, and work with the team to prioritize, plan, and execute on deliverablesCommunicate with other Digital teams and 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&FDegree or certification in Computer Science, Mathematics, Statistics, Econometrics, Business, or equivalent3-4+ years working proficiently with SQL, Python and DataFrames.2+ years of experience with the Snowflake Data Cloud, preferably worked on Data Pipes, Streams, Streamlit, Dynamic Tables, and Snowpark.Familiarity with the AWS ecosystem, preferably the Analytics services and common utilities such as S3, SNS, SQS, Lambda Functions, Cloudwatch, etc.Good knowledge of working with semi-structured data, particularly JSONStrong in writing complex queries that involve nested joins, derived tables and common table expressions.Capable of performing technical root cause analysis and delivering corrective action.Experience working with APIs a plusA passion for learningGreat communication, note taking, and organizational skillsAn ability to leverage web searches and online training to obtain new skills quicklyAn ability to present to all levels of audienceExperience with Production Support and TroubleshootingAn enthusiastic and positive attitudeExperience working with external vendors a plusAbility to take ownership and see tasks through to completionWill abide by departmental policies and procedures, including authority levels, to comply with C&F's management controlWhat C&F Will Bring To YouCompetitive 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, visit https://www.cfins.com/onlineprivacypolicy/ca/noticeatcollection/ for more information.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 $73,700 to a maximum of $100,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.J-18808-Ljbffr