Data Engineer

vor 10 Stunden

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: DE/AC/AK

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.

  • Cloud Data

    vor 2 Wochen

    Schweiz SIX Vollzeit CHF 80'000 - CHF 100'000 pro Jahr

    SIX drives the transformation of financial markets.What sets us apart drives us ahead: between local roots and global relevance, we are a unique blend of tradition and future, of foundation and growth. We value bright minds and inspire them to grow with their ideas. Come and shape the future of finance with us. Cloud Data & ML Engineer %) Zurich | % |...

  • Data Engineer

    vor 2 Wochen

    Schweiz Bitcoin Devs Company Vollzeit CHF 80'000 - CHF 120'000 pro Jahr

    Overview: As a Data Engineer at our Switzerland-based, 100% remote team, you will play a crucial role in designing, developing, and maintaining scalable data pipelines and infrastructure for our data-driven organization. You will collaborate with cross-functional teams to ensure the availability, reliability, and accessibility of high-quality data for...

  • Senior Engineer Data Centre Solutions

    vor 1 Woche

    Schweiz Datwyler Vollzeit CHF 40'000 - CHF 120'000 pro Jahr

    Erfolgreiche Digitalisierung beginnt mit der wegweisenden IT-Infrastruktur von Dätwyler. Dätwyler IT Infra ist ein international etabliertes Unternehmen mit Hauptsitz in der Schweiz und Niederlassungen in Europa, dem Nahen Osten und Asien. Das Unternehmen liefert erstklassige Systemlösungen, Produkte und Dienstleistungen für Rechenzentren,...

  • Principal Data Scientist

    vor 2 Wochen

    Schweiz Johnson & Johnson Family of Companies Vollzeit

    **Principal Data Scientist **(m/v/x)** Janssen Pharmaceutica N.V. is recruiting a Principal Data Scientist. This position will be based in Beerse, Belgium. Other locations considered: United Kingdom, France, Germany, Spain, Italy and Switzerland. Travel in Europe up to 20% may be required. You will work closely together with colleagues across the...

  • Senior Application Engineer

    vor 1 Woche

    Schweiz SIX Vollzeit CHF 60'000 - CHF 120'000 pro Jahr

    SIX treibt die Transformation der Finanzmärkte voran. Was uns unterscheidet, treibt uns voran: Zwischen lokalen Wurzeln und globaler Relevanz sind wir eine einzigartige Mischung aus Tradition und Zukunft, aus Fundament und Wachstum. Wir schätzen kluge Köpfe und inspirieren sie, mit ihren Ideen zu wachsen. Komm und gestalte die Zukunft der Finanzmärkte...

  • Systems Engineer

    Vor 6 Tagen

    Schweiz Fortinet Vollzeit € 60'000 - € 120'000 pro Jahr

    DescriptionSystems Engineer – Enterprise AccountsJoin Fortinet, a cybersecurity pioneer with over two decades of excellence, as we continue to shape the future of cybersecurity and redefine the intersection of networking and security. At Fortinet, our mission is to safeguard people, devices, and data everywhere. We are currently seeking a dynamic Systems...

  • Careers: R&D Engineer Trainee

    vor 2 Wochen

    Schweiz Sulzer Vollzeit CHF 60'000 - CHF 90'000 pro Jahr

    Internship R&D Engineer (Data Science) - Full Time - Oberwinterthur, SwitzerlandSulzer is a leading engineering company with a proud heritage of innovation. Join our global team to grow your expertise and develop innovative solutions that enable a prosperous and more sustainable society. We are looking for an R&D Engineer, Data Science Intern to join our...

  • Enterprise IP Pre-Sales Engineer in Switzerland

    vor 2 Wochen

    Schweiz Nokia Global Vollzeit CHF 120'000 - CHF 180'000 pro Jahr

    DescriptionAs an Enterprise IP Pre-Sales & Business Development Engineer at Nokia, you will play a crucial role in driving our IP solutions into the enterprise market in Switzerland. You'll work closely with account managers and customers to uncover new sales opportunities, leveraging your expertise in data center and networking technologies. Collaborating...

  • Principal AI Engineer

    Vor 2 Tagen

    Schweiz Sherpany by Datasite Vollzeit

    Sherpany by Datasite is the leading Swiss meeting management solution, designed to meet the unique needs of the board, board committee, and executive meetings. Our solution streamlines the entire meeting process to make meetings more productive and thus enhancing company performance. Our customers include well-known medium to large companies in all...

  • Senior Software Engineer

    vor 2 Wochen

    Schweiz Digital Asset Vollzeit CHF 120'000 - CHF 180'000 pro Jahr

    DescriptionAbout Digital Asset & the Canton NetworkDigital Asset builds the technologies that are reshaping the foundations of financial markets. Our mission is to create the world's most trusted, privacy-enabled, and interoperable digital infrastructure for global finance.At the heart of this mission is the Canton Network - the blockchain purpose-built for...