Data Engineer II - Snowflake, dbt, AWS

Travelers is a property casualty insurer with a culture rooted in innovation, collaboration, and service to customers and communities. The Data Engineer II will design, build, deploy, and operationalize complex data solutions and pipelines using Snowflake, dbt, SQL, and AWS-related technologies to support analytics, artificial intelligence, machine learning, and business intelligence. The role also involves data governance, quality, transformation, testing, systems integration, and collaboration with engineering teams and business partners.

Responsibilities

Build and operationalize complex data solutions, correct problems, apply transformations, and recommending data cleansing/quality solutions

Design complex data solutions

Perform analysis of complex sources to determine value and use and recommend data to include in analytical processes

Incorporate core data management competencies including data governance, data security and data quality

Collaborate within and across teams to support delivery and educate end users on complex data products/analytic environment

Perform data and system analysis, assessment and resolution for complex defects and incidents and correct as appropriate

Test data movement, transformation code, and data components

Perform other duties as assigned

Benefits

Employees and their eligible family members – including spouses, domestic partners, and children – are eligible for health insurance coverage from 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 with student loan debt can enroll in the Paying it Forward Savings Program, under which Travelers makes an annual contribution into their 401(k) account when the employee makes a payment toward their student loan.

Employees are eligible for a Pension Plan that is 100% funded by Travelers.

A minimum of 20 days of Paid Time Off annually, plus nine paid company Holidays.

The Travelers wellness program provides tools, discounts and resources to support wellness goals and caregiving needs.

The mental health program provides access to free professional counseling services, health coaching and other resources.

The Matching Gift and Volunteer Rewards program enables employees to give back to the charity of their choice.

Employees are eligible for performance-based cash incentive awards.

Hybrid work arrangement

Company

Property and casualty insurance for homes, cars, valuables, businesses

New York, New York, USA

https://www.travelers.com/

Founded in 1853

10001+ employees

Qualifications

Bachelor's Degree in STEM related field or equivalent

Eight years of related experience

Partner with upstream engineering teams to translate incremental source system releases into stable, consumer-ready data models — including managing schema drift, field migrations, and value mapping across two concurrently active platforms

Contribute to the design of a unified analytics data layer that gives downstream BI consumers a consistent view of claim data regardless of which source system it originated from, handling field-level translation and format normalization transparently

Proven experience with data warehousing and data consumption, including the design and management of multi-layer data architectures and data pipelines

Hands-on proficiency with Snowflake, including working with views, streams, and other core platform features to support scalable data solutions

Strong SQL skills and practical experience with dbt for data transformation, schema management, and building on top of existing data pipelines

Demonstrated ability to perform data mapping, data virtualization, and optimize query and pipeline performance within complex data environments

Experience with systems migration and integration, including translating and transforming data across platforms to ensure seamless interoperability

Demonstrated track record of domain expertise including understanding technical concepts necessary and industry trends, and possess in-depth knowledge of immediate systems worked on and some knowledge of adjacent systems

Strong problem solver who ensures systems are built with longevity and creates innovate ways to resolve issues

Strong written and verbal communication skills with the ability to work collaborate well with team members and business partners

Bachelor's degree in computer science, related STEM field, or its equivalent in education and/or work experience

4 additional years of data engineering experience

Eight years of related experience.

Required skills

Data Warehousing, Data Pipelines, Snowflake, SQL, dbt, Data Mapping, Data Virtualization, Query and Pipeline Performance Optimization, Systems Migration and Integration, Data Architecture

Preferred skills

Written and Verbal Communication

Experience

4+ years