Data Engineer II

Stryker Corporation; Hartford (CT); On-site; Confidential; Full time

Job summary

The Travelers Indemnity Company in Hartford, CT, is seeking a Data Engineer II for a 100% remote role. You will build and operationalize complex IT data solutions, apply transformations, and implement data cleansing/quality controls.

You will collaborate across teams to educate end users on data products and analytic environments. Required: a bachelor’s degree with 6+ years of data engineering experience or a master’s with 4+ years, plus 4+ years in Python, PySpark, Scala or SQL; experience with

Qualifications

• Bachelor's degree or its equivalent with 6+ years of progressive data engineering experience.
• Master's degree or its equivalent with 4+ years of experience in data engineering.
• Must have at least 4 years with Python, PySpark, Scala or SQL and experience with relational and NoSQL databases.
• Demonstrated experience with Databricks and AWS in hybrid environments.
• Knowledge of insurance data concepts and building robust data pipelines.

Responsibilities

• Build and operationalize complex IT data solutions, perform data transformations and quality improvements.
• Collaborate with teams to educate end users on data products and analytics environments.
• Test data movement, transformation code, and data components; resolve complex defects and incidents.
• Perform data and system analysis, assessment and resolution for complex issues.

Skills

Python

PySpark

SQL

Scala

Databases (Relational/NoSQL)

Data Engineering

Cloud/Big Data

AWS

Education

Bachelor's degree or equivalent

Master's degree or equivalent

Tools

Databricks

AWS

Teradata

Snowflake

PostgreSQL

DB2

Oracle

DynamoDB

MongoDB

Job description

The Travelers Indemnity Company has an opening for a Data Engineer II in Hartford, CT. This position is 100% remote; may work from home.

Build and operationalize complex IT data solutions, correct problems, apply transformations, and recommending data cleansing/quality solutions. Design complex IT data solutions. Perform analysis of complex sources to determine value and use and recommend data to include in analytical processes. Incorporate core data management tools and 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/analytic environment. 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.

Must possess at least a bachelors degree or its equivalent and at least 6 years of progressive experience as an Engineer or in a related role working with Data. In the alternative, at least a masters degree or its equivalent and at least 4 years of experience as an Engineer or a related role working with Data would be acceptable. Must also possess at least 4 years of experience with: Python, PySpark, Scala, or SQL; relational and NoSQL databases (i.e. Teradata, Snowflake, PostgreSQL, DB2, Oracle, DynamoDB, MongoDB); modern software engineering practices (Cloud/Big Data, Analytics, Parsing, Requirements, Data Engineering); Databricks and AWS (hybrid environments); Business Insurance data and data products; and demonstrable experience with: Insurance data concepts (premium, losses, insurable objects, coverages) for Actuarial/Analytics; building robust data pipelines and working with large-scale datasets; and translating data/AI vision into objectives, roadmaps, and deliverables.

Approximately 40 hours per week; the salary for this position is at least $163,821 to $199,200 per year.