Data Engineer II – ETL
Job ID: R-27154
Job Category: Technology,
Location: Hartford, CT
Additional Locations: Alpharetta, GA; Hunt Valley, MD; Saint Paul, MN; Richardson, TX;
Workplace Arrangement: Remote
Posted Date: March 9, 2023
Apply
Who Are We?
Taking care of our customers, our communities and each other. That’s 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 160 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.
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
$113,900.00 – $188,000.00
Target Openings
1
What Is the Opportunity?
Travelers Data Engineering and Data scientists leverage the various platforms that use Extract Transform and Load (ETL) capabilities to create data analytics solutions for business. The ETL Data engineer II will support the data engineers and data scientists to leverage the power of ETL platforms like Abinitio and TALEND to do their work. The position requires a strong understanding of ETL concepts including file processing concepts, Batch job design principles, change data capture mechanisms, platform support, file formats, security, data lineage and automation etc. that can help in growing and transforming our analytics landscape. An ideal candidate will have experience working with TALEND modules including Data Integration, Data Quality, ESB and Big Data Frameworks and ABintio platforms including GDE>Co-Operating System, Express> IT, Data Quality Environment (DQE)
The work arrangement for this position is based on location.
What Will You Do?
- Engage with key projects to understand the requirements, propose solutions, best practices and provide support during implementations.
- Resolve issues raised by users and provide necessary support for training.
- Stay current with industry trends, making recommendations as needed to help the organization innovate and excel.
- Managing various environments and enabling new capabilities in accordance with company security guidelines.
- Implement ETL solutions in AWS cloud as IaaS solution or PaaS solution.
- Working with Talend Data Mapper, Microservices, CICD workflow and complex transformation components to create solution accelerators (reusable components and frameworks) which can be leveraged across different projects, POCs, Demos using Talend Technology
- Adopt the agile ways of working and influence behavioral change as it relates to SAFe framework.
- Work collaboratively with other partner teams at Travelers to learn new solutions and processes and apply them for business solutions.
- Help with rollout of currency and resiliency solutions.
- Perform data and systems analysis, assessment and resolution for defects and incidents.
- 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
- 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.
- 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 solver who ensures systems are built with longevity and creates innovate ways to resolve issues.
- Strong written and verbal communication skills with the ability to work 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. and a proven track record of self-motivation in identifying opportunities and tracking team efforts.
What is a Must Have?
- Bachelor’s degree or equivalent training with data tools, techniques, and manipulation.
- Four years of data engineering or equivalent 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 and resources that empower you to achieve your wellness goals. In addition, our Life Balance program provides access to professional counseling services, life coaching and other resources to support your daily life needs. Through Life Balance, you’re eligible for five free counseling sessions with a licensed therapist.
- 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 believe that we can deliver the very best products and services when our workforce reflects the diverse customers and communities we serve. We are committed to recruiting, retaining and developing the diverse talent of all of our employees and fostering an inclusive workplace, where we celebrate differences, promote belonging, and work together to deliver extraordinary results.
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/.
Careers at Travelers
When you work at Travelers, life’s most important moments become your life’s work. That means helping families feel secure, businesses to prosper, knowing that you’ve made a difference, and feeling like you belong to something bigger. It also means being part of a team comprised of 30,000 + talented and passionate people that are evolving to meet changing needs – from customer service to data science and beyond. If that’s more than you imagined in an insurance career, it’s time to join us at Travelers.
$712,000 raised by employees through our virtual Community Connections Campaign in 2021
92 homes built to FORTIFIED standards in 7 states through our partnership with SBP in 2021
85,000 meals prepared and delivered to individuals in need in 2021.
$24 Million donated to the communities where we live and work globally in 2021$3.4 million in funding provided to 33 organizations focused on arts and culture in 2021
Proud To Be Recognised
