Job Closed
This listing is no longer active.
The Command Center™ for B2B Revenue Teams.
Staff Engineer, Clickhouse
Location
California
Posted
146 days ago
Salary
$200K - $300K / year
Seniority
Lead
Job Description
Staff Engineer, Clickhouse
HockeyStack
• Manage and scale ClickHouse clusters (replication, sharding, distributed tables) to 100s of TBs. • Maintain data consistency across replicas and shards. • Profile and optimize heavy ETL/ELT queries and table engines. • Tune key configs (max_threads, max_memory_usage, merge settings, I/O schedulers). • Benchmark cluster performance (ingest throughput, query latency, merge rate). • Proactively work with engineers to optimize schema and query patterns. • Improve observability stack on DataDog. • Set up alerting on query performance, merges, replicas, and disk usage. • Own backup and restore processes (to secondary cluster and S3). • Plan and execute upgrades with zero or minimal downtime. • Test and document disaster recovery scenarios. • Own security within ClickHouse, including access control, encryption where applicable, and adherence to internal and regulatory data protection requirements. • Resolve production issues and figure ways to prevent them. • Participate in the Architecture Review process to ensure major changes to the product portfolio have data flow and ClickHouse considerations represented at the very start.
Job Requirements
- 5+ years hands-on ClickHouse experience and 8+ years working as a DBA with distributed OLAP databases
- Have dealt with data volume at scale (i.e. 100s of TBs) & understand the challenges this brings
- Strong systems background with deep understanding of IO performance and network protocols, specifically for high-volume high-throughput analytical workloads (reads and writes!)
- Proficiency in writing and optimizing complex SQL queries
- Experience with Linux server administration and storage (i.e. RAID)
- Experience with monitoring/alerting tools is a strong plus, particularly for database metrics and observability
- Familiarity with data infrastructure, reporting systems, or analytics-heavy SaaS products
Benefits
- Equal Opportunity Employer
- Commitment to fostering an inclusive environment
Related Guides
Related Job Pages
More Full-stack Engineer Jobs
Senior Full Stack Developer
ShinestyHeadquartered in Boulder, Colorado, Shinesty was founded in 2014 to deliver "the most outlandish collection of clothing the world has ever seen." The company's
• Keep the current headless site stable and improving (next ~3–4 months) - Own day-to-day stability: triage issues, fix bugs, ship improvements, and keep releases moving - Improve performance and reliability across funnel pages (Collection → PDP → Cart → Checkout) - Support business-critical updates (launches, promos, pricing changes) without breaking conversion - Execute a mix of quick wins and targeted refactors to reduce fragility and regressions - Maintain analytics and tracking integrity so marketing, attribution, and testing don’t get corrupted - Operate with a clear constraint: we’re not looking for a big rewrite right now—we’re migrating, so we need pragmatic improvements that keep the business running • Provide technical input during the agency rebuild (collaborative, not meeting-heavy) - Instead, you’ll provide focused technical partnership to keep the rebuild accurate, maintainable, and launch-ready: - Provide technical guidance early (constraints, feasibility, integration requirements, edge cases) - Review key deliverables that benefit from engineering eyes (technical specs, implementation approach, critical PRs) - Join the working sessions where engineering input is genuinely needed (not every status meeting) - Answer agency questions quickly and clearly so they don’t guess—or build the wrong thing • Post-migration: Shopify theme execution + experimentation - Work within Shopify theme constraints intelligently (speed, maintainability, extensibility) - Build and iterate on features that support an ever-evolving ecommerce business - Enable experimentation: implement tests, iterate quickly, and ship improvements that move conversion and AOV - Maintain and extend apps/integrations cleanly (no duct-taping the stack) - Build lightweight documentation and internal runbooks so we can own what we ship • Frontend Development - Build and maintain React/Next.js experiences across the ecommerce funnel - Improve UX in ways that directly impact conversion, AOV, and subscription attach - Ensure performance and accessibility standards are met (Core Web Vitals matter) • Backend / Platform Development - Build and maintain APIs, serverless functions, and integration logic (TypeScript-heavy) - Debug issues across services: Shopify, internal tools, and third-party partners - Improve observability: logging, monitoring, error reporting, and alerting where needed • API Integration & Ecommerce Tooling - Integrate Shinesty systems with third-party tools (subscription, search, analytics, marketing partners) - Ensure reliable data flow and maintainable implementation patterns • Performance + Conversion Rate Optimization - Identify and resolve bottlenecks across frontend and backend systems - Implement smart, well-scoped A/B tests and iterate based on results - Partner with the Digital Product Manager to translate hypotheses into shippable changes**
Senior Protection and Control Engineer
Switzerland Global EnterpriseWe support Swiss SMEs in their international business and help innovative foreign companies to establish in Switzerland.
• Ensure high quality design of protection schemes for all kinds of T&D substations, Data Centers, Industrial, BESS applications including one-lines, three-lines, AC / DC schematics, and relay settings. • Review, propose optimization and seal (P.E. stamp) protection and control designs prepared by himself or other team members. • Lead and coordinate all P&C technical aspects of AC power substation projects, especially ensuring successful and safe operation of power system equipment. • Review power system load flow studies, fault studies, relay setting coordination, and transient studies performed by other agencies. • Develop or Review outage, cut-over, and testing procedures. • Interface with internal and external team members such as Protection and Control Engineers, Lead engineers, Project Engineers, Electrical Designers, Civil Engineers, Physical Designers, Draftsmen, Project managers, Sourcing, and support organization. • Interface with customer technical representatives. • Lead or support factory acceptance testing and site testing & commissioning. • Work on development of proposals including writing and/or reviewing technical specifications, estimating design man-hours and materials, supporting sourcing for vendor quotations, and developing clarifications and exceptions as well as performing technical validation.
Staff Software Engineer
Switzerland Global EnterpriseWe support Swiss SMEs in their international business and help innovative foreign companies to establish in Switzerland.
• responsible for providing technical leadership and defining, developing, and evolving software in a fast paced and agile development environment • Capture system level requirements by brainstorming with Architects, Data Scientists, Businesses & Product Managers • Identify the scope of the work, provide initial estimate and justify the estimate with facts • Demonstrate the understanding of Agile software development lifecycle • Engage in technical discussions; participate in technical designs and present technical ideas • Execute in a fast pace delivery mode and focus in delivering tasks to meet the product release goal • Maintain code quality through best practices, unit testing and code quality automation • Seek and provide feedback on design and development • Understand whole APM product, its modules and the interrelationship between them • Help in designing interfaces and information exchange between modules • Articulate the need for scalability and improve quality through testing • Drive design reviews, define interfaces between code modules • Provide guidance to a team of 5 to 7 developers with either planning and execution and/or design architecture using agile methodologies such as SCRUM • Work with Product Line Leaders (PLLs) to understand product requirements & vision
• Code, test, debug, document, and ship and maintain software applications using established coding standards and methodologies • Designing and building out API’s that will be consumed by the UI to surface application data. • Partner with product management to drive agile delivery of both existing and new products based on project requirements, UX design, and industry best practices • Ensure new software meets quality standards by writing unit and end-to-end automated tests • Work with product, data, and other stakeholders to analyze usage and product metrics to inform key strategic decisions • Troubleshoot, debug, resolve product issues as they arise • Work cross functionally to resolve complex partner problems • Ensure platform and services meet SLA requirements; on call rotation for production issues, along with the rest of engineering



