Data Engineer I (Snowflake)

Join a company with a long-standing commitment to customers, communities, and colleagues. This on-site Data Engineer I role in Hartford, CT offers a competitive salary range of USD 109,300 to 180,200 per year, a strong focus on Snowflake platform administration, and a culture that values innovation, collaboration, and ownership. The opportunity centers on designing, building, and deploying data solutions that power AI, ML, and enterprise business intelligence across Travelers.

Location is Hartford, CT (onsite). The position emphasizes Snowflake expertise to evolve Travelers' analytics landscape while working within a team that supports growth and cross-functional education on data products and analytic environments.

Benefits

• Health Insurance
• Retirement
• Paid Time Off
• Wellness Program
• Volunteer Encouragement

Responsibilities

• Build and operationalize complex data solutions, diagnose issues, apply transformations, and recommend data cleansing and quality improvements.
• Design data solutions and evaluate sources to determine value and what data to include in analytics processes.
• Incorporate core data management practices including governance, security, and data quality.
• Collaborate across teams to support delivery and educate end users on data products and the analytics environment.
• Analyze data and systems to identify defects and incidents of moderate complexity and implement appropriate resolutions.
• Test data movement, transformation code, and data components to ensure accuracy and reliability.
• Snowflake DBA responsibilities: manage warehouses, RBAC, resource monitors, and tuning.
• Enforce role-based access control and least-privilege security across platforms.
• Lead data governance efforts including classification, tagging, and lineage tracking.
• Work with security and compliance teams to maintain platform posture; audit access logs and respond to requests.
• Platform support and administration across Snowflake, Databricks, and AWS-based services; configure environments and manage access.
• Troubleshoot CI/CD and HSP pipeline issues; monitor and optimize platform performance and cost.
• Develop and maintain dbt models, Python pipelines, and Terraform infrastructure as code; write advanced SQL for analytics use cases.
• Contribute to reusable frameworks and internal tooling; collaborate with dev, analytics, and product teams.
• Onboard new projects, mentor teams, lead workstreams, and review vendor deliverables to ensure standards alignment.
• Perform other duties as assigned.

Requirements

• Bachelor’s Degree in a STEM field or equivalent.
• Six years of related experience.
• 4–7+ years in data engineering or analytics engineering.
• Proven Snowflake DBA or platform administration background.
• Experience with data governance, security, and access control frameworks.
• Experience collaborating with vendor/contract resources and providing technical oversight.
• Mentorship or informal leadership experience.
• Advanced SQL skills.
• Snowflake DBA-level expertise strongly preferred.
• Experience with data governance tools such as Alation, DataHub, Unity Catalog, or Snowflake-native tools.
• Terraform for cloud resource provisioning (IaC).
• CI/CD pipeline knowledge and troubleshooting.
• Experience using AI tools to accelerate coding, debugging, and documentation; comfortable integrating AI into workflows.
• Python for pipeline scripting, automation, data transformation, and API integrations with clean, maintainable code.
• Databricks experience including workspace and cluster management, notebook-based development, and Delta Lake familiarity.
• dbt project experience, including models, tests, sources, macros, and documentation.
• AWS basics covering S3, IAM, Lambda, and Terraform; AWS Cloud Practitioner certification or hands-on experience.
• Proficiency with cloud platforms, programming languages, and software engineering practices.
• The ability to deliver work at a steady, predictable pace and decompose work into small releases; participate in tradeoff discussions.
• Strong domain expertise and in-depth knowledge of the systems you work on.
• Proven problem solving and debugging skills to identify issues in unfamiliar code or systems.
• Excellent verbal and written communication across technical and business audiences.
• Intermediate leadership capabilities with self-motivation for personal growth.
• Clear communicator in mixed internal and vendor environments; self-directed with strong ownership; collaborative mentor.
• Ability to work effectively in cross-functional teams and mentor others.
• Compliance with Travelers employment practices and policies.

Technologies

• Snowflake
• Databricks
• AWS (S3, IAM, Lambda)
• dbt
• Python
• Terraform
• SQL
• Delta Lake
• GitHub Copilot
• ChatGPT
• Claude
• Alation
• DataHub
• Unity Catalog