Senior Data Analyst

Ruby Labs is a tech company with a portfolio of consumer products in health, education, and entertainment (100M+ annual users). 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.

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.

• Experience building basic ETL/ELT pipelines (scheduling, incremental loads, validation, monitoring).

• Git workflow (PRs, code review, versioning of SQL/data logic).

• Strong experience building dashboards and visualizations (BI tools or internal dashboards) with a focus on business clarity and metric correctness.

• Ability to communicate findings clearly to both technical and non-technical stakeholders.

• Fluent English.

Nice to Have:

• Tinybird experience (pipes, endpoints, materializations, performance tuning).

• JavaScript (dashboard integrations, or data apps).

• Python (for analysis/automation), dbt, Airflow(or other orchestration).

• Experience in risk/fraud analytics.

• Experience with experimentation A/B tests.

What We Offer:

• Fully remote work (within ±4h of CET).

• Unlimited PTO + paid national holidays.

• Company-provided MacBook.

• Flexible Independent Contractor agreement with tax advantages.