Senior Data Analyst

We're looking for a Senior or Lead Data Analyst with deep experience in subscription billing analytics and strong technical skills in ClickHouse (and ideally Tinybird). You will own analytics for billing and payments: build and optimize datasets and queries, define billing metrics, and deliver dashboards that product, finance, and operations teams rely on daily., * 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).

Do you have experience in SQL?, * 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 in risk/fraud analytics.
• Experience with experimentation/A/B tests.

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!

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, At Ruby Labs, we move fast, aim high, and expect the same from our team. We're not here to play small-we're here to build, grow, and win. That means we look for people who are ambitious, driven, and ready to give their best every single day. This is a place for individuals who thrive under pressure, embrace challenges, and see opportunity in every obstacle. If you're hungry to achieve, motivated by impact, and want to grow at the speed of your own ambition, Ruby Labs offers the platform to make it happen. Here, effort is matched with reward. We recognize those who go all in and deliver results, and we create space for people who want more-more responsibility, more growth, and more success. #LI-Remote   You must create an Indeed account before continuing to the company website to apply