ruby-labs - Senior Data Analyst
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
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. • Tinybird experience (pipes, endpoints, materializations, performance tuning). • JavaScript (dashboard integrations, or data apps). • Python (for analysis/automation), dbt, Airflow(or other orchestration). • Experience with experimentation/A/B tests. • Ruby Labs operates within the CET (Central European Time) zone. Applicants from any country are welcome to apply for the position as long as they are located within approximately ± 4 hours of CET. This ensures optimal collaboration and communication during working hours.
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).
Benefits
• Discover the perks of being part of our vibrant team! We offer: • 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/1tzxGX4Uu7Ts_HCLFXESKLnKaaBfVCPf1f9AYZPrkjJM/preview?tab=t.0 • Be part of our fast-growing team and seize this excellent opportunity for personal and professional growth!
No credit card. Takes 10 seconds.