Senior Backend Engineer – Distributed Reporting & Data Infrastructure

Location: Remote (Global) Team Size: ≈ 10 engineers Core Stack: Ruby on Rails (API-only), Sidekiq, MySQL, AWS (EC2, RDS, EFS), Highcharts.js (data consumers) About INDY INDY powers every operational layer of a movie theater—from ticket sales and concessions to scheduling, accounting, and real-time business intelligence. Our platform handles tens of millions of tickets a year across cinemas worldwide, yet we remain a nimble team where each engineer’s work is felt immediately in theaters on six continents. Why This Role Exists Our home-grown reporting platform is the analytical backbone of INDY. It decomposes incoming queries into thousands of parallel Sidekiq jobs (hourly → daily → weekly → monthly roll-ups) and serves the results back to cinema managers in seconds. As volume soars, we need a backend-focused engineer to: ● Own and harden this distributed reporting engine. ● Design data pipelines that can ingest years of transactional data and still answer ad-hoc questions quickly. ● You will partner with—but not be accountable for—front-end engineers who wire these APIs into Vue-based dashboards. What You’ll Do ● Architect & Scale ○ Profile, partition, and optimize multi-terabyte MySQL schemas. ○ Tune Sidekiq queues, worker pools, and EC2 autoscaling groups for bursty loads. ○ Refactor long-running jobs into idempotent, parallelizable units. ● Maintain Data Integrity & Observability ○ Implement validation, audit trails, and automated backfills. ○ Instrument metrics/alerting around throughput, latency, and cost. ● Expand Administrative Workflows ○ Expose clean GraphQL/REST contracts that power accounting tools for film bookings, revenue splits, and studio payouts. ○ Introduce domain-specific abstractions (DSLs, helpers) so other engineers can add new report types rapidly. ● Collaborate Across Functions ○ Work with infra engineers on Terraform-managed AWS resources. ○ Pair with front-end devs to ensure APIs are ergonomic and secure. ○ Advise product and finance teams on data-model trade-offs. What We’re Looking For Must-Have Nice-to-Have 5 yrs building high-throughput backend systems Experience with BI/reporting engines or OLAP stores Deep Ruby/Rails & ActiveRecord expertise Exposure to ClickHouse/Redshift/BigQuery Hands-on MySQL tuning (indexes, partitioning, query plans) Event-driven or stream processing (Kafka, Kinesis) Proven record scaling background-job frameworks (Sidekiq, Resque, Celery, etc.) Familiarity with data-viz pipelines (we use Highcharts.js) AWS production experience (EC2, RDS, IAM, VPC) Contributions to OSS or tech-blog posts on performance What Success Looks Like (6-12 Months) ● Daily report-generation latency cut by 50 % while data volume doubles. ● Zero-downtime schema migrations and automated backfill strategy in place. ● First phase of studio-settlement APIs shipped and adopted by finance ops. ● Comprehensive dashboards/alerts proactively surface scaling limits before customers notice. Why INDY Rocks ● Massive Visible Impact – Your optimizations ripple out to millions of moviegoers. ● Start-to-Finish Ownership – No layers of bureaucracy; ship, measure, iterate. ● Technically Spicy – Distributed computing meets real-world financial correctness. Tight-Knit Crew – Collaborate directly with founders and domain experts.