Senior ETL Developer

The Hartford; Wayne (PA); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading insurance company is seeking a Senior ETL Developer to ensure technical excellence and operational efficiency in data engineering. This role involves translating business requirements into specifications, designing scalable data pipelines, and collaborating with offshore teams. The ideal candidate will have a relevant degree, over 5 years of ETL development experience, and strong skills in SQL and various ETL tools. Compensation ranges from $100,000 to $140,000 annually, and the position is full-time.

Qualifications

• 5+ years of experience in ETL development.
• Experience managing offshore or distributed teams is preferred.
• Hands-on experience with cloud data platforms.

Responsibilities

• Translate business requirements into technical specifications.
• Design, build, and maintain scalable data pipelines and ETL processes.
• Conduct code reviews and enforce best practices.

Skills

SQL

ETL processes

Cloud data platforms

Problem-solving

Communication skills

Education

Bachelor’s or master’s degree in computer science or related field

Tools

DBT

Talend

Matillion

Informatica

Snowflake

Azure Synapse

Redshift

Git

Job description

Senior ETL Developer – The Hartford

Application Dev Consultant – 87ID5E

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.

As Hartford Funds continues to leverage offshore data engineering talent to optimize costs and scale delivery, it is critical to establish a Senior ETL Developer role to ensure technical excellence, operational efficiency, and adherence to corporate standards. This role will be hands‑on, directly contributing to development while also collaborating with offshore resources to ensure standards.

This role requires a strong foundation in SQL, ETL processes, and cloud data platforms, along with a proactive mindset for identifying and resolving data bottlenecks and inefficiencies.

Responsibilities

• Translate business requirements into technical specifications.
• Ensure timely and high‑quality execution of data projects.
• Design, build, and maintain scalable data pipelines and ETL processes.
• Develop and optimize data models for analytics and reporting.
• Stay current with emerging technologies and recommend adoption where appropriate.
• Conduct code reviews, enforce best practices, and ensure adherence to corporate standards.
• Partner with data operation engineers, system analysts, and data architects to design scalable data solutions.
• Provide guidance on best practices for data architecture, storage, and processing.
• Contribute to documentation, standards, and knowledge sharing across the team.

Qualifications

Required

• Bachelor’s or master’s degree in computer science, Data Engineering, or related field.
• 5+ years of experience in ETL development.
• Experience managing offshore or distributed teams is strongly preferred.
• Strong proficiency in SQL and experience with ETL/ELT tools (e.g., DBT, Talend, Matillion, Informatica, custom Python scripts).
• Hands‑on experience with cloud data platforms (e.g., Snowflake, Azure Synapse, Redshift).
• Knowledge of CI/CD practices and version control (e.g., Git).
• Strong understanding of ETL/ELT processes, data warehousing, and data modeling.
• Strong problem‑solving skills and a proactive approach to identifying and resolving issues.
• Excellent communication skills to manage cross‑functional and cross‑cultural teams.

Preferred

• Knowledge of Python or other scripting languages for automation.
• Familiarity with monitoring tools.
• Experience working in Agile or DevOps environments.

Compensation

The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short‑term or annual bonuses, long‑term incentives, and on‑the‑spot recognition. The annualized base pay range for this role is: $100,000 - $140,000.

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

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Business Development and Sales