Senior Data Analyst

About us

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/

About the role

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.

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

Qualifications

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.

Location

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.

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/1nkrN76JlZkbKj9WSOhlT1_mni_CZeDkHdwfIjPXVwvk/preview?tab=t.0#heading=h.ndsdl4wapxtt

Be part of our fast-growing team and seize this excellent opportunity for personal and professional growth!

Interview Process

After submitting your application, we conduct a thorough review which typically takes 3 to 5 days, but may occasionally take longer due to the volume of applications received. If we see a potential fit, we proceed with the following steps:

Recruiter Screening (40 minutes)
Technical Interview (90 minutes)

Life at Ruby Labs

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

Details

Location

Ukraine

About us

About the role

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

Qualifications

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.

Location

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/1nkrN76JlZkbKj9WSOhlT1_mni_CZeDkHdwfIjPXVwvk/preview?tab=t.0#heading=h.ndsdl4wapxtt

Be part of our fast-growing team and seize this excellent opportunity for personal and professional growth!

Interview Process

Recruiter Screening (40 minutes)
Technical Interview (90 minutes)

Life at Ruby Labs

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