✦ Luna Orbit — Data & Analytics

Data Engineer II (Snowflake, AWS, DBT)

at Travelers

📍 3 Locations Hybrid 💰 $126K – $208K USD / year Posted April 16, 2026
Salary $126K – $208K USD / year
Type Full-Time
Experience mid
Exp. Years Eight years of related experience.
Education Bachelor's Degree in STEM related field or equivalent
Category Data & Analytics

Travelers is seeking a Data Engineer II to help build and transform its enterprise analytics ecosystem. The role focuses on designing and operationalizing data pipelines for warehousing and analytics, including testing data movement and transformations.

  • Build and operationalize complex data solutions
  • Design complex data solutions and recommend data cleansing/quality improvements
  • Apply data governance, data security, and data quality competencies
  • Test data movement, transformation code, and data components
  • Perform analysis and resolve complex defects and incidents

You will work on data pipelines and multi-layer data architectures with strong Snowflake expertise, including views and streams. The stack includes SQL and dbt for transformation and schema management, with responsibilities spanning data governance, data security, and data quality to support AI/ML and business intelligence use cases.

The ideal candidate is a mid-level Data Engineer II with 8+ years of experience building data pipelines and designing multi-layer data architectures for data warehousing and data consumption. They have hands-on Snowflake expertise (views and streams) and strong SQL plus dbt experience for data transformation and schema management.

Eight years of related experienceProven experience with data warehousing and data consumptionincluding the design and management of multi-layer data architectures and data pipelines.Hands-on proficiency with Snowflakeincluding working with viewsstreamsand other core platform features to support scalable data solutions.Strong SQL skills and practical experience with dbt for data transformationschema management
SnowflakedbtSQL
SnowflakeviewsstreamsSQLdbtdata transformationschema managementdata governancedata securitydata qualitydata pipelinesdata warehousing
data engineeringdata pipelinesdata warehousingdata consumptionmulti-layer data architecturesSnowflakeviewsstreamsSQLdbtdata transformationschema managementdata governancedata securitydata qualitydata movementtesting data movementtesting transformation codetesting data componentsdata and system analysisassessment and resolution for defects and incidentsArtificial Intelligence (AI)Machine Learning (ML)business intelligencedata explorationdata capturedata utilizationoperationalize complex data solutionsrecommend data cleansing/quality solutionscollaborate to educate end users
translating stories found in datacollaborationanalytical thinkingeducating end userscommunicationproblem-solving
Industry Insurance
Job Function Engineer and operationalize Snowflake-based data pipelines that power analytics, AI, and Machine Learning.
Role Subtype Data Engineer
Tech Domains Amazon Web Services, Database Administration, SQL / PostgreSQL, Data Engineering, AI & Machine Learning, Snowflake
Data Engineer IIdata pipelinesdata warehousingdata consumptionmulti-layer data architecturesSnowflakeviewsstreamsSQLdbtdata transformationschema managementdata governancedata securitydata qualitydata movementdefects and incidentsArtificial IntelligenceAIMachine LearningMLbusiness intelligence

Eight years of related experience, Hands-on proficiency with Snowflake including working with views and streams, Strong SQL skills and practical experience with dbt for data transformation and schema management

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile