This role is focused on designing, building, and managing secure, scalable data platforms that support regulatory compliance, passenger processing, and operational reporting for a global cruise organization. The position plays a critical role in ensuring accurate and timely reporting to U.S. Customs and Border Protection (CBP) and other government agencies while maintaining enterprise data governance standards.
Your role
- Develop and maintain enterprise ETL/ELT pipelines for passenger, crew, operational, and compliance data.
- Build integrations for automated transmission of passenger manifests, crew information, and regulatory reports.
- Design real-time and batch data 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/recovery, replication, and performance tuning.
- Design hybrid cloud architectures spanning AWS cloud and onboard vessel systems.
- Implement CI/CD, GitOps, and Infrastructure-as-Code practices using tools like Terraform and GitHub Actions.
- Collaborate with operations, security, IT, architecture, and development teams.
- Provide technical leadership and mentor junior engineers.
Skills and experience
- 6+ years in Data Engineering, Database Engineering, or Data Platform Architecture.
- Experience in highly regulated environments with compliance and audit requirements.
- Strong background in enterprise-scale data integration and hybrid cloud architectures.
- Advanced SQL and database design.
- Strong expertise in Snowflake (data modeling, security, performance tuning, administration).
- Experience with dbt for data transformations.
- Hands-on experience with ETL tools such as Matillion, Informatica, Talend, ADF, 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/snowflake schemas, and Data Vault.
- Experience with APIs, message queues, CI/CD pipelines, Git, and Infrastructure-as-Code.
- Must be willing to travel to Miami as needed.
The base compensation range for this role in the posted location is: $83,951 - $156,310.
Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.
The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.
These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.
It is not typical for candidates to be hired at or near the top of the posted compensation range.
In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.
Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:
- 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