AWS/dbt Data Engineer

vor 12 Stunden

Genf, Genf, Schweiz AARK Tech Solutions GmbH Vollzeit

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 11 Stunden

    Genf, Genf, Schweiz W3Global Vollzeit

    Role: 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 1 Woche

    Genf, Genf, Schweiz K&K Talents Vollzeit

    K&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: Permanent Full TimeKey ResponsibilitiesData...

  • Data Modeler

    vor 1 Woche

    Genf, Genf, Schweiz Randstad Digital Switzerland Vollzeit

    Randstad Digital Switzerland is seeking an accomplished Senior Data Engineer to support our client in building the next generation of data platforms for the complex and dynamic aviation industry.If you thrive on transforming intricate datasets into reliable, actionable insights, and possess deep expertise in Python, SQL, dbt, and Snowflake, this is your...

  • Data Engineer

    vor 2 Wochen

    Genf, Genf, Schweiz TechFirm Information Systems Vollzeit CHF 90'000 - CHF 110'000 pro Jahr

    Qui 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 11 Stunden

    Genf, Genf, Schweiz Pictet Group Vollzeit

    Your 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 11 Stunden

    Genf, Genf, Schweiz Pictet Vollzeit

    Your 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...

  • Principal Data Engineer

    Vor 6 Tagen

    Genf, Genf, Schweiz Technology Staffing Group Vollzeit

    𝗔𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝗖𝗼𝗺𝗽𝗮𝗻𝘆:Our client is one of the worlds leading independent commodity trading companies, operating worldwide. Known for innovation and integrity, the company is a market leader in the trade, transport, storage, and optimization of energy products. This is an opportunity to work in a global, dynamic...

  • Data Analyst

    vor 1 Woche

    Genf, Genf, Schweiz KATCHME CONSULTING Vollzeit

    Cette mission est en Mi-TempsNous recherchons deux data analyst pour une migration de modèles DBT afin de changer une partie du sourcing de la partie principale des Datamarts.Environnement & Contexte :Principalement pour les tables Client & Transactions, mais aussi d?autres modèles (Campaign, Clienteling), nous souhaitons ne plus nous sourcer sur un...

  • Data engineer

    vor 11 Stunden

    Genf, Genf, Schweiz Qim info Vollzeit

    Qim info, qui sommes-nous ?Société d'ingénierie informatique et de services du numérique créée en 2004 et implantée en Suisse (Genève, Lausanne, Zurich & Bâle) et en France (Annecy, Lyon & Paris).Qim info c'est surtout un ensemble de consultant.e.s capables d'intervenir à tous les niveaux d'un Système d'Information sur différents métiers (Etudes...

  • Data Engineer

    vor 2 Wochen

    Genf, Genf, Schweiz Expleo Vollzeit CHF 80'000 - CHF 120'000 pro Jahr

    OverviewExpleo offers a unique range of integrated engineering, quality and strategic consulting services for digital transformation. At a time of unprecedented technological acceleration, we are the trusted partner of innovative companies. We help them develop a competitive advantage and improve the daily lives of millions of people.  Joining Expleo...