Data Engineer

vor 12 Stunden

Genf, Genf, Schweiz Pictet Vollzeit
Your team

Pictet 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 skilled and experienced Senior Data Engineer with expertise in Oracle, Postgres and AWS database solutions, experience working with multi-terabyte databases and a strong understanding of SQL performance tuning.

In this role, your proficiency in PL/SQL and PL/pgSQL, combined with experience with large-scale databases and expertise in AWS database solutions such as RDS and Aurora, will be critical in ensuring optimal database performance and data integrity.

Your role
  • Designing, developing and maintaining robust and scalable database procedures (e.g. data import, data processing) using PL/SQL, PL/pgSQL and AWS database-solution programming languages.
  • Optimising SQL queries and database performance by analysing execution plans, indexing strategies and query optimisation techniques.
  • Working with multi-terabyte databases, ensuring efficient data storage, retrieval and manipulation.
  • Troubleshooting and resolving database issues, performance bottlenecks and data inconsistencies.
  • Conducting regular performance monitoring and tuning activities to maintain optimal database performance.
  • Developing and maintaining database documentation, including data models, entity-relationship diagrams and data dictionaries.
  • Helping Java developers to develop and maintain their database-related code (e.g. model design, SQL queries, index creation/update).
Your profile
  • Expertise in PL/SQL and PL/pgSQL programming languages, with a strong understanding of their features and capabilities.
  • Experience in migrating on-premises Oracle databases to cloud-based database solutions.
  • Knowledge of AWS database and data stockage solutions like RDS, Aurora, S3.
  • Strong knowledge of SQL performance tuning techniques.
  • Proficiency in database design principles, data modelling and normalisation.
  • Experience in database security, access controls and data encryption.
  • Knowledge of Informatica is a plus.
  • Strong problem-solving skills and the ability to analyse complex data-related issues.
  • Excellent communication and collaboration skills to work effectively with cross-functional teams.
  • Strong attention to detail and a commitment to delivering high-quality work.
  • Readiness to participate in on-call duty (off premises) a few weeks per year.
  • Fluent in English.
  • Resident in Switzerland or willing to relocate.

We will not accept any CVs via agencies.

REF: SDE/AC/JL

Note

We will not accept any CVs via agencies

Diversity & Inclusion

Pictet is an equal opportunity employer and is committed to creating a diverse environment. We respect all individuals and seek their inclusion in the workplace.

  • IT Data Engineer

    vor 2 Wochen

    Genf, Genf, Schweiz LHH Vollzeit CHF 90'000 - CHF 120'000 pro Jahr

    For one of our clients in Geneva, we are recruiting an IT Data Engineer for a long term mission, who is open-minded and client-oriented, is passionate about his work, who believes in success and has a strong team spirit. Are you looking for you next challenging position? This opportunity is for youResponsibilities:In this role you capture and define data hub...

  • 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 Engineer

    vor 2 Wochen

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

    Company Description At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Consulting, Design, Cloud, Data, and Engineering,...

  • Data Engineer

    vor 13 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 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...

  • AWS/dbt Data Engineer

    vor 14 Stunden

    Genf, Genf, Schweiz AARK Tech Solutions GmbH Vollzeit

    Role:AWS/dbt Data EngineerLocation:Geneva Switzerland (need to relocate Switzerland )Hybrid Remote. 3 days a week in office. 2 days remote.Year of experience: Min. 8+ YearsLanguage:French – Advance and English Advanced.Open to Swiss and EU citizensJob Description:Customer is seeking a hands‑on Data Engineer to design, build, and operate modern ELT/ETL...

  • AWS/dbt Data Engineer

    vor 13 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...

  • Expert Data Engineer Consultant

    vor 2 Wochen

    Genf, Genf, Schweiz Orange Business Vollzeit

    The team, position & mission:We are looking for a hands-on Expert Data Engineer to join our dynamic team. The ideal candidate will have a strong foundation in SQL, with a proven track record of building and optimizing data systems and pipelines.Your key areas of responsibility as Data Engineer:Design, build, and maintain efficient, reliable, and scalable...

  • 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 Engineer

    vor 14 Stunden

    Genf, Genf, Schweiz SpeciTec SA Vollzeit

    Description de l'offreSpeciTec SA recrute un Data Engineer / Data Developer BI senior afin de renforcer son pôle Data et Reporting. Vous serez responsable de la conception, de l'évolution et de l'exploitation du Datawarehouse, ainsi que de la production de rapports décisionnels destinés aux équipes internes et aux clients. Ce poste est fortement...