Trino Power User / Analyst

Trino Power User / Analyst

Location: Basel, Switzerland

Company: Swiss Himmel GmbH

Employment Type: Full-time

Experience: 5+ years

Domain: Data Platforms / Distributed Data Systems

About Swiss Himmel GmbH

Swiss Himmel GmbH is a Basel-based technology and consulting firm partnering with leading enterprises to modernize complex data, technology, and infrastructure platforms. We combine strong technical expertise with practical delivery experience to support data engineering, cloud, platform, and digital transformation initiatives.

About the Role

Swiss Himmel GmbH is looking for an experienced Trino Power User / Analyst to support the design, deployment, operation, and optimization of distributed data access platforms.

The ideal candidate will have strong hands-on experience with Trino or Presto, Kubernetes-based deployments, heterogeneous data sources, query performance optimization, and modern data architectures. You will work closely with Data Engineers and Analysts to improve data access, platform performance, and distributed analytics capabilities.

Key Responsibilities

Trino Platform Engineering

Design, deploy, and operate Trino clusters on on-premises Kubernetes environments.

Configure and maintain Trino catalogs and connectors for heterogeneous data sources.

Integrate data sources including Hive, Iceberg, Kafka, and object storage.

Manage Trino cluster configuration, execution models, resource groups, and query planning.

Ensure high availability, scalability, and fault tolerance of Trino clusters.

Performance & Workload Management

Optimize query execution performance through memory, CPU, spill, and partitioning configuration.

Tune distributed queries using techniques such as joins, partition pruning, and predicate pushdown.

Implement workload management using resource groups, query prioritization, and concurrency limits.

Monitor query latency, cluster performance, resource usage, and overall system health.

Troubleshoot query failures, resource contention, and system-level issues.

Data Architecture & Integration

Support data access across modern data architectures including data lakes, lakehouses, and data mesh environments.

Work with open table formats, particularly Apache Iceberg.

Contribute to architecture decisions around data lakes, federated queries, and distributed analytics.

Collaborate with Data Engineers and Analysts to establish best practices for efficient data access.

Monitoring, Security & Operations

Implement and use observability solutions such as Prometheus, Grafana, and Dynatrace.

Monitor, alert, and troubleshoot distributed data platforms.

Support security and access control mechanisms including LDAP, Kerberos, and RBAC.

Identify and resolve platform-level performance and availability issues.

Contribute to platform reliability and operational improvements.

Required Qualifications & Experience

5+ years of experience working with distributed data systems, data platforms, or big data infrastructure.

Hands-on experience with Trino or Presto cluster deployment and operations.

Strong understanding of Trino architecture, including:

Coordinator and worker architecture

Execution model

Query planning

Resource groups

Experience with Kubernetes, containerization, or VM-based distributed systems.

Experience integrating data sources such as Hive, Metastore, Iceberg, and Kafka.

Strong experience in distributed query optimization and performance tuning.

Hands-on experience with Apache Iceberg and open table formats.

Experience with Kubernetes, Linux, and networking.

Experience with monitoring, alerting, and troubleshooting distributed systems.

Basic scripting/programming experience using Python and/or Bash.

Strong system-level debugging and problem-solving skills.

Preferred Qualifications

Experience working in financial services or other regulated environments.

Familiarity with Java/JVM-based systems.

Experience with LDAP, Kerberos, and enterprise RBAC.

Experience with Prometheus, Grafana, or Dynatrace.

Experience working with data lake, lakehouse, or data mesh architectures.

Experience contributing to federated query and distributed analytics solutions.

Key Competencies

Trino / Presto expertise

Distributed data platforms

Query performance optimization

Kubernetes and Linux

Apache Iceberg

Hive and Kafka integration

Data lake and lakehouse architectures

Platform monitoring and troubleshooting

Resource and workload management

Python / Bash automation

Strong analytical and problem-solving skills

Cross-functional collaboration

Why Join Swiss Himmel GmbH?

Work on modern distributed data platforms and enterprise data environments.

Gain exposure to Trino, Kubernetes, Iceberg, Kafka, and modern data architectures.

Work with experienced Data Engineering and Analytics teams.

Contribute to large-scale data platform and transformation initiatives.

Collaborative and professional work environment.

Long-term growth opportunities within Swiss Himmel GmbH.

Competitive Swiss compensation and benefits.