Data Engineer

June 4

Apply Now

Receive Emails with Similar Jobs

Capgemini

WebsiteLinkedInAll Job Openings

Enterprise • Artificial Intelligence • Cybersecurity

Capgemini is a global leader in partnering with businesses to transform and manage their operations by harnessing the power of technology. With expertise across a wide array of industries such as aerospace, automotive, banking, and healthcare, Capgemini provides a constantly evolving portfolio of services to meet the ever-changing needs of their clients. Their offerings include cloud, cybersecurity, data and artificial intelligence, and enterprise management, among others. Capgemini also emphasizes innovation and sustainability, helping companies achieve digital transformation while promoting environmental and social responsibility. Additionally, Capgemini provides career opportunities across various levels and professions, encouraging innovation and diversity in its workforce.

10,000+ employees

Founded 1967

🏢 Enterprise

🤖 Artificial Intelligence

🔒 Cybersecurity

📋 Description

• Capgemini is seeking a highly motivated and detail-oriented Associate Data Engineer for a top 10 US Insurance Carrier. • Our client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products. • We are looking for a skilled Data Engineer to design, build, and maintain data pipelines that support analytics and business intelligence initiatives. • Role involves enhancing existing pipelines and developing new ones to integrate data from diverse sources. • Ideal candidate will have advanced SQL and Informatica skills, experience in ETL development, basic dimensional data modeling understanding.

🎯 Requirements

• Design, develop, and maintain data pipelines and ETL workflows to ensure reliable data integration across platforms. • Enhance and optimize existing data pipelines by adding new attributes, improving performance, or increasing maintainability. • Build new data ingestion pipelines from a variety of structured and semi-structured sources. • Use Informatica to develop and manage ETL processes in alignment with business requirements. • Write and optimize complex SQL queries for data transformation, validation, and extraction. • Apply basic knowledge of dimensional data modeling to support reporting and data warehousing needs. • Collaborate with data analysts, data scientists, and business teams to understand data needs and deliver clean, structured datasets. • Participate in code reviews, documentation, and testing to ensure quality and accuracy in data delivery. • Work in agile or project-based environments to deliver on sprint goals and project timelines. • Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience). • 2–4 years of hands-on experience in data engineering or ETL development. • SQL: Advanced-level proficiency in writing, optimizing, and troubleshooting queries. • ETL Tools: Intermediate experience building and managing pipelines using ETL platforms. • Informatica: Advanced experience with PowerCenter or Informatica Cloud for data integration tasks. • Dimensional Data Modeling: Basic understanding of star and snowflake schema designs. • Excellent problem-solving and communication skills with an ability to collaborate across teams. • Experience with DBT (Data Build Tool) for modular and scalable transformation logic. • Exposure to cloud data platforms (AWS, GCP, Azure).

🏖️ Benefits

• Competitive salary and performance-based bonuses • Comprehensive benefits package • Career development and training opportunities • Flexible work arrangements (remote and/or office-based) • Dynamic and inclusive work culture within a globally reknowned group • Private Health Insurance • Pension Plan • Paid Time Off • Training & Development