Work in Iowa Manufacturing Jobs

Job Information

Travelers Software Engineer ( ETL, Ab Initio OR Talend, Teradata, AWS ) - Remote in Des Moines, Iowa

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.

Job Category


Target Openings


Job Description Summary

This Lead Data Warehouse Developer will be a valued contributor designing, developing, and releasing new and innovative analytical capabilities in an agile team as part of Analytical Value Stream. This position will be a strong technical contributor. He/She will work with many different tools, technologies and platforms. This role will be looked upon as a Technical Leader within the team. This person will support and enhance an existing Discovery and Self-service environment in SQL Server. He/She will perform all development activities within the defined consumption patterns adhering to Travelers architecture guidelines. In collaboration with our enterprise technology organizations, our analytical initiatives will employ advanced technologies and methodologies to deliver critical business functionality incrementally. Planning and performing Proof of concept and innovation sprints leveraging advanced technologies and assessing viability to the existing business processes are also part of this role.

Primary Job Duties & Responsibilities

  • Work closely with business partners, business analysts and software architects to create and operationalize common data products and consumption layers.

  • Participate in all Agile ceremonies such as stand-ups, release planning, retrospectives, and customer demos

  • Practice test driven development, refactoring, and continuous integration

  • Continuously engage with, bring awareness to agile teams within the value stream on established consumption patterns

  • Conduct governance meetings and ensure different agile teams follow applicable migration checklist for Discovery/Self-service environment

  • Adopt and communicate new concepts, ideas, techniques and best practices

  • Convert concepts and ideas into workable prototypes for business review, design validation, usability testing and eventual production migration

  • Evaluate alternative solutions and assess risk

  • Performs special projects and other duties as applicable

  • Act as subject matter expert on multiple applications

  • Acquire and build upon the required data mastery and system knowledge

  • Work effectively with infrastructure teams to support the environment and its migration to cloud platforms.

  • Design and develop data flows in support of analytics and reporting

  • Solve complex performance problems and architectural challenges

  • Evaluate ways to enable large and complex data sets for analytical/reporting purposes

  • Spearhead data flow migration efforts such as mapping source to target, naming conventions, modeling etc.

  • Review and optimize query performance

  • Provide production support and enhance existing data assets and ETL/ELT processes

  • Identify root causes and resolve data related issues

  • Maintain data access controls within the environment via AD Groups and other applicable means

Minimum Qualifications

  • Bachelor’s degree or its equivalent in work experience.

  • Two years of programming/development experience.

Education, Work Experience, & Knowledge

  • Four years of programming/development experience preferred.

  • Experience with SQL Server & ETL

  • Experience as a Team Lead / Mentor

Job Specific Technical Skills & Competencies

  • Expert level handling of data housed in SQL Server environment

  • Expert level experience in developing ETL/ELT applications

  • Expert level code management and deployment

  • Moderate level data knowledge and analysis, inclined to learn “Quickly”

  • Experience with one or more data platforms such as Teradata, Hadoop, Oracle, DB2, MongoDB

  • Experience with one or more data and reporting tools such as Ab-Initio, Talend, Informatica, SSIS, SSRS, Qlik, Power BI

  • Experience with one or more of Python, PySpark, Java, Databricks, Node.JS, React JS, Restful APIs a HUGE plus

  • Exposure to overarching micro service and streaming concepts a plus

  • Exposure to Cloud technologies (e.g. AWS/AZURE, Snowflake, MySQL, Aurora) a plus

  • Strong collaboration and relationship building skills

  • Able to communicate with clarity and precision

  • Able to present in group setting

  • Hands-on with demonstrated sense of urgency

  • Displays positive, constructive and helpful demeanor to assist/mentor team members

Environmental / Work Schedules / Other

  • Occasional night & weekend hours

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.