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.

Bachelor’s Degree in STEM related field or equivalent.
Six years of related experience.
Experience with ETL tools, including Talend, Informatica, and/or Ab Initio.
1+ years of experience with Spark and/or PySpark (required).
Proficiency in SQL across multiple platforms, including Oracle, Teradata, SQL Server, and/or PostgreSQL.
Experience with cloud and data platforms such as AWS, Databricks, and Snowflake.
Demonstrated ability to partner and collaborate effectively with technical stakeholders.
Experience with ETL development in data lake and data warehouse (preferably Snowflake).
Exhibited hands-on experience in building data pipelines and reusable components using AWS Services and PySpark, and Snowflake within the last two years.
Proficient use of tools, techniques, and manipulation including Cloud platforms, programming languages, and an understanding of data 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.
Strong verbal and written communication skills with the ability to interact with team members and business partners.

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.

Data Engineer I, ETL, PySpark, SQL

Key skills