Ruby Labs

Senior Data Analyst

Ruby Labs

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇨🇿 Czech

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLSQL

About the role

  • 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).

Requirements

  • 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.
Benefits
  • Remote Work Environment: Embrace the freedom to work from anywhere, anytime, promoting a healthy work-life balance.
  • Unlimited PTO: Enjoy unlimited paid time off to recharge and prioritize your well-being, without counting days.
  • Paid National Holidays: Celebrate and relax on national holidays with paid time off to unwind and recharge.
  • Company-provided MacBook: Experience seamless productivity with top-notch Apple MacBooks provided to all employees who need them.
  • Flexible Independent Contractor Agreement: Unlock the benefits of flexibility, autonomy, and entrepreneurial opportunities. Benefit from tax advantages, networking opportunities, reduced employment obligations, and the freedom to work from anywhere.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLClickHouseETLELTdata modelingquery tuningdata pipelinesdashboardsvisualizationsroot-cause analysis
Soft skills
communicationcollaborationproblem-solvinganalytical thinkingattention to detail