Middle Python Developer with SQL Skills

Brak informacji o wynagrodzeniu

MidZdalnie·WarszawaFull-time

#474108·Dodano 2 dni temu·1

Źródło: BETBY

Aplikuj teraz

Tech Stack / Keywords

Python SQLClickHousePydanticRabbitMQasyncioREST API GraphQL Docker pytest

Podsumowanie oferty

Join the Backoffice Reports team to develop the backend for analytics reports used by operations teams. The role focuses on async Python, ClickHouse analytics and report APIs using REST and GraphQL.

Wymagania

3+ years of commercial development in Python.
Confident with asyncio, async/await, concurrency and async I/O clients.
Experience with Pydantic v2 models, validation, serialization and type hints.
Strong SQL skills, including complex SELECT statements with JOINs, subqueries and CTEs (WITH); multi-dimensional GROUP BY and conditional aggregation (SUM / COUNT); window functions; and understanding analytical query scalability and performance.
Experience with a columnar / OLAP database; ClickHouse preferred. Vertica, Exasol, BigQuery, Redshift and Snowflake are a plus.
Experience building REST APIs in an async framework such as Sanic, aiohttp, FastAPI or Starlette.
Understanding of message brokers (RabbitMQ and/or Kafka) and RPC over queues.
Experience with Git, Docker and writing tests with pytest.
Ability to understand business metrics such as GGR, stake, payout and margin, and turn them into correct queries.

Nice to have:

Hands-on ClickHouse experience with MergeTree family engines, FINAL, PREWHERE, dictionaries (dictGet), -If combinators, ARRAY JOIN, WITH TOTALS, quantiles and uniq / uniqExact.
Jinja2 or other SQL templating / query builders.
Pandas for data post-processing and exports.
MongoDB.
GraphQL.
Domain knowledge of sports betting, iGaming, fintech or ad-tech analytics.
Prometheus / Grafana / ELK for monitoring and troubleshooting.
Monorepo tooling (Pants, Poetry, uv) and Nix.

Obowiązki

Develop and maintain Backoffice reports, including filters, grouping, sorting, pagination, totals, drill-down links, CSV exports and chart data.
Write and optimize analytical ClickHouse SQL for aggregations over hundreds of millions of bets, multi-level grouping and period breakdowns.
Define reports as typed contracts using Pydantic models for filters and output in the shared reports library.
Work with the RPC layer between the backoffice API and the ClickHouse reporter service using RabbitMQ.
Implement report access control using scopes and roles, operator and brand data isolation, and field visibility based on user role.
Investigate slow reports by reading query plans and choosing filters, PREWHERE and pre-aggregation; work with the analytics/DataFlow team on table design.
Test reports and SQL, and maintain data correctness across backoffice applications.
Participate in code review and help evolve the reports framework with new report types, presets and custom segments.

Benefity

Comprehensive health insurance coverage.
Up to 10 days of paid sick leave without a medical certificate.
20 days of paid vacation plus additional leave for important life events.
Learning and growth opportunities with support for professional development.
Language learning support for multilingual collaboration.
Modern hardware provided for work.
Corporate events and team activities.
Welfare support program for critical situations.
Gifts and support for major life milestones.

Ubezpieczenie

Płatne święta

Kursy językowe

Spotkania integracyjne

Inne informacje

Remote talent is supported across the globe.

BETBY

5 aktywnych ofert

Zobacz wszystkie oferty

Aplikuj teraz