Location: Remote (Global) Team Size: ≈ 10 engineers Core Stack: Ruby on Rails (API-only), Sidekiq, MySQL, AWS (EC2, RDS, EFS), Highcharts.js (data consumers) Find out more about this role by reading the information below, then apply to be considered. 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.