Sr. Cloud Data Engineer - Snowflake

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

Job summary

A leading insurance company seeks a Sr. Cloud Data Engineer to join their Group Benefits Business Intelligence area. This role involves developing scalable data solutions, mentoring junior engineers, and working closely with Actuarial teams to solve critical business challenges. Candidates should have strong technical skills, experience with cloud data solutions, and the ability to engage directly with customers in an agile environment. A hybrid work schedule is offered, with office presence required three days a week.

Qualifications

• At least 7 years of applicable work experience.
• Experienced in ETL/Data analysis/Warehouse Technologies.
• Strong data warehouse knowledge, preferably in the insurance domain.

Responsibilities

• Design and develop high quality, scalable data solutions for pricing and reserving activities.
• Engage with Actuarial customers during financial closures, providing timely solutions.
• Mentor junior engineers and collaborate with team members for data solutions.

Skills

Snowflake

IDMC

Informatica

Oracle

SQL

Data Quality

Data Analysis

Cloud Migration

Agile Methodologies

ETL Processes

Education

Bachelor’s degree

Tools

GitHub

CICD Tools

Autosys

Job description

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 Group Benefits Business Intelligence area is seeking a Sr. Cloud Data Engineer. This position is in a small group that works directly with our customers and prides itself in delivery capabilities. This role offers the opportunity to have a significant bottom-line impact through the delivery of quality and actionable information to our business customers. The ideal candidate is a highly motivated, results-oriented individual with strong technical skills and project-level leadership experience.

We are looking for a well-rounded individual that is comfortable working in a process light environment and willing to cross the traditional role boundaries of developer, BA, Architect and project lead. To be successful in this role you must be comfortable working directly with customers in an iterative fashion to achieve the desired result. As such, strong verbal communication and the ability to create your own technical specifications and designs based on customer needs is critical for success in this role.

This role will have a Hybrid work schedule, with the expectation of working in an office Hartford, CT 3 days a week (Tuesday through Thursday).

Responsibilities:

Regularly engage in continuing education and Serve as technical expert for Informatica IDMC , Snowflake, CICD tooling, Environment Management, Oracle and Data Quality processes

Design and develop high quality, scalable data solutions to enable pricing and reserving activities for Group Benefit Actuarial team.

Ability to synthesize, reconcile, and explain data differences between GB actuarial output against other standard published data.

Gain deep understanding on various Actuarial applications, data elements and business process.

Work closely with Actuarial customers during the close of current financial months to provide solutions to time sensitive issues while ensuring strategic solutions are planned for next release cycle.

Mentor Junior Engineers and work with onshore and offshore team members to develop data solutions in support of Group Benefits Actuarial.

Ability to discover, analyze and integrate data from various sources to support decision making and enable critical business processes

Consult with cross-functional team partners to understand business needs and develop reliable and effective solutions that are easily maintainable.

Ability to work directly with the customers to understand their needs and provide solutions.

Research, evaluate and recommend effective and repeatable data solutions

Willingness to develop deep functional knowledge in the pricing and rating process.

Work within an agile framework and collaborate with partner organizations to build or enhance data assets.

Develop and maintain scalable data pipelines and ETL processes to support Insurance processing, actuarial analysis, and reporting.

Use Enterprise GitHub for version control, documentation, code collaboration, and technical project management.

Qualifications:

Experience in following is required: Snowflake, IDMC, Informatica, Oracle

Experience with CICD, GitHub, Autosys, and SQL

Bachelor’s degree with at least 7 years of applicable work experience.

7+ years ETL / Data analysis / Warehouse Technologies experience

Strong data warehouse knowledge preferably in the insurance domain, Demonstrated expertise in Data analysis, Data Quality and reconciliation processes.

Group Benefits business knowledge is a plus.

Knowledge of AWS and cloud-based data solutions is a plus

Experience developing software in one or more programming languages is a plus(R, Python, etc.)

Experience in on-premises to cloud migration of data pipelines, modernizing them to leverage full cloud potential.

Experienced in Agile and Kanban Methodologies

Candidate 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

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 Group Benefits Business Intelligence area is seeking a Sr. Cloud Data Engineer. This position is in a small group that works directly with our customers and prides itself in delivery capabilities. This role offers the opportunity to have a significant bottom-line impact through the delivery of quality and actionable information to our business customers. The ideal candidate is a highly motivated, results-oriented individual with strong technical skills and project-level leadership experience.

We are looking for a well-rounded individual that is comfortable working in a process light environment and willing to cross the traditional role boundaries of developer, BA, Architect and project lead. To be successful in this role you must be comfortable working directly with customers in an iterative fashion to achieve the desired result. As such, strong verbal communication and the ability to create your own technical specifications and designs based on customer needs is critical for success in this role.

This role will have a Hybrid work schedule, with the expectation of working in an office Hartford, CT 3 days a week (Tuesday through Thursday).

Responsibilities:

• Regularly engage in continuing education and Serve as technical expert for Informatica IDMC , Snowflake, CICD tooling, Environment Management, Oracle and Data Quality processes

• Design and develop high quality, scalable data solutions to enable pricing and reserving activities for Group Benefit Actuarial team.

• Ability to synthesize, reconcile, and explain data differences between GB actuarial output against other standard published data.

• Gain deep understanding on various Actuarial applications, data elements and business process.

• Work closely with Actuarial customers during the close of current financial months to provide solutions to time sensitive issues while ensuring strategic solutions are planned for next release cycle.

• Mentor Junior Engineers and work with onshore and offshore team members to develop data solutions in support of Group Benefits Actuarial.

• Ability to discover, analyze and integrate data from various sources to support decision making and enable critical business processes

• Consult with cross-functional team partners to understand business needs and develop reliable and effective solutions that are easily maintainable.

• Ability to work directly with the customers to understand their needs and provide solutions.

• Research, evaluate and recommend effective and repeatable data solutions

• Willingness to develop deep functional knowledge in the pricing and rating process.

• Work within an agile framework and collaborate with partner organizations to build or enhance data assets.

• Develop and maintain scalable data pipelines and ETL processes to support Insurance processing, actuarial analysis, and reporting.

• Use Enterprise GitHub for version control, documentation, code collaboration, and technical project management.

Qualifications:

• Experience in following is required: Snowflake, IDMC, Informatica, Oracle

• Experience with CICD, GitHub, Autosys, and SQL

• Bachelor’s degree with at least 7 years of applicable work experience.

• 7+ years ETL / Data analysis / Warehouse Technologies experience

• Strong data warehouse knowledge preferably in the insurance domain, Demonstrated expertise in Data analysis, Data Quality and reconciliation processes.

• Group Benefits business knowledge is a plus.

• Knowledge of AWS and cloud-based data solutions is a plus

• Experience developing software in one or more programming languages is a plus(R, Python, etc.)

• Experience in on-premises to cloud migration of data pipelines, modernizing them to leverage full cloud potential.

• Experienced in Agile and Kanban Methodologies

Candidate 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

About Us | Our Culture | What It’s Like to Work Here | Perks & Benefits

The Hartford Financial Services Group, Inc., usually known as The Hartford, is a United States-based investment and insurance company.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.