Data Engineer II (Snowflake, AWS, DBT)

Reposted 8 Hours Ago
3 Locations
In-Office
127K-209K Annually
Senior level
Insurance
The Role
As a Data Engineer II, you will design and operationalize complex data solutions, focusing on data transformation, governance, and collaboration across teams to enhance analytics capabilities.
Summary Generated by Built In
Who Are We?

Taking care of our customers, our communities and each other. That’s the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the best property casualty insurers in the industry for over 170 years. Join us to discover a culture that is rooted in innovation and thrives on collaboration. Imagine loving what you do and where you do it.

Job Category
Technology

Compensation Overview

The annual base salary range provided for this position is a nationwide market range and represents a broad range of salaries for this role across the country. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. As part of our comprehensive compensation and benefits program, employees are also eligible for performance-based cash incentive awards.

Salary Range$126,500.00 - $208,700.00

Target Openings
1

What Is the Opportunity?
Travelers Data Engineering team constructs pipelines that contextualize and provide easy access to data by the entire enterprise. As a Data Engineer, you will play a key role in growing and transforming our analytics landscape. In addition to your strong analytical mind, you will bring your inquisitive attitude and ability to translate stories found in data by leveraging a variety of data programming techniques. You will leverage your ability to design, build and deploy data solutions that capture, explore, transform, and utilize data to support Artificial Intelligence, Machine Learning and business intelligence/insights.What Will You Do?
  • 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.
What Will Our Ideal Candidate Have?
  • Bachelor’s Degree in STEM related field or equivalent.
  • Eight years of related experience.
  • 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.
What is a Must Have?
  • 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.
What Is in It for You?
  • Health Insurance: Employees and their eligible family members – including spouses, domestic partners, and children – are eligible for coverage from the first day of employment.
  • Retirement: Travelers matches your 401(k) contributions dollar-for-dollar up to your first 5% of eligible pay, subject to an annual maximum. If you have student loan debt, you can enroll in the Paying it Forward Savings Program. When you make a payment toward your student loan, Travelers will make an annual contribution into your 401(k) account. You are also eligible for a Pension Plan that is 100% funded by Travelers.
  • Paid Time Off: Start your career at Travelers with a minimum of 20 days Paid Time Off annually, plus nine paid company Holidays.
  • Wellness Program: The Travelers wellness program is comprised of tools, discounts and resources that empower you to achieve your wellness goals and caregiving needs. In addition, our mental health program provides access to free professional counseling services, health coaching and other resources to support your daily life needs.
  • Volunteer Encouragement: We have a deep commitment to the communities we serve and encourage our employees to get involved. Travelers has a Matching Gift and Volunteer Rewards program that enables you to give back to the charity of your choice.
Employment Practices

Travelers is an equal opportunity employer. We value the unique abilities and talents each individual brings to our organization and recognize that we benefit in numerous ways from our differences. 

In accordance with local law, candidates seeking employment in Colorado are not required to disclose dates of attendance at or graduation from educational institutions.

If you are a candidate and have specific questions regarding the physical requirements of this role, please send us an email so we may assist you.

Travelers reserves the right to fill this position at a level above or below the level included in this posting.

To learn more about our comprehensive benefit programs please visit http://careers.travelers.com/life-at-travelers/benefits/.

Travelers Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Travelers and has not been reviewed or approved by Travelers.

  • Retirement Support Feedback suggests total rewards are bolstered by a 401(k) match, a company‑funded pension, and a program that contributes to retirement savings when employees make student‑loan payments. These elements are consistently portrayed as standout strengths of the package.
  • Leave & Time Off Breadth Feedback suggests time off is generous from the start, with substantial PTO, paid holidays, and the option to purchase additional days. Defined leaves such as short‑term disability and bereavement further enhance perceived flexibility.
  • Healthcare Strength Feedback suggests medical, dental, and vision coverage is comprehensive, with multiple plan choices, HSAs/FSAs, and robust mental‑health and wellness resources. Day‑one eligibility and added programs like caregiver support and specialty care navigation reinforce depth.

Travelers Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
35,118 Employees

What We Do

Travelers provides insurance coverage to protect the things that are important to you – your home, your car, your valuables and your business. We have been around for more than 165 years and have earned a reputation as one of the best property casualty insurers in the industry because we take care of our customers, agents, brokers, communities and each other. Every day, our approximately 30,000 employees and 13,500 independent agents and brokers in the United States, Canada, the United Kingdom and Ireland help provide peace of mind to our customers. Our expertise and focus on innovation have made us an industry leader and the only property casualty company in the Dow Jones Industrial Average. Our history of advancements has propelled our company, and our industry, to deliver higher standards – from writing the first auto and space travel policies to founding the Travelers Institute for public policy and launching a hybrid car discount. By minimizing risk, preventing loss and helping our customers prepare for the unknown, Travelers’ comprehensive products and services enable individuals and businesses to feel confident and secure about the future.

Similar Jobs

MetLife Logo MetLife

Customer Care Advocate Disability Service Omaha 6.1.26

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
20-20 Hourly

MetLife Logo MetLife

Director, Sr. Relationship Manager - Agricultural Investments, Food and Agribusiness Southeast Region Office

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
155K-190K Annually

PwC Logo PwC

AI Commercial Strategy Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
36 Locations
370000 Employees
151K-187K Annually

PwC Logo PwC

Product Owner

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
59 Locations
370000 Employees
151K-187K Annually

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana
Granted Thumbnail
Mobile • Insurance • Healthtech • Financial Services • Artificial Intelligence
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account