1 day ago
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
Categories
Data Engineering
About Capgemini
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.
