Senior Data Analyst

ABOUT US

Ruby Labs is a leading tech company that creates and operates innovative consumer products. We offer a diverse range of opportunities across the health, education, and entertainment industries. Our innovative teams are driving the future of consumer-led products, and we're always looking for passionate individuals to join us. Learn more about our story at:

ABOUT THE ROLE

We’re looking for a Senior or Lead Data Analyst with deep experience in subscription billing analytics and strong technical skills in ClickHouse (and ideally Tinybird). You will own analytics for billing and payments: build and optimize datasets and queries, define billing metrics, and deliver dashboards that product, finance, and operations teams rely on daily.

KEY RESPONSIBILITIES

- Build and maintain data pipelines in Tinybird and ClickHouse to power dashboards and self-serve analytics.

- Optimize ClickHouse queries for performance, correctness.

- Design and maintain core billing metrics: gross/net revenue, refunds, chargeback rate, dispute rate, approval rate, churn, LTV, MRR/ARR, and cohort retention.

- Create and iterate on dashboards/visualizations for internal stakeholders (Billing/Finance/Product/Support/Risk).

- Investigate anomalies and data-quality issues (e.g., spikes in refunds, rising dispute rates, drops in approval rates), perform root-cause analysis, and propose actions.

- Partner with engineering on data instrumentation and event tracking to ensure high-quality billing data.

- Document logic (metric definitions, tables, pipeline behavior) and establish quality checks (tests/monitoring).

QUALIFICATIONS

- Strong subscription billing experience is mandatory (payments + renewals + refunds + disputes/chargebacks).

- Advanced SQL (complex joins, window functions, incremental logic, performance-aware query writing).

- Production experience with ClickHouse: query tuning and data modeling for analytics workloads.

- Ex...