Trav Banner


ETL Developer

Hartford, Connecticut

Company Summary

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.

Target Openings

1

Job Description Summary

Enterprise Data & Analytics Technology is a team of highly motivated and skilled professionals who are leading Travelers' analytics journey and driving business value that creates a sustainable competitive advantage for our company. We accomplish this by helping the enterprise adopt various technology platforms ranging from storage, compute (private and public cloud), AI, Predictive modelling, Data Management, Data Ops and Data Products.

Primary Job Duties & Responsibilities

  • Data Analysis, Acquisition, Preparation, and Exploration:
  • Independently review, prepare, design and integrate moderately complex (type, quality, volume) data, correcting problems and recommend data cleansing/quality solutions to issues.
  • Apply moderate data derivations and assist with complex business transformation rules and data requirements.
  • Perform analysis of moderately complex (type, quality, volume) sources to determine value and use.
  • Recommend data to include in analytical projects.
  • Create simple (technology and features) data visualization techniques to help support data exploration.
  • Data Solutions & Analytic Implementations:
  • Operationalize and automate moderately complex (more systems, data sets and streams, size of data sets more substantial) data products independently.
  • Build, test, and implement moderately complex analytic business processes, including pilots and proof of concepts.
  • Apply knowledge of current industry trends and techniques to formulate solutions within the context of assigned projects and/or enhancements.
  • Data Culture:
  • May present complex information to next level of management.
  • Work within Travelers standards, processes, and protocols.
  • Incorporate core data management competencies - data governance, data security, data quality.
  • Share knowledge and Independently train business users on data products/analytic environment when necessary.
  • Perform other duties as assigned.

Minimum Qualifications

  • 3 years of relevant experience with data tools, techniques, and manipulation required.

Education, Work Experience, & Knowledge

  • Education:
  • College Degree in STEM related field
  • Technical Knowledge:
  • Intermediate knowledge of data tools, techniques, and manipulation preferred. Examples (but not limited to):
  • Big data and Cloud platforms
  • Programming languages - SAS, SQL, Spark, Python, Hive, AWS
  • Visualization platforms: QlikView, Tableau, MicroStrategy and Qlik Sense
  • Experience:
  • 4 years of relevant experience with data tools, techniques, and manipulation preferred.

Job Specific Technical Skills & Competencies

Intermediate knowledge of data tools, techniques, and manipulation preferred in one or more of the following:

  • Data concepts - Data Warehouse, Data Lake, Data Model, DB Design, Data Mapping
  • Data platforms - RDBMS, Big Data and Cloud
  • Data integration tools - Talend, Ab Initio
  • Scheduling tools - Autosys, Control-M
  • Programming languages - Spark, Python,  Java
  • Dev Ops - Continuous Integration, Continuous Deployment, Version Control
  • Data serialization formats - Parquet, Orc
  • Cloud services - Ex: AWS (EC2, EMR, RDS, Redshift, S3, Lambda), Snowflake, Databricks
  • Containerization technologies - Docker, Kubernetes

Environmental / Work Schedules / Other

  • Operates standard office equipment - Continuously
  • Sitting (Can stand at will) - Continuously
  • Use of Keyboards, Sporadic 10-Key - Continuously

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. 


If you have 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.


About Travelers

The Travelers Companies, Inc. (NYSE: TRV) is a leading property casualty insurer selling primarily through independent agents and brokers. The company's diverse business lines offer its global customers a wide range of coverage in the auto, home and business settings. A component of the Dow Jones Industrial Average, Travelers has more than 30,000 employees and generated revenues of approximately $25 billion in 2010.