Senior Data Analyst

Overview

Ruby Labs is a leading tech company that creates and operates innovative consumer products. We offer opportunities across the health, education, and entertainment industries. 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.
• 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.

Location

Ruby Labs operates within the CET (Central European Time) zone. Applicants from any country are welcome to apply for the position as long as they are located within approximately ± 4 hours of CET. This ensures optimal collaboration and communication during working hours.

Benefits

• Remote Work Environment: Work from anywhere, anytime, promoting a healthy work‑life balance.
• Unlimited PTO: Unlimited paid time off to recharge.
• Paid National Holidays: Paid time off on national holidays.
• Company‑provided MacBook: Apple MacBook provided to employees who need one.
• Flexible Independent Contractor Agreement: Benefits of flexibility, autonomy, and entrepreneurial opportunities.
  • Read more about it here: [Interview Process]

Interview Process

After submitting your application, we conduct a thorough review which typically takes 3 to 5 days, but may occasionally take longer due to the volume of applications received. If we see a potential fit, we proceed with the following steps:

1. Recruiter Screening (40 minutes)
2. Technical Interview (90 minutes)

Life at Ruby Labs

At Ruby Labs, we move fast, aim high, and expect the same from our team. We’re not here to play small—we’re here to build, grow, and win. This is a place for individuals who thrive under pressure, embrace challenges, and see opportunity in every obstacle. If you’re hungry to achieve, motivated by impact, and want to grow at the speed of your own ambition, Ruby Labs offers the platform to make it happen. Here, effort is matched with reward. We recognize those who go all in and deliver results, and we create space for people who want more—more responsibility, more growth, and more success.

Job Details

• Job code: EX-594D8835
• Job type: Full-time
• Location: South Africa
• Company: Ruby Labs

#J-18808-Ljbffr