Data Engineer II; Snowflake, Databricks, Ab Initio

Job Category:
Data Analytics, Data Science, Technology.

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, translating stories found in data by leveraging a variety of data programming techniques and designing, building, and deploying data solutions that support artificial intelligence, machine learning, and business intelligence/insights.

• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend 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.

• Bachelor’s Degree in STEM related field or equivalent.
• Eight years of related experience.
• Expert-level experience designing, developing, and maintaining scalable data pipelines and ETL/ELT workflows using Snowflake, Databricks, and Ab Initio platforms.
• Strong programming skills in Python, SQL, and Spark with experience optimizing complex queries and data transformations for performance and cost efficiency.
• Experience with data quality frameworks, data governance practices, and implementing monitoring and alerting solutions for data pipelines.
• Highly proficient use of tools, techniques, and manipulation including Cloud platforms, programming languages, and a full understanding of modern software engineering practices.
• The ability to deliver work at a steady, predictable pace to achieve commitments, deliver complete solutions but release them in small batches, and identify and negotiate important tradeoffs.
• Demonstrated track record of domain expertise including understanding technical concepts necessary and industry trends, and possess in-depth knowledge of immediate systems worked on and some knowledge of adjacent systems.
• Strong problem solver who ensures systems are built with longevity and creates innovative ways to resolve issues.
• Strong written and verbal communication skills with the ability to work collaboratively with team members and business partners.
• Ability to lead team members and help create a safe environment for others to learn and grow as engineers, and a proven track record of self-motivation in identifying opportunities and tracking team efforts.

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

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: $ - $

• 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.
• Paid Time Off:
  Minimum of 20 days PTO annually, plus nine paid company holidays.
• Wellness Program:
  Tools, discounts and resources that…