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.

• 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

• 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

• 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