Senior Data Analyst
External
Ruby-labs · UkraineFull-timeRemote3mo ago
AirflowData ModelingdbtETLGitJavaScript
Prepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
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/ 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.
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).
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 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.Be part of our fast-growing team and seize this excellent opportunity for personal and professional growth!Interview ProcessAfter 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 LabsAt 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,Health insurancePaid time offRemote work optionsFlexible schedule
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at ruby-labs? Share your experience