Data Engineer - Sr. ETL Developer

$121,000 - $199,600/Yr

Travelers - Hartford, CT

Full-time - Mid Level

Hartford, CT

Insurance Carriers and Related Activities

About the position

Travelers is a leading property casualty insurer with a commitment to taking care of our customers, communities, and each other. As part of our Data Engineering team, you will play a pivotal role in constructing pipelines that contextualize and provide easy access to data across the enterprise. This position is designed for a Data Engineer who is eager to grow and transform our analytics landscape. You will leverage your analytical skills and inquisitive nature to translate data stories through various programming techniques. 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/insights. In this role, you will be tasked with building and operationalizing complex data solutions, correcting problems, applying transformations, and recommending data cleansing and quality solutions. You will perform analysis of complex data sources to determine their value and recommend data to include in analytical processes. Core data management competencies such as data governance, data security, and data quality will be essential in your work. Collaboration within and across teams will be crucial to support delivery and educate end users on complex data products and the analytic environment. You will also be responsible for performing data and system analysis, assessing and resolving complex defects and incidents, and testing data movement, transformation code, and data components. The ideal candidate will have a Bachelor's Degree in a STEM-related field or equivalent experience, with at least eight years of related experience. Proficiency in tools, techniques, and manipulation, including cloud platforms and programming languages, is required. You should have a strong problem-solving ability, excellent communication skills, and the capacity to lead team members while fostering a safe learning environment. Experience with ETL tools, SQL, AWS, Snowflake, source code management tools, CI/CD pipelines, process orchestration tools, infrastructure as code, Databricks, and Python/Pyspark is essential. This position offers a competitive salary range and a comprehensive benefits package, including health insurance, retirement plans, paid time off, wellness programs, and volunteer encouragement initiatives. Travelers is committed to fostering an inclusive workplace that reflects the diverse communities we serve, and we encourage candidates from all backgrounds to apply.

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.
• Proven track record of self-motivation in identifying opportunities and tracking team efforts.
• Experience with ETL tools, primarily Talend or similar (Ab Initio, Informatica).
• Experience with SQL (medium to complex queries).
• Experience with AWS (s3, Lambda, IAM, Glue, SNS, SQS, VPC, Athena, EC2, etc.), Snowflake.
• Experience with Source Code Management tools and best practices (similar to: Git, Git Actions, branch management).
• Working knowledge of CI/CD Pipelines (similar to: Jenkins, UCD).
• Experience with Process Orchestration Tools (similar to: AutoSys, Airflow, Step Functions).
• Experience with Infrastructure as Code (similar to: Terraform, CloudFormation).
• Experience with Databricks and Python/Pyspark.

Benefits

• Health Insurance: Coverage for employees and their eligible family members from the first day of employment.
• Retirement: 401(k) matching contributions dollar-for-dollar up to the first 5% of eligible pay, subject to an annual maximum, and a fully funded Pension Plan.
• Paid Time Off: Minimum of 20 days Paid Time Off annually, plus nine paid company Holidays.
• Wellness Program: Access to tools, discounts, and resources for wellness goals, including mental health support.
• Volunteer Encouragement: Matching Gift and Volunteer Rewards program to support charitable contributions.