Sr AI Data Engineer

The Hartford; Chicago (IL); Hybrid; USD 117,000 - 176,000; Full time

Job summary

The Hartford in Hartford, CT is seeking a Sr Data Engineer to help shape actuarial analytics by building modern data solutions, semantic layers, and AI-enabled insights for actuaries and business leaders.

You will partner with cross‑functional teams to design trusted data products and interactive analytics that surface trends and support pricing, reserving, underwriting, and portfolio decisions. This hands-on role emphasizes delivering scalable data assets.

Qualifications

• This role requires 5-7 years of data analysis, manipulation and development.
• 1-3 years of experience in the insurance or investment industry.
• Strong SQL skills and ETL design capabilities.

Responsibilities

• Build analytic-ready data assets and semantic layers for actuaries.
• Partner with actuarial and analytics teams to surface trends and enable AI‑enabled insights.
• Develop dashboards and data products to support pricing, reserving, underwriting, and portfolio decisions.

Skills

SQL

Data analysis

ETL

AI analytics

Semantic data modeling

Tools

ThoughtSpot

Snowflake

Semantic data layers

AI for analytics

Job description

Sr Data Engineer - GE07BE

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.

This is an opportunity to help shape the next generation of actuarial analytics. In this role, you will build modern, agentic data solutions that combine ThoughtSpot, Snowflake, semantic data assets, and AI-powered analytics to help actuaries move faster from data to insight to action. You will partner closely with actuarial teams, business leaders, and analytics partners to design trusted data products, intelligent dashboards, and AI-enabled insight experiences that surface emerging trends, explain key business drivers, and support pricing, reserving, underwriting, and portfolio decisions. The ideal candidate is energized by solving complex data problems, experimenting with new technologies, and turning actuarial knowledge into scalable solutions that make insights easier to discover, understand, and act on.

You will serve as a hands‑on builder and thought partner, helping develop analytic‑ready data assets, governed semantic layers, AI prompts and context, and interactive analytics experiences that enable actuaries to identify opportunities, diagnose root causes, and deliver recommendations with greater speed, consistency, and confidence.

Qualifications

• Working experience with ThoughtSpot, Snowflake, semantic data layers, and AI for analytics or agentic data solutions


• 5-7 years of data analysis, manipulation and development


• 1-3 years of experience in the insurance or investment industry


• Strong SQL skills


• Property and Causality Domain expertise preferred


• Ability to design, implement, and oversee ETL processes


• Familiarity with emerging data centric technologies


• Ability to choose and effectively utilize data wrangling technologies

This role will have a Hybrid work schedule, with the expectation of working in an office (Columbus, OH, Chicago, IL, Hartford, CT or Charlotte, NC) 3 days a week (Tuesday through Thursday). Candidates must be authorized to work in the US without company sponsorship. The company will not support the STEM OPT I-983 Training Plan endorsement for this position.

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:

$117,200 - $175,800

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