Associate Data Engineer: Build Scalable Data Pipelines

Capgemini; Bridgewater, Northern (MA, KY); Hybrid; USD 75,000 - 95,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, and vision coverage

401(k) retirement plan

Job summary

Capgemini invites applications for an Associate Data Engineer in the United States, focusing on designing, developing, testing, and maintaining data integration pipelines. You will work under guidance to ensure data quality and governance while gaining expertise in cloud data services.

You will build ETL/ELT jobs, perform data extraction and loading across sources, and collaborate with agile teams to deliver scalable data solutions for analytics and reporting.

Qualifications

• Bachelor's degree in a related discipline.
• 2+ years of experience in data engineering or related roles.
• Proficiency in SQL and data modeling.
• Experience with ETL/ELT and cloud data platforms.

Responsibilities

• Develop and maintain ETL/ELT jobs, workflows, and data pipelines.
• Perform data extraction, transformation, and loading from multiple source systems.
• Create and execute unit tests, integration tests, and data validation scripts.
• Support UAT and assist in issue resolution.
• Monitor data pipelines and troubleshoot data processing issues.
• Perform data cleansing, profiling, and validation activities.
• Develop SQL queries, stored procedures, and scripts to support reporting and analytics.
• Assist in implementing data quality controls and governance standards.
• Support cloud migration and modernization initiatives.
• Collaborate with solution architects, business analysts, and senior data engineers in Agile delivery teams.

Skills

SQL development

Python scripting

ETL/ELT concepts

Data warehousing concepts

Relational databases

Airflow

Data Factory

Informatica

Talend

SSIS

Cloud platforms (Azure AWS GCP)

Spark/Hadoop/Kafka

Agile delivery

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Technology

Tools

Airflow

Data Factory

Informatica

Talend

SSIS

Job description

Capgemini invites applications for an Associate Data Engineer in the United States, focusing on designing, developing, testing, and maintaining data integration pipelines. You will work under guidance to ensure data quality and governance while gaining expertise in cloud data services.

You will build ETL/ELT jobs, perform data extraction and loading across sources, and collaborate with agile teams to deliver scalable data solutions for analytics and reporting.