3 months ago
Hartford, CT, USA +2 moreMid Level
Base Salary
$127k - $209k/yr
Responsibilities
- Build and operationalize complex data solutions, pipelines, transformations, and data cleansing and quality processes.
- Design data solutions and perform analysis of complex data sources to determine their value and use in analytical processes.
- Partner with upstream engineering teams to manage schema drift, field migrations, value mapping, and data translation across concurrently active source platforms.
- Contribute to a unified analytics data layer that provides downstream BI consumers with consistent claim data across source systems.
- Apply data governance, data security, data quality, data mapping, data virtualization, and data management practices.
- Use Snowflake views, streams, and other platform features to support scalable data solutions.
- Use dbt and SQL for data transformation, schema management, and development on existing data pipelines.
- Perform data and system analysis, defect and incident resolution, systems migration, integration, and performance optimization.
- Test data movement, transformation code, and data components.
- Collaborate across teams, support delivery, and educate end users on complex data products and analytics environments.
Requirements
- Bachelor’s degree in computer science, a related STEM field, or equivalent education and/or work experience.
- At least four additional years of data engineering experience.
- Eight years of related experience is listed among the ideal qualifications.
- Hands-on proficiency with Snowflake, including views, streams, and other core platform features.
- Strong SQL skills and practical experience with dbt for data transformation, schema management, and pipeline development.
- Experience with data warehousing, data consumption, multi-layer data architectures, data pipelines, data mapping, data virtualization, and performance optimization.
- Experience with systems migration and integration, including translating and transforming data across platforms.
- Domain expertise, knowledge of immediate and adjacent systems, strong problem-solving ability, and strong written and verbal communication skills.
Benefits
- Health insurance for eligible employees and family members from the first day of employment.
- Dollar-for-dollar 401(k) matching up to the first 5% of eligible pay, subject to an annual maximum.
- Paying it Forward Savings Program contributions for eligible employees with student loan payments.
- A Travelers-funded pension plan.
- At least 20 days of paid time off annually plus nine paid company holidays.
- Wellness resources, discounts, caregiving support, and free professional mental health counseling services.
- Matching Gift and Volunteer Rewards programs.
- The posting provides a nationwide annual base salary range of $126,500.00-$208,700.00; work arrangement is not stated.
About Travelers
Travelers is a public property and casualty insurer that provides auto, home, and commercial coverage, plus risk management and claims services, to individuals and businesses. It distributes policies through independent agents and brokers across the United States, Canada, the United Kingdom, and Ireland. Founded in 1853 and headquartered in New York City, Travelers trades on the NYSE (TRV) and is the only property-casualty company in the Dow Jones Industrial Average.