Data Engineer - AWS Engineer

Capgemini • Chicago, IL

1d

About The Position

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.About the job you're consideringThe Amazon Redshift DBA is responsible for designing, implementing, administering, and optimizing Redshift clusters used for analytics and data warehousing. This role involves database performance tuning, workload management, automation, security configuration, monitoring, and supporting BI/data engineering teams to ensure high availability and optimal performance of the Redshift environment.

Requirements

• 5+ years of experience as a DBA (preferably in cloud data warehouse environments).
• Strong hands-on experience with Amazon Redshift, Redshift Serverless, and Redshift Spectrum.
• Expert-level SQL skills, including query tuning.
• Strong understanding of data warehousing concepts: star/snowflake schemas, OLAP design.
• Experience with Python or Bash scripting.
• Familiarity with AWS services such as S3, IAM, CloudWatch, Glue, Lambda, KMS, VPC.
• Familiarity with ETL tools (Informatica, Talend, Matillion, Glue, etc.).
• Strong analytical, troubleshooting, and performance tuning skills.

Nice To Haves

• AWS Certified Database - Specialty or AWS Data Analytics certification.
• Knowledge of Redshift RA3 nodes, AQUA, concurrency scaling, and materialized views.
• Familiarity with SQL-on-S3 engines (Athena ).
• Experience with DevOps or Infrastructure-as-Code (Terraform, CloudFormation).

Responsibilities

• Provision, configure, and maintain Amazon Redshift clusters.
• Monitor cluster health, storage, CPU, and query performance.
• Manage snapshot schedules, backups, and restore operations.
• Perform routine maintenance including VACUUM, ANALYZE, and table distribution optimizations.
• Optimize Redshift schema design (distribution keys, sort keys, compression).
• Tune complex SQL queries and optimize workload management (WLM) queues.
• Analyze system logs and STL tables to diagnose slow-running queries and bottlenecks.
• Assist data engineers with efficient data ingestion using COPY commands, Glue, Lambda, Step Functions, or external ETL tools.
• Manage Spectrum, external schemas, and integration with S3.
• Implement IAM-based access controls and manage users, groups, and roles.
• Configure data encryption (KMS), network security, and auditing.
• Ensure compliance with enterprise data governance and security policies.
• Automate cluster scaling, monitoring, auditing, and tuning tasks using scripts (Python, Bash) or AWS services.
• Create automated alerts using CloudWatch, SNS, and Lambda.
• Integrate Redshift admin tasks with CI/CD pipelines (CodeBuild, Jenkins, Azure DevOps, etc.).
• Monitor cluster logs, disk usage, queue performance, and query throughput.
• Troubleshoot connectivity, query failures, and cluster performance degradation.
• Provide on-call support for production Redshift environments.
• Work closely with data engineering, analytics, and business intelligence teams.
• Document schema changes, cluster configurations, operational procedures, and best practices.
• Provide guidance to teams on Redshift best practices and cost optimization.

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, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed