Full Job Description
Job Description
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
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