Capgemini

Senior Data Engineer

Capgemini
Apply
1 day ago
Atlanta, GA, USASenior
H1B sponsor

Base Salary

$84k - $156k/yr

Responsibilities

  • Develop and maintain enterprise ETL/ELT pipelines for passenger, crew, operational, and compliance data.
  • Build automated integrations for passenger manifests, crew information, and regulatory reports.
  • Design real-time and batch processing solutions using Python, SQL, AWS, Snowflake, dbt, Matillion, and Airflow.
  • Ensure data quality, monitoring, reconciliation, traceability, and audit readiness.
  • Support CBP reporting, biometric identity programs, privacy regulations, and data governance initiatives.
  • Administer and optimize databases, including high availability, backup and recovery, replication, and performance tuning.
  • Design hybrid cloud architectures spanning AWS and onboard vessel systems.
  • Implement CI/CD, GitOps, and Infrastructure-as-Code practices using Terraform and GitHub Actions.
  • Collaborate with operations, security, IT, architecture, and development teams.
  • Provide technical leadership and mentor junior engineers.

Requirements

  • At least 6 years of experience in Data Engineering, Database Engineering, or Data Platform Architecture.
  • Experience working in highly regulated environments with compliance and audit requirements.
  • Strong enterprise-scale data integration and hybrid cloud architecture experience.
  • Advanced SQL and database design skills.
  • Strong expertise in Snowflake data modeling, security, performance tuning, and administration.
  • Experience using dbt for data transformations.
  • Hands-on experience with ETL tools such as Matillion, Informatica, Talend, Azure Data Factory, AWS Glue, or SSIS.
  • Advanced Python programming for automation, orchestration, and API integrations.
  • Database experience with SQL Server, Oracle, PostgreSQL, and MySQL.
  • Knowledge of dimensional modeling, star schemas, snowflake schemas, and Data Vault.
  • Experience with APIs, message queues, CI/CD pipelines, Git, and Infrastructure-as-Code.
  • Willingness to travel to Miami as needed.

Benefits

  • Comprehensive benefits package for regular, full-time employees.
  • Paid time off including 12–25 vacation days depending on employee grade, company holidays, personal days, and sick leave.
  • Medical, dental, and vision coverage, or provincial healthcare coordination in Canada.
  • Retirement savings plans such as 401(k) in the U.S. and RRSP in Canada.
  • Life and disability insurance and employee assistance programs.
  • Benefits are subject to local policy and eligibility; travel to Miami may be required as needed.

Tech Stack

Apache AirflowAWSdbtGitGitHub ActionsInformaticaMicrosoft SQL ServerMySQLPostgreSQLPythonSnowflakeSQLTalendTerraform

Categories

Data Engineering
Capgemini

About Capgemini

10,000+ employees

Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.

Contact me