Sr Cloud Data and AI Engineer

The Hartford is seeking a Senior Cloud Data and AI Engineer to help build scalable cloud data capabilities and modern AI or automation solutions that support Employer Benefits actuarial functions. The role blends technical leadership with hands-on engineering, partnering with actuarial customers to address time-sensitive close needs while planning durable solutions for future releases.

What You’ll Do

• Act as a technical expert across Informatica IDMC, Snowflake, AI and Generative AI platforms, cloud-native data services, CI/CD tooling, environment management, Oracle, metadata-driven architectures, and enterprise data quality processes.
• Evaluate, prototype, and operationalize emerging AI technologies, including Generative AI, Agentic AI workflows, Retrieval Augmented Generation (RAG), and Model Context Protocol (MCP)-based integrations.
• Design and develop scalable data solutions that enable pricing and reserving activities for the Employer Benefits Actuarial team.
• Analyze and reconcile data differences between GB actuarial output and other standard published data, with the ability to synthesize and explain findings.
• Build and operationalize modern data and AI capabilities by integrating data from diverse sources to support decision-making and mission-critical processes.
• Collaborate with actuarial customers during current financial month close to provide solutions for time-sensitive issues while ensuring strategic planning for the next release cycle.
• Provide technical leadership and mentorship to junior engineers and foster collaboration across onshore and offshore teams to deliver scalable and sustainable data solutions.
• Work with cross-functional partners to understand business needs and develop solutions that are reliable and maintainable.
• 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.
• Research and champion modern data technologies, frameworks, and best practices to drive operational excellence, accelerating data-driven innovation within agile delivery frameworks.

Required Qualifications

• Bachelor’s degree with at least 7 years of applicable work experience.
• Required experience with Snowflake, IDMC, Informatica, and Oracle.
• Hands-on experience with AI-assisted engineering tools including Snowflake Cortex and Agentic AI capabilities, Generative AI platforms, Model Context Protocol (MCP), cloud-based AI services, and intelligent automation frameworks.
• Experience building AI-powered self-service analytics, intelligent data catalogs, automated reconciliation frameworks, or knowledge management solutions.
• Demonstrated passion for continuous learning in Artificial Intelligence, cloud architecture, automation, and emerging technologies.
• Experience with CI/CD, GitHub, Autosys, and SQL.
• 7+ years ETL, data analysis, and/or warehouse technologies experience.
• Strong data warehouse knowledge, preferably in the insurance domain, including demonstrated expertise in data analysis, data quality, and reconciliation processes.
• Strong experience in Python, R, and other modern languages, including building APIs, automation frameworks, AI-driven applications, and cloud-native data services.
• Experience in on-premises to cloud migration of data pipelines, modernizing them to leverage full cloud potential.
• Experience with Agile and Kanban methodologies.
• 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.

Location and Work Schedule

• Location: Columbus, OH
• Employment type: Full time (Hybrid or Remote)
• Hybrid expectation: Candidates near an office will work in the office 3 days per week (Tuesday through Thursday).
• Remote expectation: Candidates not near an office should maintain their current work arrangement, with in-office visits as business needs arise.

Compensation

• Annualized base pay range: USD 117,200 - 175,800
• Actual base pay may vary and could be above or below the listed range based on factors including performance, proficiency, and demonstrated competencies.

Technologies and Tools

• Informatica IDMC, Informatica, Snowflake, Snowflake Cortex, Oracle
• AI, Generative AI, Agentic AI workflows, RAG, Model Context Protocol (MCP)
• Cloud-native data services, intelligent automation frameworks
• CICD tooling, environment management, Enterprise GitHub, Autosys
• Intelligent data catalogs, automated reconciliation frameworks, knowledge management solutions
• SQL, Python, R, APIs, ETL, data pipelines
• AWS, Agile, Kanban

Job details: Job Ref R2627133-174. Category: Data & Analytics. Job code: Sr Data Engineer - GE07BE.