Senior Staff Data Engineer – Lead Cloud Data Pipelines

The Hartford; Columbus (OH); Hybrid; USD 135,000 - 203,000; Full time

Job summary

The Hartford is seeking a Senior Staff Data Engineer to shape how Sales and Underwriting data is ingested, transformed, and delivered. You will own and optimize cloud-based data pipelines, mentor teams, and collaborate with Underwriting, Product, and Enterprise Data groups.

Hybrid role requiring 3 days per week in the office (Hartford, CT; Chicago, IL; Columbus, OH; Charlotte, NC). Strong leadership and technical experience across Snowflake, AWS, and data engineering best practices are essential.

Qualifications

• Authorization to work in the US without sponsorship.
• 8+ years of data engineering experience in distributed systems, data warehousing (SQL and NoSQL), ETL tools, CI/CD, big data, cloud technologies (AWS/Azure), Python/Spark, data mesh and data lake.
• Hands-on experience with Snowflake, Oracle, Informatica Cloud/PowerCenter, GitHub.
• Hands-on experience with replication tools like Qlik, Informatica Mass Ingestion, SharePlex, OpenFlow, DMS.
• Familiar with ETL using PySpark/Python/Snowflake native features.
• Familiar with AWS services such as EMR, S3, Lambda.
• Cloud certifications on AWS/GCP and Snowflake.
• Familiar with AI tools/tech stack.

Responsibilities

• Build and maintain end-to-end data pipelines and data products across platforms.
• Influence solution architecture and implement CI/CD aligned with DevOps.
• Oversee data engineering practices, source control, and data quality.
• Provide technical guidance and documentation for diverse audiences.
• Architect and optimize cloud/hybrid data architectures (AWS, on-premise).
• Stay current with big data technologies and evaluate tool selections.

Skills

Distributed systems

Data warehousing

SQL/NoSQL

ETL/ELT

Python/Spark

Cloud platforms

Snowflake

Data mesh & Data Lake

CI/CD

GitHub

Tools

Snowflake

Oracle

Informatica Cloud/PowerCenter

Github

Qlik

Informatica Mass Ingestion

SharePlex

DMS

AWS EMR

S3

Lambda

Job description

The Hartford is seeking a Senior Staff Data Engineer to shape how Sales and Underwriting data is ingested, transformed, and delivered. You will own and optimize cloud-based data pipelines, mentor teams, and collaborate with Underwriting, Product, and Enterprise Data groups.

Hybrid role requiring 3 days per week in the office (Hartford, CT; Chicago, IL; Columbus, OH; Charlotte, NC). Strong leadership and technical experience across Snowflake, AWS, and data engineering best practices are essential.