Sr Cloud Data and AI Engineer

As a Senior Cloud Data and AI Engineer, you will design and operationalize scalable, cloud-native data solutions that support Employer Benefits actuarial functions. The role combines technical leadership in enterprise data engineering with evaluation and delivery of AI and intelligent automation capabilities in a hybrid or remote work environment.

Responsibilities

• Engage in continuing education and 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 high-quality, scalable data solutions to support pricing and reserving activities for the Employer Benefit Actuarial team.
• Synthesize, reconcile, and explain data differences between Employer Benefits actuarial output and other standard published data.
• Develop deep understanding of actuarial applications, data elements, and business processes.
• Collaborate with actuarial customers during the close of current financial months to address time-sensitive issues while planning strategic solutions for the next release cycle.
• Provide technical leadership and mentorship to junior engineers and foster collaboration across onshore and offshore teams to deliver innovative, scalable, and sustainable data solutions.
• Discover, analyze, and integrate data from diverse sources to support decision-making and mission-critical business processes.
• Consult with cross-functional partners to understand business needs and deliver solutions that are reliable and maintainable.
• Work directly with customers to understand needs and provide solutions.
• Develop and maintain scalable data pipelines and ETL processes supporting 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 drive operational excellence and accelerate data-driven innovation, working within agile delivery frameworks to enhance enterprise data assets and capabilities.
• Build deep functional knowledge of pricing, rating, and actuarial processes while partnering across organizations.

Requirements

• Bachelor’s degree with at least 7 years of applicable work experience.
• Required experience: Snowflake, IDMC (Informatica IDMC), Informatica, 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 of experience in ETL, data analysis, and warehouse technologies.
• 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 building APIs, automation frameworks, AI-driven applications, and cloud-native data services.
• Experience modernizing data pipelines via on-premises to cloud migration.
• Experience in Agile and Kanban methodologies.

Technology Focus

• Informatica IDMC, Snowflake, AI, Generative AI, cloud-native data services
• CI/CD, environment management, Oracle, metadata-driven architectures, enterprise data quality
• Agentic AI workflows, Retrieval Augmented Generation (RAG), Model Context Protocol (MCP)
• Snowflake Cortex, Enterprise GitHub, ETL, Autosys, SQL
• Python, R, APIs, AWS, Agile, Kanban

Location and Work Schedule

• Location: Hartford, CT (hybrid)
• Office expectations: Hybrid or remote schedule. Candidates living near an office are expected to work in-office 3 days per week (Tuesday through Thursday). Candidates who do not live near an office should maintain their current work arrangement with the expectation of coming into the office as business needs arise.

Compensation

$117,200 - $175,800 annualized base pay range.

Employment Details

• Category: Data & Analytics
• Employment Type: Full time, Hybrid or Remote
• Job Ref: R2627133-168

Authorization to Work

• 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.