Job Summary:
Capgemini US LLC is seeking a mid-level Data Engineer & DBA to join their data platform team. The role involves building and maintaining scalable data pipelines, ensuring database reliability and performance, and collaborating with various teams to deliver clean and timely data.
Responsibilities:
โข Design, build and maintain ETL/ELT pipelines across multiple systems
โข Design and optimize data models in PostgreSQL, MongoDB, and Amazon Redshift
โข Develop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)
โข Administer and maintain database environments across development, staging, and production
โข Monitor data pipelines and databases, troubleshoot issues, and implement alerts
โข Optimize query performance, indexes, and configurations across relational and NoSQL systems
โข Manage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)
โข Ensure database security, including access control, encryption, and role management
โข Plan capacity and scale systems to support growing data needs
โข Define and enforce data retention and archival policies
โข Collaborate with analytics and product teams to support reporting and data needs
โข Document data pipelines, database processes, and operational procedures
โข Participate in code reviews and follow engineering best practices
Qualifications:
Required:
โข 3โ5 years of experience in data engineering, database administration, or similar roles
โข Strong experience with PostgreSQL, MongoDB, and Amazon Redshift
โข Solid SQL skills for both transactional and analytical workloads
โข Experience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)
โข Proficiency in Python or another scripting language
โข Experience with workflow orchestration tools (Airflow, Step Functions, etc.)
โข Hands-on database administration experience, including: MongoDB (replica sets, sharding, indexing, backups), Redshift (cluster management, query tuning, WLM, snapshots), PostgreSQL (replication, performance tuning, connection pooling)
โข Familiarity with monitoring tools (CloudWatch, pgBadger, MongoDB Atlas, etc.)
โข Understanding of database security (encryption, auditing, least-privilege access)
โข Bachelorโs degree in Computer Science, Engineering, or a related field โ or equivalent experience.
Preferred:
โข Experience with Kafka or Kinesis (streaming data)
โข Familiarity with dbt for data transformation
โข Knowledge of data lake/lakehouse architectures (Delta Lake, AWS Lake Formation)
โข Experience with Terraform or CloudFormation
โข CI/CD experience for data pipelines
โข Basic DevOps skills
Company:
eTeam is a staffing agency that also provides payrolling services. Founded in 1999, the company is headquartered in Somerset, USA, with a team of 501-1000 employees. The company is currently Late Stage.