Job description

Crum & Forster (C&F) provides market leading property & casualty, accident & health, specialty and standard commercial lines insurance solutions. A true underwriting company, we have a 200-year history of helping our customers manage risk with laser-focused expertise, integrity and discipline. Our people are empowered to make decisions and problem-solve with you smartly and swiftly. Our annual gross written premium is 6.2 billion. C&F enjoys a financial strength rating of "A+" (Superior) by AM Best. Our most valuable asset is our people. We have 3000 employees, and locations throughout the United States and India. With our employee-first focus, the Company is consistently recognized as a great place to work, earning multiple workplace and wellness awards, including the Great Place to Work® Award, Fortune 100 Best Companies to Work For, Fortune Best Workplaces for Parents, Fortune Best Workplaces for Millennials, and many others. C&F is part of Fairfax Financial Holdings. For more information about C&F, please visit our website: www.cfins.com We are seeking an Associate Data Engineer to support the S&S Data Science team's External Data function. You will build and maintain the pipelines that bring third-party data sources into our underwriting, claims, and business intelligence workflows, working alongside an established data engineer. What you will do: • Build and maintain batch and streaming ETL/ELT pipelines that feed a cloud data warehouse • Develop, schedule, and monitor cloud data jobs, diagnosing failures and tuning for cost and performance • Write idempotent load logic that handles reprocessing and backfills without creating duplicate data • Integrate external data providers and APIs with authentication, error handling, and retries • Implement data quality checks, validation, and alerting to catch pipeline issues early • Manage and deploy pipelines using infrastructure-as-code and CI/CD • Support data migrations and service updates with minimal downtime • Deliver clean, analytics, model-ready datasets for data scientists and analysts What you will bring to C&F: • 1-5+ years of professional experience in data engineering or a related software/data role • Bachelor's degree in Computer Science, Data Engineering, or a related technical field or equivalent experience • Strong programming skills in Python and SQL • Familiarity with ETL/ELT concepts and building data pipelines • Experience with at least one major cloud platform (AWS preferred) • Familiarity with REST APIs and integrating external data sources • Strong attention to data quality and reliability • Ability to communicate clearly with both technical and business audiences Desired skills (nice to have): • Hands-on experience with AWS data services such as Glue, Lambda, and S3 • Experience loading and modeling data in a cloud data warehouse (e.g. Snowflake) • Experience with distributed processing frameworks such as Apache Spark • Experience with streaming technologies such as Kafka or Kinesis • Experience with infrastructure-as-code (CDK, Terraform, or CloudFormation) and monitoring with CloudWatch • Knowledge of geospatial analysis • Familiarity with zero-downtime deployment patterns such as blue-green deployments • Interest in insurance, underwriting, or claims #LI-MS #LI-REMOTE • 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 At C&F you will BELONG If 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 cfins.com 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 $71,600 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.

Requirements

Must-haves

C&F is part of Fairfax Financial Holdings. For more information about C&F, please visit our website: www.cfins.com
Build and maintain batch and streaming ETL/ELT pipelines that feed a cloud data warehouse
Develop, schedule, and monitor cloud data jobs, diagnosing failures and tuning for cost and performance
Write idempotent load logic that handles reprocessing and backfills without creating duplicate data
Integrate external data providers and APIs with authentication, error handling, and retries
Implement data quality checks, validation, and alerting to catch pipeline issues early
Manage and deploy pipelines using infrastructure-as-code and CI/CD
Support data migrations and service updates with minimal downtime
Deliver clean, analytics, model-ready datasets for data scientists and analysts
1-5+ years of professional experience in data engineering or a related software/data role
Bachelor's degree in Computer Science, Data Engineering, or a related technical field or equivalent experience
Strong programming skills in Python and SQL
Familiarity with ETL/ELT concepts and building data pipelines
Familiarity with REST APIs and integrating external data sources
Strong attention to data quality and reliability
Ability to communicate clearly with both technical and business audiences
Hands-on experience with AWS data services such as Glue, Lambda, and S3
Experience loading and modeling data in a cloud data warehouse (e.g. Snowflake)
Experience with distributed processing frameworks such as Apache Spark
Experience with streaming technologies such as Kafka or Kinesis
Experience with infrastructure-as-code (CDK, Terraform, or CloudFormation) and monitoring with CloudWatch
Knowledge of geospatial analysis
Familiarity with zero-downtime deployment patterns such as blue-green deployments

Nice-to-haves

Experience with at least one major cloud platform (AWS preferred)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

ci/cdpythonsqlawsrestgo

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Paid Time Off

Wellness