Data Engineer - II (AWS, Python, Databricks, Datawarehouse)

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 160 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, 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

Target Openings

1

What Is the Opportunity?

Travelers BI Modernization 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, data analytics 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.
• Providing technical leadership: Staying up to date on trends and technologies to help the team develop effective solutions.
• Mentoring and Providing guidance to a team of data engineers.
• Empowering team members. Providing team members with autonomy and ownership over their work.
• Strong knowledge and hands-on skills on Databricks, Python , Snowflake and AWS/Cloud for building data pipelines.
• 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.
• Supporting BI Mod Ingestion and data domains ecosystem job monitoring, defect fixing and currency up grades.
• 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

• Technical role hands on experience leading team with AWS, Python, Databricks, Datawarehouse

• Demonstrate asset ownership and operational excellence in all aspects of data engineering tasks and responsibilities.

• Develop and utilize common components and patterns for managing and accessing data

• Utilize data quality tools and frameworks to monitor and improve data quality(e.g. accuracy, completeness, consistency, timeliness, uniqueness, validity)

• Explore and adopt AI for tasks such as code generation, testing, debugging, and performance optimization throughout the development lifecycle to improve development processes, enhance efficiency, and quality

• Demonstrate understanding of business areas supported and understanding of how the data will be used as well as the overall business context and value.

• Mentors team members through assigned tasks and others outside the team in their development

• Contributes to existing engineering practices and participates in Engineering Chapter events

• Eight years of related experience

• 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 domai