Data Engineer II (AbInitio/Snowflake/AWS/ETL Performance)

Data Analytics, 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

$123,000.00 - $203,000.00

1

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 within Data & Analytics field; Experience with ETL Data Integration, Data Lake, Cloud Data warehouse and Performance Tuning is preferred
• Hands-on technical: This is a role requires data engineering hands on with the ability to drive engineering solutions, independently perform investigation and PoC and resolve technical issues.
• Ab Initio / ETL SME: Serves as the Ab Initio and other ETL Claim SME and support admin, environment, system upgrades, best practice, reusable patterns, consultation to development, design and coding issues.
• Data Engineer Tools and Platforms: Administrates tools and platforms, supports user and application onboarding with guidance and best practices focus on Ab Initio, Snowflake, AWS, and other ETL.
• Performance Optimization: Has working experiences with complex data analytics application performance tuning and optimization with a focus on Ab Initio, Snowflake, AWS, and other ETL.
• Snowflake / AWS FinOps: has working experiences or exposure to Snowflake / AWS FinOps and cost optimization.
• SQL Tuning: Proficient in SQL and understand how to use query metrics to evaluate performance and tune SQL to improve query run time.
• 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 innovate ways to resolve issues.
• Strong written and verbal communication skills with the ability to work collaborate well 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.

What is a Must Have?

• Bachelor’s degree or equivalent training with data tools, techniques, and manipulation.
• Four years of data engineering or equivalent experience.