Data Engineer I (Snowflake)

Travelers•Hartford, AR

About The Position

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 the stories found in data. 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. Applicants must be authorized to work for ANY employer in the U.S. The company does not sponsor/support H-1B petitions, TN, or Forms I-983/STEM OPT, for this role.

Requirements

Bachelor’s degree in computer science, related STEM field, or its equivalent in education and/or work experience.
2 additional years of software/data engineering experience.

Nice To Haves

Bachelor’s Degree in STEM related field or equivalent.
Six years of related experience.
4–7+ years in data engineering or analytics engineering
Proven Snowflake DBA or platform administration background
Data governance, security, and access control framework experience
Vendor/contract resource collaboration and technical oversight
Mentorship or informal technical leadership experience
Advanced SQL Snowflake — DBA-level (strongly preferred)
Data Governance tools (Alation, DataHub, Unity Catalog, or Snowflake-native)
Terraform — IaC for cloud resource provisioning
CI/CD pipeline knowledge and troubleshooting
AI Tools — Active use of AI-assisted development tools (GitHub Copilot, ChatGPT, Claude etc.) to accelerate coding, debugging, and documentation; comfort integrating AI into day-to-day engineering workflows
Python — Pipeline scripting, automation, data transformation, and API integrations; clean, maintainable code with awareness of best practices
Databricks — Workspace and cluster management, notebook-based development, Delta Lake, and experience supporting teams working within Databricks environments
dbt — Building and maintaining dbt projects including models, tests, sources, macros, and documentation; familiarity with dbt best practices and project structure
AWS Basics — Working knowledge of core AWS services relevant to data workflows: S3, IAM, Lambda, and Terraform; AWS Cloud Practitioner certification or equivalent hands-on experience
Proficient use of tools, techniques, and manipulation including Cloud platforms, programming languages, and an understanding of software engineering practices.
The ability to deliver work at a steady, predictable pace to achieve commitments, decompose work assignments into small batch releases, and contribute to tradeoff and negotiation discussions.
Demonstrated track record of domain expertise including the ability to understand technical concepts and possess in-depth knowledge of immediate systems worked on.
Proven problem solving skills including debugging skills, allowing you to determine source of issues in unfamiliar code or systems and the ability to recognize and solve repetitive problems.
Strong verbal and written communication skills with the ability to interact with team members and business partners.
Leadership - Intermediate leadership skills with a proven track record of self-motivation in identifying personal growth opportunities.
Clear communicator across technical and business audiences
Effective in mixed internal/vendor team environments
Self-directed with strong problem ownership
Collaborative mentor and knowledge-sharer

Responsibilities

Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
Design data solutions.
Analyze sources to determine value 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 data products/analytic environment.
Perform data and system analysis, assessment and resolution for defects and incidents of moderate complexity and correct as appropriate.
Test data movement, transformation code, and data components.
Database Admin & Governance Snowflake DBA: warehouses, RBAC, resource monitors, tuning
Design and enforce role-based access control and least-privilege security
Lead data governance: classification, tagging, and lineage tracking
Collaborate with security and compliance teams on platform posture
Audit access logs and respond to security requests
Platform Support & Administration LOB admin across Snowflake, Databricks, and AWS-based services
Configuration, environment setup, and access management
Troubleshoot CI/CD and HSP pipeline failures
Monitor and optimize platform performance and cost
Development & Engineering Build and maintain dbt models, Python pipelines, and Terraform IaC
Write advanced SQL for data modeling and analytics use cases
Contribute to reusable frameworks and internal tooling
Advisory, Mentorship & Leadership Onboard new projects and guide teams on best practices
Mentor internal staff and vendor/contract resources
Lead workstreams and set technical direction when needed
Review vendor deliverables and ensure alignment to standards
Collaborate cross-functionally with dev, analytics, and product teams
Perform other duties as assigned.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume