Data Engineer II, dbt, AWS

Travelers

. Build and operationalize complex data solutions .

Posted 9/22/2026full-timeHartford • Connecticut • United StatesSeniorLead💰 $126,500 - $208,700 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and operationalizing complex data solutions, including ETL pipelines and data governance practices. Proficient in data modeling techniques and cloud services, with strong problem-solving and communication skills to support cross-team collaboration.

Highest-signal resume keywords

ETL Pipeline DevelopmentAWS Cloud ServicesData Modeling TechniquesData Governance PracticesComplex Data Analysis

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data TransformationData CleansingData Quality SolutionsData Warehouse DesignData Architecture PatternsAutomated TestingData Movement TestingData Pipeline SupportMachine Learning SolutionsBusiness Intelligence Solutions

Soft Skills

Strong Problem-Solving SkillsExcellent Communication SkillsCollaboration Across Teams

Tools & Technologies

AWSDbtAb InitioS3IAMLambdaCloudWatch

Industry Keywords

Data GovernanceData QualityData EngineeringData AnalyticsData Solutions

Tech Stack

Tools & technologies

AWSCloudETL

About the role

Key responsibilities & impact

Build and operationalize complex data solutions
Correct problems and apply data transformations
Recommend data cleansing and quality solutions
Design complex data solutions
Analyze complex data sources to determine value and usage
Recommend data for inclusion in analytical processes
Apply data governance, security, and quality practices
Collaborate across teams to support delivery
Educate end users on complex data products and analytics environments
Analyze, assess, and resolve complex data and system defects and incidents
Test data movement, transformation code, and data components
Support data pipelines and solutions for artificial intelligence, machine learning, and business intelligence

Requirements

What you’ll need

Eight years of relevant experience
Proven 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, including star and snowflake schemas
Experience with data warehouse design principles
Bachelor's degree in computer science, a related STEM field, or equivalent education and/or work experience
Four additional years of data engineering experience
Strong delivery skills, including software design strategy, automated testing, analysis, feedback loops, and monitoring
Strong problem-solving skills involving complex data and systems
Excellent communication skills and ability to develop business partnerships and document initiatives clearly
Experience with Ab Initio for enterprise-scale ETL development is a plus

Benefits

Comp & perks

Performance-based cash incentive awards
Health insurance from the first day of employment for employees and eligible family members
401(k) dollar-for-dollar matching up to the first 5% of eligible pay
Paying it Forward Savings Program contributions for employees with student loan debt
Pension Plan 100% funded by Travelers
Minimum of 20 days Paid Time Off annually
Nine paid company holidays
Wellness program with tools, discounts, resources, health coaching, and caregiving support
Free professional counseling services and mental health resources
Matching Gift and Volunteer Rewards program