2 months ago
Hartford, CT, USAMid Level
Base Salary
$127k - $209k/yr
Responsibilities
- Build and operationalize complex data solutions and ETL pipelines.
- Design data solutions and analyze complex data sources for analytical use.
- Apply data transformations and recommend data cleansing and quality improvements.
- Implement data governance, data security, and data quality practices.
- Collaborate across teams to support delivery and educate end users on data products and analytical environments.
- Analyze and resolve complex data and system defects and incidents.
- Test data movement, transformation code, and data components.
Requirements
- Bachelor’s degree in computer science, a related STEM field, or equivalent education and/or work experience.
- At least four additional years of data engineering experience.
- Experience building ETL pipelines using AWS, dbt, or another ETL tool.
- Understanding of AWS cloud services and data architecture patterns, including S3, IAM, Lambda, and CloudWatch.
- Experience with data modeling techniques such as star and snowflake schemas and data warehouse design principles.
- Eight years of relevant experience is listed for the ideal candidate.
- Ab Initio experience for enterprise-scale ETL development is preferred.
- Strong software delivery, problem-solving, communication, documentation, and business partnership skills are preferred.
Benefits
- Health insurance coverage for eligible employees and family members begins on the first day of employment.
- Travelers matches 401(k) contributions dollar-for-dollar up to the first 5% of eligible pay, subject to an annual maximum.
- Employees may participate in the Paying it Forward Savings Program and receive access to a Travelers-funded pension plan.
- At least 20 days of paid time off annually plus nine paid company holidays.
- Wellness resources, discounts, caregiving support, and free professional counseling and mental health services.
- Volunteer encouragement through Matching Gift and Volunteer Rewards programs.
Tech Stack
AWSdbt
Categories
Data Engineering
About Travelers
Travelers is a public property and casualty insurer that provides auto, home, and commercial coverage, plus risk management and claims services, to individuals and businesses. It distributes policies through independent agents and brokers across the United States, Canada, the United Kingdom, and Ireland. Founded in 1853 and headquartered in New York City, Travelers trades on the NYSE (TRV) and is the only property-casualty company in the Dow Jones Industrial Average.