Remote Senior Data Performance Engineer

OpenKrill; United States; Remote; USD 140,000 - 210,000; Full time

Benefits offered by this job

Competitive pay with equity options

Stellar healthcare plan (Medical, Demo

Unlimited PTO

401(k) with 4% matching

Fully remote work and flexible hours

Work-from-home setup budget

Biannual in-person summits

Job summary

Turquoise Health is seeking a highly experienced Data Performance Engineer to optimize production data systems and analytical workloads across the product stack. You will investigate slow queries, benchmark workflows, and push production improvements from the data layer to the UI.

You’ll work with ClickHouse Cloud, collaborate with product, frontend, and backend engineers, and shape scalable, cost-efficient data architecture. This is a fully remote role within the United States.

Qualifications

• 5+ years building and optimizing production data systems, data-intensive applications, or analytical products
• Advanced SQL and strong Python (or another general-purpose language)
• Hands-on experience optimizing analytical workloads in column-oriented databases or data warehouses
• A hypothesis-driven approach to performance work: you use query plans, profiling, benchmarks, and production telemetry to define the problem, set a baseline, test alternatives, and quantify the result in production
• The ability to reason across system boundaries (databases, APIs, backend services, client request patterns, product interactions) and the product judgment to know when changing the experience beats changing the data system

Responsibilities

• Own performance investigations across the product and data stack, taking a slow query or poor user experience to a measured root cause and a production fix.
• Track latency, throughput, concurrency, and infrastructure cost, with a focus on datastore efficiency (we run on ClickHouse Cloud).
• Build representative benchmarks for the filter, dataset, and workflow combinations that matter most.
• Evaluate the performance impact of upstream dataset changes before they reach production.
• Assess future product requests and recommend technical or product approaches that balance functionality, responsiveness, scalability, and cost.
• Design and evaluate data architecture changes, such as restructuring tables, precomputing results, and changing indexes.
• Partner with Product, frontend, and backend engineers to adapt product behavior to the data, using techniques like request batching, debouncing, caching, and pagination.
• Prototype competing solutions, communicate their tradeoffs clearly, and validate the chosen approach in production.
• Improve performance instrumentation, monitoring, and regression detection across data-powered product experiences.
• Establish reusable patterns as the Data Product platform becomes a supporting layer for more products and teams

Skills

Advanced SQL

Python

Data performance

Tools

ClickHouse Cloud

Datastore optimization

Job description

Turquoise Health is seeking a highly experienced Data Performance Engineer to optimize production data systems and analytical workloads across the product stack. You will investigate slow queries, benchmark workflows, and push production improvements from the data layer to the UI.

You’ll work with ClickHouse Cloud, collaborate with product, frontend, and backend engineers, and shape scalable, cost-efficient data architecture. This is a fully remote role within the United States.