Data Engineer II (Data & Analytics)

$121,000 - $199,600/Yr

Travelers - Hartford, WI

Full-time - Mid Level

Hartford, WI

Insurance Carriers and Related Activities

About the position

As a Data Engineer II at Travelers, you will be an integral part of the Data Engineering team, which is responsible for constructing pipelines that contextualize and provide easy access to data across the enterprise. This role is pivotal in growing and transforming our analytics landscape. You will leverage your strong analytical skills and inquisitive nature to translate complex data into actionable insights. Your responsibilities will include designing, building, and deploying data solutions that capture, explore, transform, and utilize data to support Artificial Intelligence, Machine Learning, and business intelligence initiatives. In this position, you will build and operationalize complex data solutions, troubleshoot issues, apply necessary transformations, and recommend data cleansing and quality solutions. You will also perform analysis on complex data sources to determine their value and recommend data to include in analytical processes. Core competencies in data management, including data governance, security, and quality, will be essential. Collaboration with various teams will be key to supporting delivery and educating end users on complex data products and the analytic environment. Additionally, you will be responsible for performing data and system analysis, assessing and resolving complex defects and incidents, and testing data movement and transformation code. This role requires a proactive approach to problem-solving and a commitment to building systems that are sustainable and innovative. You will also have the opportunity to lead team members, fostering a safe environment for learning and growth.

Responsibilities

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

Requirements

• Bachelor's Degree in STEM related field or equivalent.
• 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.
• 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 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.

Nice-to-haves

• Experience with one or more ETL / Data Integration tools (e.g.: Talend, Ab Initio, Informatica).
• Experience with one or more Data platforms (e.g.: Snowflake).
• Proficiency in understanding Relational and Dimensional data models.
• Exposure to building software solutions on Public Cloud such as AWS.
• Exposure to building data pipelines utilizing technologies and frameworks (Python, PySpark) would be a plus.
• Exposure with DevOps implementation practices.

Benefits

• Health Insurance: Employees and their eligible family members 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: Start your career at Travelers with a minimum of 20 days Paid Time Off annually, plus nine paid company Holidays.
• Wellness Program: The Travelers wellness program includes tools, discounts, and resources to achieve wellness goals and caregiving needs, along with access to free professional counseling services.
• Volunteer Encouragement: Travelers encourages employees to get involved in their communities with a Matching Gift and Volunteer Rewards program.