Data Engineer II (AWS, Databricks, SQL, GenAI)

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. You will translate stories found in data using a variety of data programming techniques and design, build, and deploy data solutions that support Artificial Intelligence, Machine Learning and business intelligence/insights. 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 data 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 and analytic environments. 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. What Will Our Ideal Candidate Have? Bachelor’s Degree in a STEM related field or equivalent. Eight years of related experience. Experience with Databricks (including integration with DBT and Unity Catalog), Databricks Genie, Ab Initio, Snowflake, AI (Claude Code), Teradata, and API development and integration into data pipelines. 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 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‑solving skills that ensure systems are built with longevity and create 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. A proven track record of self‑motivation in identifying opportunities and tracking team efforts. Must Have Bachelor’s degree in computer science, related STEM field, or its equivalent in education and/or work experience. Four additional years of data engineering experience. Benefits 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, in which Travelers will make an annual contribution into your 401(k) account. Travelers also offers a Pension Plan that is 100% funded by Travelers. Paid Time Off: Minimum of 20 days Paid Time Off annually, plus nine paid company holidays. Wellness Program: The Travelers wellness program includes tools, discounts, and resources that empower you to achieve your wellness goals. The mental health program provides access to free professional counseling services, health coaching and other resources to support your daily life needs. Volunteer Encouragement: Travelers encourages employees to get involved in their communities. The Matching Gift and Volunteer Rewards program enables you to give back to the charity of your choice. To learn more about our comprehensive benefit programs please visit 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 e‑mail 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. #J-18808-Ljbffr