Data Engineer II (AWS, Python, SQL)
Job Description
Travelers is strengthening its data-driven approach to pricing for Property and General Liability lines. In the Data Engineer II role, you will design and maintain production-grade data pipelines and assets in collaboration with actuarial and data science partners, turning analytical concepts into scalable solutions powered by AWS, Python, and SQL. This onsite position in Hartford, CT centers on delivering end-to-end data infrastructure that informs pricing decisions and modernization efforts.
Responsibilities
- Own and deliver data pipeline development and ongoing support for Property and GL pricing use cases
- Lead model implementation for Property and GL pricing models in partnership with Data Science and Actuarial teams
- Build and serve as the GL data subject matter expert to support benchmarks, modernization initiatives, and future enhancements
- Provide project leadership, planning, and execution across Property and GL data engineering initiatives
- Execute complex data preparation activities, including exploration, cleansing, and transformation, with awareness of enterprise architecture, platforms, and downstream consumption patterns
- Translate actuarial and data science requirements into scalable, production-ready data solutions
- Adopt and embed MLOps practices across the model development and implementation lifecycle
- Establish data quality controls, profiling, and monitoring for model implementation and ongoing performance
- Present analysis and technical recommendations to influence data architecture and implementation decisions
- Provide technical leadership through code reviews, design guidance, and mentoring within the team
- Apply agile methodologies to plan, prioritize, and deliver work across concurrent initiatives
- Perform other duties as assigned
Requirements
- Bachelor’s degree in a STEM field or equivalent
- Eight years of related experience
- Cloud platforms (preferably AWS) and model implementation in the cloud
- Programming in Python and SQL
- Working with data engineering concepts and building/maintaining data pipelines
- AI-native solutions and modern software engineering practices (e.g., APIs, microservices, test automation)
- Breaks work into small, releasable increments
- Delivers complete, robust solutions while effectively managing tradeoffs
- Strong understanding of relevant technical concepts and industry trends
- In-depth knowledge of the systems you’ve worked on and familiarity with adjacent systems
- Strong problem-solving skills with a focus on building resilient, long-lived systems and finding innovative ways to resolve issues
- Excellent written and verbal communication skills, with the ability to collaborate effectively with engineers, product partners, and business stakeholders
- Proven experience leading or mentoring other engineers and helping to create a safe, inclusive environment where others can learn and grow
- Self-motivated, with a track record of proactively identifying opportunities, driving improvements, and following through on team efforts
Technologies
- AWS
- Python
- SQL
- Terraform
- CI/CD
Benefits
- Health Insurance
- Retirement
- Paid Time Off
- Wellness Program
- Volunteer Encouragement
Location
Hartford, CT (onsite)
Compensation
Salary range: USD 126,500 - 208,700 per year
About Travelers
Taking care of our customers, our communities and each other. That is the Travelers Promise. This commitment has helped Travelers earn recognition as a leading property and casualty insurer for more than 170 years. The culture emphasizes innovation and collaboration, offering a place where professionals can grow and do meaningful work.
Employment practices
Travelers is an equal opportunity employer. We value the unique abilities and talents each individual brings, recognizing that diverse perspectives strengthen the organization.