Data Engineer II — Snowflake, DBT & AWS

Travelers; Hartford (CT); On-site; USD 127,000 - 209,000; Full time

Benefits offered by this job

Health Insurance

401(k) Matching

Paid Time Off

Wellness Program

Volunteer Rewards

Job summary

Travelers is seeking a Data Engineer to join the Data Engineering team. You will build, optimize, and operationalize data solutions that support AI, ML, and BI initiatives across the enterprise.

Lead data modeling, warehousing, and pipelines, translating source system releases into stable data models and ensuring data quality and governance across platforms. A strong SQL/dbt background and collaboration with upstream teams are essential.

Qualifications

• Bachelor’s degree in STEM field or equivalent.
• Eight years of related experience.
• Translate incremental source system releases into stable data models across two platforms.
• Design a unified analytics data layer for downstream BI consistency.
• Proven experience with data warehousing and multi-layer data architectures.
• Hands-on Snowflake experience with views/streams.
• Strong SQL and dbt experience.
• Data mapping/virtualization and performance optimization.
• Experience with systems migration/integration across platforms.
• Strong written and verbal communication.

Responsibilities

• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
• Design complex data solutions.
• Analyze complex sources to determine value and inclusion in analytics.
• Incorporate data governance, security and quality competencies.
• Collaborate across teams to support delivery and educate end users on data products.
• Analyze and resolve complex defects and incidents; implement fixes.
• Test data movement, transformation code, and data components.
• Perform other duties as assigned.

Skills

SQL

Data pipelines

Data modeling

Data analysis

Communication

Collaboration

Education

Bachelor’s Degree in STEM related field or equivalent

Tools

Snowflake

dbt

Job description

Travelers is seeking a Data Engineer to join the Data Engineering team. You will build, optimize, and operationalize data solutions that support AI, ML, and BI initiatives across the enterprise.

Lead data modeling, warehousing, and pipelines, translating source system releases into stable data models and ensuring data quality and governance across platforms. A strong SQL/dbt background and collaboration with upstream teams are essential.