Job DescriptionWe 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
What C&F will bring to you- 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
