Data Architect/Data Engineer

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

Technologies

• SQL
• ETL / ELT
• GCP, AWS, Azure
• Data Lake / Lakehouse
• Informatica / IICS
• Databricks
• Snowflake
• BigQuery
• Spark / PySpark
• Python
• Kafka
• Airflow / Cloud Composer
• DBT
• NoSQL databases
• API-based data integration
• Metadata and data catalog solutions
• CI/CD and DevOps practices
• Git
• Agile / Scrum

Benefits

• Medical
• Dental
• Vision and retirement benefits

Preferred / Secondary Skills

• Informatica / IICS
• Databricks
• Snowflake
• BigQuery
• Spark / PySpark
• Python
• Kafka or other streaming technologies
• Airflow / Cloud Composer
• DBT
• NoSQL databases
• API-based data integration
• Metadata and data catalog solutions
• CI/CD and DevOps practices
• Git
• Agile / Scrum

Preferred Experience

• Enterprise-scale cloud migration or data modernization programs
• Legacy ETL and data warehouse modernization
• Real-time and streaming data architectures
• Data governance, metadata management, lineage, and data-quality frameworks
• Designing data platforms supporting BI, analytics, AI/ML, and GenAI use cases

Location: Atlanta, GA 30305 (onsite) | Compensation: USD 48 - 75 per hour | Job type: contract