Sr Cloud Data and AI Engineer

The Hartford is hiring a Sr Cloud Data and AI Engineer to help advance scalable cloud data engineering and AI-driven automation for Employer Benefits actuarial teams. In this role, you will support data capabilities that accelerate business insights and improve operational efficiency, with a mix of technical leadership, customer collaboration, and iterative delivery tied to time-sensitive actuarial needs.

This position is based in Chicago, IL with a hybrid or remote work schedule. Candidates living near a Hartford location are expected to work in the office 3 days per week (Tuesday through Thursday); those who do not live near an office will maintain their current arrangement, with the expectation of coming in as business needs arise.

Key responsibilities

• Act as a technical expert across Informatica IDMC, Snowflake, AI and Generative AI platforms, and cloud-native data services, including CI/CD tooling, environment management, and Oracle.
• Engage in continuing education and serve as a leader on 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 high-quality, scalable data solutions that support pricing and reserving activities for the Employer Benefits Actuarial team.
• Synthesize and reconcile differences between Employer Benefits actuarial output and other standard published data, including the ability to explain those differences.
• Build deep functional knowledge of actuarial applications, data elements, and business processes, with particular focus on the pricing and rating process.
• Work with Actuarial customers during the close of current financial months to address time-sensitive issues, while ensuring strategic solutions are planned 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.
• Discover, analyze, and optimize data from diverse sources to enable informed decision-making and support mission-critical business processes, including automated reconciliation and knowledge-style solutions where applicable.
• Consult with cross-functional partners to understand business needs and deliver 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, evaluate, and champion modern data technologies, frameworks, and best practices to improve operational excellence and accelerate data-driven innovation.

Requirements

• Bachelor’s degree with at least 7 years of applicable work experience.
• Required experience with Snowflake, IDMC, Informatica, and Oracle.
• Hands-on experience using 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 warehouse technologies experience.
• Strong data warehouse knowledge, preferably in the insurance domain, with 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.
• Strong experience with Python, R, and other modern languages, including experience 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 use full cloud potential.
• Experience with Agile and Kanban methodologies.

Technologies you may work with

• Informatica IDMC, Snowflake, Oracle
• AI, Generative AI, Snowflake Cortex, Agentic AI workflows
• Retrieval Augmented Generation (RAG), Model Context Protocol (MCP)
• Cloud-native data services, ETL, data pipelines
• CI/CD tooling, environment management, Enterprise GitHub, GitHub
• Autosys, SQL, Python, R, APIs
• AWS (plus), intelligent automation frameworks
• Agile, Kanban methodologies
• Metadata-driven architectures, enterprise data quality processes, data quality and reconciliation processes

Compensation and job details

• Location: Chicago, IL
• Category: Data & Analytics
• Employment type: Full time, Hybrid or Remote
• Job reference: R2627133-172
• Salary: USD 117,200 - 175,800 base pay annually
• Note: Actual base pay may vary based on performance, proficiency, and demonstration of required competencies.
• Other rewards: short-term or annual bonuses, long-term incentives, and on-the-spot recognition