Senior Data Analyst (Subscription Billing)

TL;DR

Senior Data Analyst (Subscription Billing): Building and optimizing data pipelines and datasets for subscription billing and payments analytics, with an accent on defining core billing metrics and delivering actionable dashboards. Focus on investigating anomalies, ensuring data quality, and partnering with engineering on data instrumentation.

Location: Remote: Must be located within approximately ± 4 hours of CET (Central European Time)

Company

Ruby Labs is a leading tech company that creates and operates innovative consumer products across health, education, and entertainment industries.

What you will do

• Build and maintain data pipelines in Tinybird and ClickHouse to power dashboards and self-serve analytics.
• Optimize ClickHouse queries for performance and 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, perform root-cause analysis, and propose actions.
• Partner with engineering on data instrumentation and event tracking.

Requirements

• Strong subscription billing experience (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.

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.

Culture & Benefits

• Remote work environment with the freedom to work from anywhere.
• Unlimited paid time off (PTO) and paid national holidays.
• Company-provided MacBook.
• Flexible Independent Contractor Agreement offering autonomy and entrepreneurial opportunities.
• Opportunity for personal and professional growth within a fast-growing team.

Hiring process

• Application review (typically 3 to 5 days).
• Recruiter Screening (40 minutes).
• Technical Interview (90 minutes).