Senior Data Analyst

TL;DR

Senior Data Analyst: Building and optimizing datasets and queries for subscription billing and payments with an accent on defining billing metrics and delivering actionable dashboards. Focus on investigating anomalies, performing root-cause analysis, and partnering with engineering on data instrumentation.

Location: Remote globally, within approximately ± 4 hours of CET time zone.

Company

Ruby Labs is a leading tech company creating and operating innovative consumer products across health, education, and entertainment industries.

What you will do

• Build and maintain data pipelines in Tinybird and ClickHouse.
• Optimize ClickHouse queries for performance and correctness.
• Design and maintain core billing metrics (gross/net revenue, churn, LTV, MRR/ARR, etc.).
• Create and iterate on dashboards and visualizations for various stakeholders.
• Investigate data anomalies, perform root-cause analysis, and propose actions.
• Partner with engineering on data instrumentation and event tracking.

Requirements

• Strong subscription billing experience is mandatory (payments, renewals, refunds, disputes/chargebacks).
• Advanced SQL skills (complex joins, window functions, performance-aware querying).
• Production experience with ClickHouse (query tuning, data modeling).
• Experience building ETL/ELT pipelines and Git workflow.
• Strong experience building dashboards/visualizations with business clarity.
• Ability to communicate findings clearly to technical and non-technical stakeholders.

Nice to have

• Tinybird experience (pipes, endpoints, materializations, performance tuning).
• JavaScript for dashboard integrations or data apps.
• Python for analysis/automation, dbt, or Airflow.
• Experience in risk/fraud analytics.
• Experience with experimentation/A/B tests.

Culture & Benefits

• Remote Work Environment with freedom to work from anywhere.
• Unlimited Paid Time Off.
• Paid National Holidays.
• Company-provided MacBook.
• Flexible Independent Contractor Agreement with benefits like autonomy and tax advantages.

Hiring process

• Recruiter Screening (40 minutes).
• Technical Interview (90 minutes).