Senior Data Analyst

Posted 102ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Data Analyst at Ruby Labs optimizing billing data and analytics. Building dashboards and supporting finance and operations teams with critical insights.

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

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

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.