Remote Python Analytics Engineer - Async ClickHouse

BETBY

United States

Remote

USD 120,000 - 170,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
Paid sick leave
Vacation days
Learning and development support
Language learning support
Modern hardware
International team
Team events
Welfare program
Gifts for milestones

Job summary

Betby is seeking a Python developer to join the Backoffice Reports team, owning the analytics backend used daily by risk management, trading and accounts. The stack is async Python on ClickHouse, with typed Pydantic models, Jinja-templated SQL, RPC via RabbitMQ, and REST/GraphQL endpoints.

You will develop, optimize and test reports, implement access controls, and collaborate with analytics/data teams in a globally remote environment.

Qualifications

  • 3+ years of commercial Python development.
  • Confident asyncio: async/await, concurrency, async I/O clients.
  • Pydantic v2 (models, validation, serialization) and type hints.
  • Strong SQL - this is the key requirement: Complex SELECTs with JOINs, subqueries and CTEs (WITH).
  • GROUP BY on several dimensions, conditional aggregation (SUM / COUNT with conditions).
  • Window functions and understanding of analytical query performance.

Responsibilities

  • Develop and maintain reports in the Backoffice: filters, grouping, sorting, pagination, totals, drill-down links between reports, CSV exports and chart data.
  • Write and optimize analytical ClickHouse SQL: aggregations over hundreds of millions of bets, multi-level grouping, period breakdowns (day / week / month / year).
  • Describe reports as typed contracts (Pydantic models for filters and output) in our shared reports library.
  • Work with the RPC layer between the backoffice API and the ClickHouse reporter service (RabbitMQ).
  • Implement access control for reports: scopes and roles, operator / brand data isolation, hiding fields depending on user role.
  • Investigate slow reports: read query plans, PREWHERE, pre-aggregation, and collaborate with the analytics/DataFlow team on table design.
  • Cover reports and SQL with tests, keep data correct across backoffice applications.
  • Take part in code review and evolve the reports framework (new report types, presets, custom segments).

Skills

Python
Asyncio
Pydantic v2
SQL
REST APIs
Docker
RabbitMQ
Kafka
ClickHouse
Git

Tools

ClickHouse
GraphQL
FastAPI
RabbitMQ
Kafka
Docker
Prometheus
Grafana
ELK
MongoDB
Jinja2

Job description

Betby is seeking a Python developer to join the Backoffice Reports team, owning the analytics backend used daily by risk management, trading and accounts. The stack is async Python on ClickHouse, with typed Pydantic models, Jinja-templated SQL, RPC via RabbitMQ, and REST/GraphQL endpoints.

You will develop, optimize and test reports, implement access controls, and collaborate with analytics/data teams in a globally remote environment.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Middle Python Developer with SQL Skills
Middle Python Developer with SQL Skills

BETBY • United States

Remote
USD 120,000 - 170,000
Health insurance
Paid sick leave
Vacation days
+7
Senior Backend AI/ML Engineer - Remote + Equity
Senior Backend AI/ML Engineer - Remote + Equity

Aimlroles • San Francisco (CA)

Remote
USD 180,000 - 260,000
Flexible work environment
Healthcare
Equity in the company
+3
Senior Remote ML Engineer for Production AI & Data Systems
Senior Remote ML Engineer for Production AI & Data Systems

ClickHouse • Phoenix (AZ)

Remote
USD 150,000 - 238,000
Flexible work
Healthcare
Equity
+3
Senior Backend AI/ML Engineer - Remote
Senior Backend AI/ML Engineer - Remote

ClickHouse • San Francisco (CA)

Remote
USD 147,000 - 238,000
Flexible work environment
Healthcare contributions
Equity in company
+3
Senior Backend Engineer - Remote, Equity
Senior Backend Engineer - Remote, Equity

ClickHouse • Washington

Remote
USD 180,000 - 260,000
Flexible work environment
Healthcare
Stock options
+3
Senior Software Engineer, AI & ML Ecosystem (Fully Remote)
Senior Software Engineer, AI & ML Ecosystem (Fully Remote)

ClickHouse • United States

Remote
USD 150,000 - 230,000
Healthcare contributions
Equity
Home office setup
+1
Senior Data Engineer (Fully Remote)
Senior Data Engineer (Fully Remote)

ClickHouse • United States

Remote
USD 140,000 - 180,000
Senior Data Engineer - Real-Time Pipelines & ClickHouse
Senior Data Engineer - Real-Time Pipelines & ClickHouse

ClickHouse • United States

Remote
USD 140,000 - 180,000
Senior AI/ML Engineer — Real-Time Analytics, Remote & Equity
Senior AI/ML Engineer — Real-Time Analytics, Remote & Equity

ClickHouse • Dallas (TX)

Remote
USD 150,000 - 238,000
Flexible work environment
Healthcare - Employer contributions
Equity in the company
+3
Lead Data Engineer
Lead Data Engineer

Zexter • United States

Remote
USD 140,000 - 210,000
Fully remote work
Competitive salary