FBS AWS Data Engineer

Our Client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products with gross written premiums well over US$25 Billion (P&C). They proudly serve more than 10 million U.S. households with more than 19 million individual policies across all 50 states through the efforts of over 48,000 exclusive and independent agents and nearly 18,500 employees. Finally, our Client is part of one the largest Insurance Groups in the world.

Position Overview

We are seeking a skilled and self-driven AWS Data Engineer to design, develop, and maintain scalable data ingestion frameworks that support enterprise analytics and reporting. The ideal candidate will have deep expertise in AWS technologies, data lake architecture, and cross-functional collaboration to deliver high-quality data solutions.

Key Responsibilities

Data Ingestion & Framework Development

• Design, build, and maintain reusable, modular, and configuration-driven frameworks for ingesting both historical and incremental data from diverse sources into Iceberg tables on AWS S3.
• Expose ingested data to Snowflake via Snowflake external tables, ensuring seamless integration and accessibility.
• Implement robust logging mechanisms to monitor all data processes, ensuring completeness, timeliness, accuracy, and validity (ABC metrics).
• Configure automated notifications to alert support teams of process statuses and anomalies.
• Adhere to architectural standards and development best practices throughout the lifecycle.

Solution Design & Execution

Cross-Team Collaboration

Proactive, Timely, Concise and Audience Appropriate Communication

Continuous Improvement

Self-Driven Problem Solving & Initiative

Requirements

Professional Experience

Technical Proficiency

Collaboration & Communication

Benefits

This position comes with competitive compensation and benefits package :

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.