Senior Data Engineer

The Hartford; Hartford (CT); Hybrid; USD 101,000 - 203,000; Full time

Benefits offered by this job

Bonuses

Job summary

A leading insurance company is seeking a Senior Data Engineer in Hartford, CT. The candidate will design scalable data pipelines and collaborate with NLP developers. Responsibilities include implementing ETL processes, managing data integrity, and mentoring junior engineers. A Bachelor's degree and 3+ years in data engineering are required. The position offers a hybrid work schedule and competitive compensation ranging from $101,000 to $203,000 annually.

Qualifications

• 3+ years of experience in data engineering or software development.
• Solid understanding of data warehousing concepts and database design.
• Experience with CI/CD pipelines and version control.

Responsibilities

• Design and implement complex ETL/ELT processes using Python and SQL.
• Collaborate with data architects and business stakeholders.
• Automate data workflows and monitor their efficiency.

Skills

Proficiency in SQL

Proficiency in Python

Experience with data engineering

Experience with JavaScript

Excellent problem-solving skills

Education

Bachelor’s degree in Computer Science

Master’s degree (preferred)

Tools

AWS

Azure

GCP

Git

FastAPI

spaCy

Pydantic

DuckDB

Redshift

Snowflake

Databricks

Job description

Senior Data Engineer – The Hartford

We are a leading insurance company committed to making a difference. Join our Data Science Organization to support our patented Natural Language Processing (NLP) data asset by sourcing and integrating unstructured data into our core NLP platform.

As a Senior Data Engineer, you will design, develop, and maintain scalable data pipelines, collaborate with NLP developers and business partners, and mentor junior engineers. You will bring a creative problem‑solving mindset and strategic vision to deliver cost‑effective solutions.

Job Responsibilities

• Design, develop, and implement complex ETL/ELT processes using Python and SQL.
• Build and optimize data pipelines from diverse sources, including relational databases, NoSQL databases, APIs, and streaming data platforms.
• Collaborate with data architects, data scientists, and business stakeholders to translate requirements into technical solutions.
• Develop and maintain data warehouses and data lakes, ensuring data integrity, security, and performance.
• Implement data governance policies and best practices, including data quality checks, metadata management, and data lineage tracking.
• Automate data workflows, monitoring, and alerting systems to ensure reliability and efficiency.
• Troubleshoot and resolve data‑related issues, perform root cause analysis, and implement corrective actions.
• Participate in code reviews, mentor junior data engineers, and contribute to continuous improvement of data engineering practices.
• Evaluate and recommend new data technologies and tools to enhance platform capabilities.
• Ensure compliance with data privacy regulations and company security policies.

Job Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field (Master’s degree preferred).
• 3+ years of experience in data engineering, software development, or a related role focused on data.
• Proficiency in SQL, Python, and JavaScript.
• Experience with Python packages FastAPI, spaCy, Pydantic, and DuckDB.
• Familiarity with cloud data platforms (AWS, Azure, GCP) and services (S3, Redshift, Snowflake, Databricks).
• Solid understanding of data warehousing concepts, dimensional and relational modeling, and database design.
• Experience with version control (Git) and CI/CD pipelines.
• Excellent problem‑solving, analytical, and communication skills.
• Ability to work independently and collaboratively in a fast‑paced, agile environment.
• Experience in the insurance or financial services industry is a plus.

Hybrid Work Schedule: Expected to work in the office (Columbus, OH; Chicago, IL; Hartford, CT; Charlotte, NC) 3 days a week (Tuesday‑Thursday).

Candidates must be authorized to work in the U.S. without company sponsorship. The company will not support the STEM OPT I‑983 Training Plan endorsement for this position.

Compensation

Annualized base pay range: $101,000.00 – $203,000.00 (may vary based on experience, performance, and competencies).

The base pay is part of The Hartford’s total compensation package, which may also include bonuses, long‑term incentives, and on‑the‑spot recognition.

Equal Opportunity Employer / Sex / Race / Color / Veterans / Disability / Sexual Orientation / Gender Identity or Expression / Religion / Age