Lead Data Engineer for Joint Customer Insights - Hybrid

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 Hartford Financial Services Group is seeking a highly creative and passionate Lead Data Engineer with experience working in a dynamic and broadly defined role. The candidate will join our growing community supporting health services.  The main responsibility of this role is to manage our joint customer connection application which leverages entity resolution to discover cross sell opportunities across group benefits and P&C.  We are looking for an independent technical leader who will partner closely with business leaders and expert resources to design, develop, and maintain scalable data pipelines and ETL processes.  This role also includes ad-hoc analysis providing data and insights to estimate the value of potential strategies.  This candidate will bring with them a creative solution design approach to data exploration and discovery and the ability to work in an iterative, collaborative way to balance the solution with the technical outcome.  We seek candidates with a strong understanding of data architecture and data warehousing in cloud native environments, coupled with strong analytical, communication, interpersonal, and business skills. This role combines business and technical skills involving interaction with business customers, internal and external data suppliers within our enterprise data services team and Information Technology partners.  Leadership skills and the ability to work independently are required.

This role will have a Hybrid work arrangement, 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:

• Provide innovative business solutions and data assets by partnering closely with business partners, and data suppliers to analyze source systems, define business requirements, provide quality data and assist in high level data analysis.
• Perform ingestion, extraction, cleaning, integrity testing, integration, and mapping of data across multiple data assets within The Hartford.
• Implement data governance and security best practices to protect sensitive information.
• Provide leadership, guidance and coaching to offshore resources.  Lead by example through following best practices and helping define new standards. 
• Perform data analysis to ensure continued quality and identify areas of opportunity to improve or enhance existing processes.
• Evolve and maintain a position as a subject matter expert and data advisor, defining business requirements, providing data assets and assisting in high level data analysis. 
• Integrate data from various sources, including Group Benefits and P&C insurance systems, ensuring data quality and consistency.
• Monitor and troubleshoot data workflows, ensuring timely and accurate data delivery.
• Assist in maintaining the product back log, and aligning work to our two offshore partners

Minimum Experience 

• 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 or equivalent experience in related field required.
• 5+ years ETL / Data Integration experience and analysis.
• Proficiency with Python, PySpark and SQL to build data pipelines.
• Experience with SQL/ETL concerning meta data management, intermittent data checks throughout a process, data validation.
• Exposure to AWS services and cloud native solutions

Nice to have:

• Experience with Cloud (AWS) technologies (i.e. S3, EMR)
• Experience with big data technologies (i.e. Hadoop, Spark, Hive, etc.) 
• Knowledge of insurance claims, operations, medical/healthcare data and analytics

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:

$113,360 - $170,040

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits