Data Engineer II - Snowflake, dbt, AWS

Who Are We? Taking care of our customers, our communities and each other. That’s the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the best property casualty insurers in the industry for over 170 years. Join us to discover a culture that is rooted in innovation and thrives on collaboration. Imagine loving what you do and where you do it. Job Category Data Analytics, Data Science, Technology Compensation Overview The annual base salary range provided for this position is a nationwide market range and represents a broad range of salaries for this role across the country. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. As part of our comprehensive compensation and benefits program, employees are also eligible for performance-based cash incentive awards. Salary Range $126,500.00 - $208,700.00 Target Openings 1 What Is the Opportunity? 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 stories found in data by leveraging a variety of data programming techniques. 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. What Will You Do? Build and operationalize complex data solutions, correct problems, apply transformations, and recommending data cleansing/quality solutions. Design complex data solutions Perform analysis of complex sources to determine value and use 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 complex data products/analytic environment. Perform data and system analysis, assessment and resolution for complex defects and incidents and correct as appropriate. Test data movement, transformation code, and data components. Perform other duties as assigned. What Will Our Ideal Candidate Have? Bachelor’s Degree in STEM related field or equivalent. Eight years of related experience. Partner with upstream engineering teams to translate incremental source system releases into stable, consumer-ready data models — including managing schema drift, field migrations, and value mapping across two concurrently active platforms Contribute to the design of a unified analytics data layer that gives downstream BI consumers a consistent view of claim data regardless of which source system it originated from, handling field-level translation and format normalization transparently Proven experience with data warehousing and data consumption, including the design and management of multi-layer data architectures and data pipelines. Hands-on proficiency with Snowflake , including working with views, streams, and other core platform features to support scalable data solutions. Strong SQL skills and practical experience with dbt for data transformation, schema management, and building on top of existing data pipelines. Demonstrated ability to perform data mapping, data virtualization, and optimize query and pipeline performance within complex data environments. Experience with systems migration and integration, including translating and transforming data across platforms to ensure seamless interoperability. Demonstrated track record of domain expertise including understanding technical concepts necessary and industry trends, and possess in-depth knowledge of