Data Engineer II: Snowflake, dbt & AWS Specialist

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

Benefits offered by this job

Health Insurance

401(k) Matching

Paid Time Off (PTO)

Wellness Program

Volunteer Encouragement

Job summary

The Travelers Indemnity Company seeks a seasoned Data Engineer in the Hartford area to design and operate enterprise data pipelines, enabling analytics across the organization. You will translate business questions into scalable data solutions using Snowflake, SQL, and dbt to support AI, machine learning and BI initiatives.

You will collaborate with engineering teams and business partners, ensuring data governance, quality and security across multi-layer data architectures while contributing to

Qualifications

• Bachelor’s Degree in STEM or related field required.
• Eight years of related data engineering experience.
• Proven experience with data warehousing, data pipelines, and analytics.
• Experience with Snowflake, SQL, and dbt in complex environments.

Responsibilities

• Build and operationalize complex data solutions and data cleansing/quality improvements.
• Design complex data solutions and data models for analytics.
• Analyze complex data sources to determine value and inclusion in analytical processes.
• Incorporate data governance, security, and quality best practices.
• Collaborate with cross-functional teams to deliver data products and educate end users.
• Perform data and system analysis, resolve defects, and ensure robust pipelines.
• Test data movement and transformations and ensure data components meet requirements.

Skills

Snowflake

SQL

dbt

Data warehousing

Data pipelines

Data governance

Data security

Data quality

Data mapping

Data virtualization

Systems migration

Cross-team collaboration

Communication

Education

Bachelor’s Degree in STEM/Computer Science or related field

Job description

The Travelers Indemnity Company seeks a seasoned Data Engineer in the Hartford area to design and operate enterprise data pipelines, enabling analytics across the organization. You will translate business questions into scalable data solutions using Snowflake, SQL, and dbt to support AI, machine learning and BI initiatives.

You will collaborate with engineering teams and business partners, ensuring data governance, quality and security across multi-layer data architectures while contributing to