Data Engineer I - Cloud Data Modernization - AWS, Databricks, DBT, SQL, AI

Travelers; United States; On-site; USD 109,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Pension plan

Paid time off

Wellness program

Volunteer program

Job summary

Travelers Data Engineering team is hiring a Data Engineer to build and deploy data solutions that support AI, ML, and BI initiatives across the enterprise. You will translate data stories into scalable pipelines, applying governance and quality controls as you collaborate with partners and stakeholders.

The ideal candidate brings 6 years of experience, strong SQL, and hands-on work with dbt, Databricks, PySpark, and AWS in a data-driven environment.

Qualifications

• Bachelor's degree in STEM field or equivalent.
• Six years of related experience.
• Experience in data transformation using the dbt tool and/or Databricks PySpark.
• Experience building data pipelines using AWS cloud services and Databricks.
• Experience using AI tools to improve productivity.
• Strong skills in SQL.
• Experience interacting with business partners on requirements, design, and solutions.
• Proficient use of cloud platforms and programming languages.
• Ability to deliver work at a steady, predictable pace and decompose work into small releases.
• Demonstrated domain expertise and understanding of systems.
• Proven problem-solving and debugging skills.
• Strong verbal and written communication.
• Leadership – intermediate with self-motivation.

Responsibilities

• Build and operationalize complex data solutions and ensure data quality.
• Design data solutions for analytics needs.
• Analyze data sources and determine value for analytical processes.
• Incorporate data governance, security, and quality practices.
• Collaborate across teams to support delivery and educate end users.
• Perform data and system analysis and resolve defects.
• Test data movement and transformations.
• Perform other duties as assigned.

Skills

Data pipelines

SQL

AI tools

Data transformation (dbt)

Databricks PySpark

AWS

Data governance

Collaboration

Communication

Problem solving

Leadership

Education

Bachelor's degree in Computer Science / STEM

Tools

dbt

Databricks

PySpark

AWS

Job description

Who Are We?

Taking care of our customers, our communities and each other. That is 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 170 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, Data Science, 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 $109,300.00 - $180,200.00

Target Openings 1

What Is the Opportunity?

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 the stories found in data. 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.

Applicants must be authorized to work for ANY employer in the U.S. The company does not sponsor/support H-1B petitions, TN, or Forms I-983/STEM OPT, for this role.

What Will You Do?

• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
• Design data solutions.
• Analyze sources to determine value 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 data products/analytic environment.
• Perform data and system analysis, assessment and resolution for defects and incidents of moderate complexity 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.
• Six years of related experience.
• Experience in data transformation using the dbt tool and/or Databricks PySpark.
• Experience building data pipelines using AWS cloud services and Databricks.
• Experience using AI tools and solutions to improve productivity.
• Strong skills in writing complex SQL queries.
• Experience interacting with business partners on requirements, design, and solutions.
• Proficient use of tools, techniques, and manipulation including Cloud platforms, programming languages, and an understanding of software engineering practices.
• The ability to deliver work at a steady, predictable pace to achieve commitments, decompose work assignments into small batch releases, and contribute to tradeoff and negotiation discussions.
• Demonstrated track record of domain expertise including the ability to understand technical concepts and possess in-depth knowledge of immediate systems worked on.
• Proven problem solving skills including debugging skills, allowing you to determine source of issues in unfamiliar code or systems and the ability to recognize and solve repetitive problems.
• Strong verbal and written communication skills with the ability to interact with team members and business partners.
• Leadership - Intermediate leadership skills with a proven track record of self-motivation in identifying personal growth opportunities.

What is a Must Have?

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

What Is in It for You?

• 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. When you make a payment toward your student loan, Travelers will make an annual contribution into your 401(k) account.
• You are also eligible for a Pension Plan that is 100% funded by Travelers.
• 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 is comprised of tools, discounts and resources that empower you to achieve your wellness goals and caregiving needs. In addition, our mental health program provides access to free professional counseling services, health coaching and other resources to support your daily life needs.
• Volunteer Encouragement: We have a deep commitment to the communities we serve and encourage our employees to get involved. Travelers has a Matching Gift and Volunteer Rewards program that enables you to give back to the charity of your choice.

Employment Practices

Travelers is an equal opportunity employer. We value the unique abilities and talents each individual brings to our organization and recognize that we benefit in numerous ways from our differences.

In accordance with local law, candidates seeking employment in Colorado are not required to disclose dates of attendance at or graduation from educational institutions.

If you are a candidate and have specific questions regarding the physical requirements of this role, please send us an email so we may assist you.

Travelers reserves the right to fill this position at a level above or below the level included in this posting.

To learn more about our comprehensive benefit programs please visit http://careers.travelers.com/life-at-travelers/benefits/.

Travelers Network and Recognition

Travelers has more than 30,000 employees in the United States, Canada, the United Kingdom, and Ireland.

Open to all employees, our 10 Diversity Networks celebrate culture and communities and create spaces for all employees through powerful forums for dialogue and support.

Employees and their eligible family members - including spouses, domestic partners and children - are eligible for coverage from the first day of employment.

Travelers has been recognized by organizations such as G.I. Jobs and Military Times.

Our employees are valuable assets to their hometowns, volunteering for important causes each year.

Explore Resources

> Explore life at Travelers .

> Discover diversity and inclusion.

> Explore benefits .

> Read more about recognition.

> Learn about community involvement.

Imagine other opportunities here.