O pozici
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/
Co budeš dělat
- 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).
Koho hledáme
- 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.
Benefity
- 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. Read more about it here: https://docs.google.com/document/d/1nkrN76JlZkbKj9WSOhlT1_mni_CZeDkHdwfIjPXVwvk/preview?tab=t.0#heading=h.ndsdl4wapxtt
