TL;DR

Senior Data Analyst (ClickHouse, Tinybird): Owning analytics for billing and payments by building and optimizing datasets and queries, defining billing metrics, and delivering dashboards with an accent on data pipeline maintenance and query optimization. Focus on designing core billing metrics, investigating anomalies, and partnering with engineering on data instrumentation.

Location: Remote (CET ± 4 hours)

Company

%hirify_global% is a leading tech company that creates and operates innovative consumer products across health, education, and entertainment industries.

What you will do

Build and maintain data pipelines using Tinybird and ClickHouse to power dashboards and self-serve analytics.
Optimize ClickHouse queries for performance and correctness.
Design and maintain core billing metrics, including gross/net revenue, refunds, churn, LTV, MRR/ARR, and cohort retention.
Create and iterate on dashboards and visualizations for internal stakeholders (Billing/Finance/Product/Support/Risk).
Investigate data anomalies and quality issues, perform root-cause analysis, and propose actions.
Partner with engineering on data instrumentation and event tracking to ensure high-quality billing data.

Requirements

Strong subscription billing experience is mandatory (payments, renewals, refunds, disputes/chargebacks).
Advanced SQL skills, including complex joins, window functions, and performance-aware query writing.
Production experience with ClickHouse, focusing on query tuning and data modeling for analytics workloads.
Experience building basic ETL/ELT pipelines (scheduling, incremental loads, validation, monitoring).
Proficiency with Git workflow (PRs, code review, versioning of SQL/data logic).
Strong experience building dashboards and visualizations with a focus on business clarity and metric correctness.
Ability to communicate findings clearly to both technical and non-technical stakeholders.
Work from within CET ± 4 hours timezone is required.

Nice to have

Tinybird experience (pipes, endpoints, materializations, performance tuning).
Proficiency in JavaScript (dashboard integrations or data apps) or Python (for analysis/automation).
Experience with dbt or Airflow (or other orchestration tools).
Experience in risk/fraud analytics or experimentation/A/B testing.

Culture & Benefits

Embrace a remote work environment that promotes a healthy work-life balance.
Enjoy unlimited paid time off (PTO) and paid national holidays.
Receive a company-provided MacBook for seamless productivity.
Benefit from a Flexible Independent Contractor Agreement, offering autonomy and tax advantages.
Seize opportunities for personal and professional growth within a fast-growing team.

Hiring process

Application review, typically taking 3 to 5 days.
Recruiter Screening (40 minutes).
Technical Interview (90 minutes).