Data Architect/Data Engineer

Capgemini

Atlanta (GA)

On-site

USD 66,000 - 103,000

Part time

2 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical

Dental

Vision and retirement benefits

Job summary

Capgemini is seeking a Data Architect / Data Engineer for an onsite contract role in Atlanta, GA. You will design scalable and secure data architectures, build data models, and develop ETL/ELT pipelines across data warehouses, data lakes, and lakehouse patterns.

The role requires strong SQL and data analysis skills, experience with cloud data services (GCP/AWS/Azure), and ability to collaborate with governance and business teams. Onsite in Atlanta, contract engagement with Capgemini.

Qualifications

Strong experience in data architecture, data engineering, or enterprise data integration.
Strong knowledge of relational databases, dimensional modeling, and modern cloud data architectures.
Hands-on experience designing and implementing complex data pipelines.
Strong SQL and data analysis skills.
Ability to translate business requirements into scalable technical solutions.
Understanding of OLTP vs. OLAP, Star/Snowflake schemas, and data warehousing concepts.
Ability to conduct architecture reviews and provide technical guidance to engineering teams.
Excellent analytical, problem-solving, documentation, and communication skills.
Effective collaboration with technical and business stakeholders.

Responsibilities

Design scalable and secure enterprise data architectures based on business requirements.
Create conceptual, logical, and physical data models.
Architect solutions for data warehouses, data lakes, and lakehouse patterns.
Define data architecture principles, standards, patterns, and best practices.
Assess existing data architecture and identify modernization opportunities.
Design data solutions spanning structured, semi-structured, and unstructured data.
Design, build, and maintain scalable ETL/ELT pipelines.
Integrate data from multiple internal and external source systems.
Develop transformation and processing solutions for batch and streaming workloads.
Build reusable ingestion, transformation, validation, and publishing frameworks.
Optimize pipelines and database queries for performance and scalability.
Perform data profiling, cleansing, reconciliation, and data-quality validation.
Troubleshoot data pipeline failures and production data issues.
Implement cloud-based data solutions using GCP, AWS, or Azure.
Work with cloud data services including data warehouses, data lakes, object storage, and distributed processing.
Support migration and modernization of legacy/on-premise platforms to cloud architectures.
Design with scalability, reliability, security, performance, and cost in mind.
Implement enterprise data standards including metadata management, data lineage, and data-quality practices.
Ensure solution designs include appropriate data access controls and security standards.
Collaborate with governance and business teams on consistent enterprise data definitions and standards.
Provide technical guidance to engineering teams through architecture reviews.

Skills

Data architecture

Data engineering

ETL/ELT

SQL

Cloud platforms

Big data

Tools

Informatica

Databricks

Snowflake

BigQuery

Spark

Airflow

DBT

Kafka

Python

NoSQL

Git

Job description

Capgemini is hiring a Data Architect / Data Engineer for an onsite contract role in Atlanta, GA 30305.

Responsibilities

Design scalable and secure enterprise data architectures based on business requirements
Create conceptual, logical, and physical data models
Architect solutions for data warehouses, data lakes, and lakehouse patterns
Define data architecture principles, standards, patterns, and best practices
Assess existing data architecture and identify modernization opportunities
Design data solutions spanning structured, semi-structured, and unstructured data
Design, build, and maintain scalable ETL/ELT pipelines
Integrate data from multiple internal and external source systems
Develop transformation and processing solutions for batch and streaming workloads
Build reusable ingestion, transformation, validation, and publishing frameworks
Optimize pipelines and database queries for performance and scalability
Perform data profiling, cleansing, reconciliation, and data-quality validation
Troubleshoot data pipeline failures and production data issues
Implement cloud-based data solutions using GCP, AWS, or Azure
Work with cloud data services including data warehouses, data lakes, object storage, and distributed processing
Support migration and modernization of legacy/on-premise platforms to cloud architectures
Design with scalability, reliability, security, performance, and cost in mind
Implement enterprise data standards including metadata management, data lineage, and data-quality practices
Ensure solution designs include appropriate data access controls and security standards
Collaborate with governance and business teams on consistent enterprise data definitions and standards
Provide technical guidance to engineering teams through architecture reviews

Requirements

Strong experience in data architecture, data engineering, or enterprise data integration
Strong knowledge of relational databases, dimensional modeling, and modern cloud data architectures
Hands‑on experience designing and implementing complex data pipelines
Strong SQL and data analysis skills
Ability to translate business requirements into scalable technical solutions
Understanding of OLTP vs. OLAP, normalized/3NF modeling, dimensional modeling, Star/Snowflake schemas, and data warehousing concepts
Ability to conduct architecture reviews and provide technical guidance to engineering teams
Excellent analytical, problem‑solving, documentation, and communication skills
Effective collaboration with technical and business stakeholders