Lead Data Engineer

The Hartford

Confirmed live yesterday High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Hartford, CTCharlotte, NCColumbus, OHChicago, IL
Salary
$117,200–$175,800 / yr
Posted
15 days ago
Freshness
Confirmed live yesterday

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $174k
This role $146k
$106k most similar roles pay here $222k

This role pays less than 72% of similar roles. Most pay $137,325–$211,200 — the shaded band above. At the midpoint, this role pays about $146k versus about $174k for comparable roles.

Based on 240 similar postings.

Employer

About The Hartford

The Hartford is a leading provider of property and casualty insurance, group benefits, and mutual funds, serving businesses and individuals across the United States. Industry: Insurance & Financial Services

The Hartford currently has 45 open roles on FindRole.

Listed pay typically runs $127,600–$191,400 across 37 roles with salary data.

Most-posted roles

View all roles at The Hartford

At a glance

TL;DR · Lead Data Engineer

Lead Data Engineer - Hybrid joins the Actuarial Engineering/Data Management Department’s Global Specialty team. This role involves leading the migration of a legacy on-premises Oracle PL/SQL application to an AWS Snowflake platform while providing ongoing maintenance and support for existing systems. The successful candidate will perform data modeling, requirements gathering, process design, and source-to-target mapping to ensure long-term maintainability. Key responsibilities include translating business problems into logical solution designs, coordinating with cross-functional IT stakeholders, and mentoring other Data Engineers. Required technical skills include robust SQL for complex transformations, extensive ETL and data integration experience, and knowledge of dimensional database structures within the insurance or financial services domain. Preferred qualifications include Python, AWS cloud technologies, Snowflake databases, and familiarity with version control, CI/CD pipelines, and DevOps tools like GitHub, Jenkins, Nexus, and uDeploy.

What you'll do

  • Support and maintain the legacy on-premises Oracle PL/SQL application during the migration period.
  • Lead the migration of legacy systems to the AWS Snowflake platform including design, modeling, and mapping.
  • Write complex SQL transformations to develop and implement efficient, cost-effective application solutions.
  • Translate business problems into logical solution designs and document technical details for non-technical partners.
  • Research and evaluate alternative technologies to recommend efficient system designs.
  • Create charts, tables, and diagrams to analyze existing systems and improve programming logic.
  • Mentor and lead other Data Engineers while managing multiple priorities in a deadline-driven environment.

What we're looking for

  • Bachelor's degree in MIS, Data Science, Computer Science, or a related field, or seven or more years of relevant IT experience.
  • Robust SQL experience with the ability to write complex transformations.
  • Seven or more years of ETL and data integration experience.
  • Two or more years of Oracle PL/SQL experience.
  • Solid data warehouse knowledge in insurance, financial services, or a related domain.
  • Knowledge of data modeling and familiarity with dimensional database structures.
  • Experience mentoring and leading other Data Engineers.
  • Experience with Python (preferred).
  • Experience with version control, CI/CD pipelines, and DevOps tools like GitHub, Jenkins, Nexus, and uDeploy (preferred).
  • Experience with AWS cloud technologies and Snowflake databases (preferred).
  • Knowledge of Global Specialty insurance and experience with artificial intelligence (preferred).

More like this

Similar roles

Lead Data Engineer

Balyasny Asset Management

Chicago, IL +2 22 days ago
Python SQL Snowflake AWS Airflow NoSQL Go Data Modeling Time-series Data LLM Azure data-quality frameworks Observability

Lead Data Engineer

Capital One Financial

Plano, TX +2 59 days ago $179,400$204,700
Python SQL Scala Java AWS Azure Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Shell Scripting Agile Machine Learning
4+ yrs exp

Lead Data Engineer

Capital One Financial

Chicago, IL 59 days ago $179,400$204,700
Python SQL Scala Java AWS Snowflake Redshift Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL Linux Shell Scripting Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA +3 85 days ago $179,400$204,700
Python SQL Scala Java AWS Azure Google Cloud Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA +3 81 days ago $179,400$204,700
Python SQL Scala Java AWS Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA 57 days ago $197,300$225,100
Python SQL Scala Java AWS Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL Linux Shell Scripting Agile
4+ yrs exp