AWS/dbt Data Engineer
vor 2 Wochen
Role:
AWS/dbt Data Engineer
Location:
Geneva Switzerland (need to relocate Switzerland )
Hybrid Remote
. 3 days a week in office. 2 days remote.
Year of experience
: Min. 8+ Years
Language:
French – Advance and English Advanced.
Open to Swiss and EU citizens
Job Description:
Customer is seeking a hands‑on Data Engineer to design, build, and operate modern ELT/ETL workflows on AWS. The ideal candidate is exceptionally strong in SQL, data modeling (Data Vault, star/snowflake, 3NF, and data mesh concepts), and automation using DBT and shell scripting. You will collaborate with data analysts, architects, and business stakeholders to deliver reliable, governed data products that power analytics and reporting across Alternative Investments.
Key Responsibilities
- Data Pipelines: Design, build, and maintain robust, testable ELT/ETL pipelines on AWS (Redshift, RDS, S3, Lambda), leveraging dbt (Core/Cloud; dbt Docs; ideally Fusion engine) and Informatica where applicable.
- SQL Excellence: Write high‑quality SQL (CTEs, window functions, complex joins) for transformations, data quality checks, and performance tuning, primarily targeting Redshift/RDS/Oracle/PostgreSQL.
- Data Modeling: Develop and evolve logical/physical data models (Data Vault, dimensional star/snowflake, 3NF) aligned to data mesh principles and Customer's governance standards.
- Automation & Ops: Implement CI/CD with GitHub/GitLab; manage environments, versioning, and documentation; build scripts (bash/shell) for orchestration and housekeeping.
- Quality & Observability: Embed tests (dbt tests, SQL assertions), logging and monitoring fundamentals; ensure data reliability, lineage visibility, and auditable processes.
- Security & Compliance: Collaborate with IAM and platform teams to apply least‑privilege access on AWS; follow internal controls and data governance policies.
- Stakeholder Collaboration: Work closely with business and analytics teams (French/English) to translate requirements into scalable data products; provide clear documentation via dbt Docs.
Must‑Have Qualifications
- Advanced SQL: Complex queries using CTEs and window functions.
- Bash/Shell Scripting: Automation and operational scripts.
- Data Modeling: Data Vault, star/snowflake, 3NF, and data mesh concepts.
- AWS: Redshift, RDS, S3, Lambda, IAM (hands‑on).
- dbt: Core & Cloud, dbt Docs; familiarity with Fusion engine preferred.
- Version Control: GitHub/GitLab (branches, PRs, code reviews).
- Informatica: Experience building/operating data pipelines.
- Databases: Oracle
and PostgreSQL.
Nice to Have
- Data Migration: Experience migrating workloads/data to AWS.
- Python: Scripting for utilities, tests, small transforms
- Domain knowledge: Ideally experience in Alternative Investments (Private Assets and / or Hedge Funds)
-
AWS/dbt Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz W3Global VollzeitRole: AWS/dbt Data EngineerLocation: Geneva SwitzerlandYears of Experience: Min. 8+ YearsType of Hiring: PermanentLanguage: French - Advance and English Advanced.Onsite/Offsite: Hybrid Remote. 3 days a week in office.Start/ End Date : Immediate (3 Months NP won't work.)Please share only EU/Swiss Nationals/Valid B Permit/Valid C Permit.Job DescriptionCustomer...
-
AWS Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz Skywaves Rise VollzeitRole : AWS Data EngineerLocation : Geneva , SwitzerlandPlease share only EU/Swiss Nationals/Valid B Permit/Valid C Permit.Job Description:Customer is seeking a hands‑on Data Engineer to design, build, and operate modern ELT/ETL workflows on AWS. The ideal candidate is exceptionally strong in SQL, data modeling (Data Vault, star/snowflake, 3NF, and data...
-
AWS data Engineer
vor 2 Wochen
Genf, Genf, Schweiz beatmysalary VollzeitLocation : GenevaVisa independent candidates only, please.Job Description:Customer is seeking a hands‑on Data Engineer to design, build, and operate modern ELT/ETL workflows on AWS. The ideal candidate is exceptionally strong in SQL, data modeling (Data Vault, star/snowflake, 3NF, and data mesh concepts), and automation using DBT and shell scripting. You...
-
Senior Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz K&K Talents VollzeitK&K Talentsis an international recruiting agency that has been providing technical resources in the European region since 1993. This position is with one of our clients inPolandwho is actively hiring candidates to expand their teams.Role: AWS Data EngineerLocation: Geneva, Switzerland (Hybrid)Employment type: Fulltime PermanentMust‑Have...
-
Data Engineer
Vor 5 Tagen
Genf, Genf, Schweiz TechFirm Information Systems VollzeitQui sommes-nous?Depuis notre création en 2015, TechFirm, société de conseil Suisse est plus qu'une simple entreprise. Nous sommes une centaine d'esprits libres, répartis entre Genève, Zurich et Marseille, travaillant ensemble pour révolutionner les systèmes d'informations de nos clients bancaires, industriels ou encore étatiques. Profil...
-
Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz Pictet Group VollzeitYour teamPictet Asset Management SAmanages the assets of some of the world's largest institutions, financial intermediaries and their clients. Our culture welcomes independent thinkers and centres around investment excellence, a long-term perspective and a dedication to client service.For our PAM Tech & Operations department, we are seeking to hire a highly...
-
Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz Pictet VollzeitYour teamPictet Asset Management SA manages the assets of some of the world's largest institutions, financial intermediaries and their clients. Our culture welcomes independent thinkers and centres around investment excellence, a long-term perspective and a dedication to client service.For our PAM Tech & Operations department, we are seeking to hire a highly...
-
Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz Pictet Group VollzeitYour teamPictet Asset Management SAmanages the assets of some of the world's largest institutions, financial intermediaries and their clients. Our culture welcomes independent thinkers and centres around investment excellence, a long-term perspective and a dedication to client service.For our PAM Tech & Operations department, we are seeking to hire a highly...
-
Data Engineer
vor 2 Wochen
Genf, Genf, Schweiz API SA VollzeitPourquoi choisir API ?API, avec plus de 30 ans d'expérience, est une entreprise familiale, reconnue pour sa réelle expertise IT ; transformation digitale, service de support, Cloud...Nous avons su nous nous entourer des meilleurs experts afin de répondre au mieux aux besoins spécifiques de nos clients.En optant pour API, vous choisissez une entreprise à...
-
Senior Data Engineer
Vor 5 Tagen
Genf, Genf, Schweiz ZYTLYN Technologies VollzeitWho we areZYTLYN Technologies empowers companies across the $11 trillion travel industry to shape the future with predictive AI solutions that augment commercial planning, sales, marketing, retailing and operations. We work with some of the largest travel brands in the world, and our vision is to answer highly detailed and granular questions about the future...