Senior Data AnalystVerified as a real position

Who we’re looking for

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

What you’ll do

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

About the position

Ruby Labs is a leading tech company that creates and operates innovative consumer products. We offer a diverse range of opportunities across the health, education, and entertainment industries. Our innovative teams are driving the future of consumer-led products, and we're always looking for passionate individuals to join us. Learn more about our story at: https://rubylabs.com/about-us/

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.