Sr. Data Engineer - Hybrid

The Hartford; Columbus (OH); On-site; USD 117,000 - 176,000; Full time

Job summary

The Hartford in Hartford, CT is seeking a Sr. Data Engineer to drive the Snowflake migration from an on-prem Oracle PL/SQL system.

You will analyze requirements, design data models, and coordinate with IT partners across multiple offices on a hybrid schedule (Tue–Thu in office at Hartford, CT; Chicago, IL; Columbus, OH; Charlotte, NC). Ideal candidates bring 7+ years in ETL/data integration, strong SQL, data warehouse know-how in financial services, and a willingness to mentor other engineers

Qualifications

• Authorized to work in the US without sponsorship.
• Robust SQL and complex transformations experience.
• 7+ years ETL / data integration experience.
• 2+ years Oracle PL/SQL experience.
• Solid data warehouse knowledge in finance/insurance.
• Knowledge of data modeling and dimensional structures.
• Strong analytical and facilitation skills.
• Ability to manage multiple priorities in a deadline-driven environment.
• Willingness to mentor other Data Engineers and learn new tech.

Responsibilities

• Support legacy on-premises Oracle PL/SQL application until migration to AWS Snowflake completes.
• Lead migration of legacy system to Snowflake with design, data modeling, and mapping.
• Ensure Snowflake app is maintainable with clear code base for business users.
• Document support procedures and coordinate with cross-functional IT stakeholders.
• Evaluate alternatives and recommend efficient, cost-effective designs.
• Translate business problems into logical solution designs and implement.
• Prepare charts/diagrams for problem analysis using math and engineering techniques.
• Foster collaboration, accountability, diversity, and continuous improvement.

Skills

SQL proficiency

ETL / data integration

Data analysis

Requirements elicitation

Data modeling

Communication skills

Mentoring Data Engineers

Learning mindset

Prioritization under deadlines

Education

Bachelor's degree in MIS / Data Science / Computer Science or related discipline

Seven+ years IT experience

Tools

Oracle PL/SQL

Snowflake

AWS

GitHub / Jenkins / Nexus / uDeploy

Python

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.

The Actuarial Engineering/Data Management Department's Global Specialty team is seeking a skilled Sr. Data Engineer with a proven track record. The ideal candidate will use deep technical expertise and strong communication skills to deliver new initiatives while providing ongoing maintenance and support.

To excel in this role, you must be proficient in writing complex SQL transformations. You should also have experience in data analysis, requirements gathering, data modeling, and process design, with the ability to document and communicate technical details to business partners with varying levels of technical expertise.

This role will have a Hybrid work schedule, with the expectation of working in an office location (Hartford, CT; Chicago, IL; Columbus, OH; and Charlotte, NC) 3 days a week (Tuesday through Thursday).

Responsibilities Include, But Are Not Limited To

• Support the legacy on-premises Oracle PL/SQL application until it is successfully migrated to the AWS Snowflake platform.
• Lead the migration of the legacy system to Snowflake, including application design, data modeling, process flows, source-to-target mapping, coordination with external teams, code development, developer leadership, and results validation.
• Ensure the new Snowflake application is designed for long-term maintainability and enhancement, with a clear code base that supports effective communication with business users.
• Support the new Snowflake application and document support procedures.
• Coordinate activities with cross-functional IT stakeholders.
• Research and evaluate alternative solutions and recommend the most efficient and cost-effective approach for system design.
• Translate business problems into logical solution designs, then develop, test, and implement efficient, cost-effective application solutions by writing new code, reusing existing code, or integrating purchased solutions.
• Prepare charts, tables, and diagrams to support problem analysis using appropriate business, scientific, engineering, and mathematical techniques. Analyze existing systems and programming logic to improve operations, identify issues, and revise logic or procedures as needed.
• Foster a positive work environment by modeling cultural values and encouraging collaboration, accountability, diversity, and continuous improvement.

Required Qualifications

• 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.
• Bachelor's degree in Management Information Systems, Data Science, Computer Science, or related discipline, or seven or more years of relevant IT experience.
• Robust SQL experience: must be comfortable writing complex transformations.
• Seven or more years of ETL/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.
• Strong critical thinking and analytical skills.
• Proven ability to organize and manage multiple priorities in a deadline-driven environment.
• Excellent facilitation, requirements elicitation, and data analysis skills.
• Experience mentoring and leading other Data Engineers.
• Continuous learning mindset: must be comfortable learning new languages, platforms and approaches as needed.

Preferred Qualifications

• Experience with Python.
• Experience with version control, CI/CD pipelines, and DevOps tools such as GitHub, Jenkins, Nexus, and uDeploy.
• Experience with AWS cloud technologies; certifications are a plus.
• Experience with Snowflake databases.
• Knowledge of Global Specialty insurance.
• Experience with artificial intelligence; certifications are a plus.

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