Associate Data Engineer

Capgemini; Nashville (TN); On-site; USD 54,000 - 100,000; Full time

Benefits offered by this job

Paid time off

Health insurance

Retirement plan

Life insurance

Employee assistance

Job summary

Capgemini in Nashville, TN is seeking an Associate Data Engineer to design, develop, and support data integration solutions, including ETL/ELT processes, data pipelines, and data quality controls.

You will work under guidance within Agile delivery teams alongside solution architects, business analysts, and senior data engineers, performing testing, UAT support, and ongoing optimization.

Qualifications

• 2 years of experience in data engineering, software development, analytics, or a related technical role.
• Proficient SQL development and query optimization.
• Basic Python programming and scripting.
• Strong understanding of relational databases and ETL/ELT concepts.
• Knowledge of data warehousing concepts and data quality practices.
• Familiarity with Agile methodologies.

Responsibilities

• Develop and maintain ETL/ELT jobs, workflows, and data pipelines.
• Perform data extraction, transformation, and loading from multiple source systems.
• Create and run unit tests, integration tests, and data validation scripts.
• Support UAT and assist with issue resolution.
• Monitor data pipelines and troubleshoot data processing issues.
• Collaborate in Agile delivery teams with solution architects, analysts, and engineers.
• Support cloud migration and modernization initiatives.
• Build SQL queries, stored procedures, and scripts for reporting and analytics.

Skills

SQL development

Python basics

Relational databases

ETL/ELT concepts

Data quality

Agile methodologies

Education

Bachelor’s degree in Computer Science or related discipline

Tools

Snowflake

Azure Synapse

Databricks

BigQuery

Airflow

Data Factory

Informatica

SSIS

Spark

Kafka

DevOps

DataOps

Job description

The Associate Data Engineer will contribute to the design, development, testing, and ongoing support of data integration solutions, including ETL/ELT processes and data pipelines. This role operates under guidance from senior team members and works alongside solution architects, business analysts, and senior data engineers in Agile delivery teams.

Responsibilities

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

Requirements

• 2 years of experience in data engineering, software development, analytics, or a related technical role.
• SQL development and query optimization.
• Basic Python programming and scripting.
• Understanding of relational databases.
• Familiarity with ETL/ELT concepts.
• Basic understanding of data warehousing concepts.
• Knowledge of data quality and validation techniques.
• Understanding of Agile development methodologies.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, Mathematics, or a related discipline.

Technology Stack

• ETL/ELT, SQL, Python
• Snowflake, Azure Synapse, Databricks, BigQuery, Redshift
• Azure, AWS, GCP
• Airflow, Data Factory, Informatica, Talend, SSIS
• Spark, Hadoop, Kafka
• DevOps, DataOps

Preferred

• Experience with Snowflake, Azure Synapse, Databricks, BigQuery, Redshift, or similar platforms.
• Exposure to cloud platforms such as Azure, AWS, or GCP.
• Experience with Airflow, Data Factory, Informatica, Talend, SSIS, or equivalent data integration tools.
• Exposure to Spark, Hadoop, or Kafka.
• Knowledge of DevOps and DataOps practices.

Compensation

The base compensation range for this role in the posted location is $54,380 - $99.650 per year.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation 12-25 days depending on grade, company-paid holidays, personal days, and sick leave.
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
• Retirement savings plans (for example, 401(k) in the U.S. or RRSP in Canada).
• Life and disability insurance.
• Employee assistance programs.
• Other benefits as provided by local policy and eligibility.

Job Location

Onsite in Nashville, TN.