Trino Power User / Analyst 100%

Architect and Optimize High-Performance Distributed Data Systems

Join a team dedicated to designing, deploying, and operating robust Trino clusters within on-prem Kubernetes environments. This role focuses on configuring and maintaining Trino catalogs and connectors for heterogeneous data sources, including Hive, Iceberg, Kafka, and object storage. You will be responsible for optimizing query execution performance through the tuning of memory, CPU, spill, and partitioning, while implementing workload management using resource groups, query prioritization, and concurrency limits.

Your primary objective is to ensure the high availability, scalability, and fault tolerance of the Trino clusters. This involves monitoring cluster performance, query latency, and system health using observability tools, as well as troubleshooting system-level issues, query failures, and resource contention. You will collaborate with Data Engineers and Analysts to define best practices for efficient data access and contribute to architecture decisions around data lakehouses, federated query, and distributed analytics.

Key Responsibilities

• Design, deploy, and operate Trino clusters on on-prem Kubernetes
• Configure and maintain Trino catalogs and connectors for Hive, Iceberg, Kafka, and object storage
• Optimize query execution performance through tuning of memory, CPU, spill, and partitioning
• Implement workload management using resource groups, query prioritization, and concurrency limits
• Ensure high availability, scalability, and fault tolerance of the Trino clusters
• Monitor cluster performance, query latency, and system health using observability tools
• Troubleshoot system-level issues, query failures, and resource contention
• Collaborate with Data Engineers and Analysts to define best practices for efficient data access
• Contribute to architecture decisions around data lakehouses, federated query, and distributed analytics

Required Experience

• 5+ years of experience in distributed data systems, data platforms, or big data infrastructure
• Hands-on experience with Trino (or Presto) cluster deployment and operations
• Experience with Kubernetes, containerization, or VM-based distributed systems
• Experience integrating data sources such as Hive Metastore, Iceberg, and Kafka
• Proven experience in performance tuning and distributed query optimization
• Experience with monitoring and observability tools (Prometheus, Grafana, Dynatrace)
• Familiarity with security standards and access control mechanisms (LDAP, Kerberos, RBAC)
• Experience working in Agile environments with cross-functional teams
• Experience in financial services or regulated environments is a plus

Technical Skills

• Strong understanding of Trino architecture (coordinator/worker, execution model, query planning, resource groups)
• Expertise in performance tuning (joins, partition pruning, predicate pushdown, resource usage)
• Knowledge of modern data architectures (data lakes, lakehouses, data mesh)
• Hands-on experience with open table formats Iceberg
• Experience in infrastructure and platform engineering (Kubernetes, Linux, networking)
• Familiarity with Java/JVM-based systems
• Experience with monitoring, alerting, and troubleshooting distributed systems
• Basic scripting/programming skills (Python, Bash) for automation
• Strong problem-solving and system-level debugging skills

Work Arrangement

This position is based in Zurich and requires a minimum of 3-4 days per week working from the office. Travel is generally not required, except on an exceptional basis if client demands arise. The start date is immediate.