Senior Backend Data & Reporting Engineer

Senior Backend Data & Reporting Engineer AllUp Platform – One Tech Capital We’re hiring a Senior Data & Reporting Engineer to take full ownership of reporting, dashboards, and database query optimization for the AllUp SaaS platform (Retail / Fitness / F&B). This role is database-heavy and reporting-focused — not a general backend engineering role. We are looking for someone who lives and breathes SQL, understands complex schemas, and can build reliable, production-grade dashboards and reports used by business stakeholders daily. Role Overview This role will: Own all reporting logic and query layers Build and optimize complex PostgreSQL queries Develop and maintain AllUp dashboards Ensure reporting accuracy and performance at scale Gradually take ownership of legacy reporting logic and refactor it properly Must-Have (Non-Negotiable) Expert-level PostgreSQL Advanced SQL query writing (joins, aggregations, window functions, CTEs) Experience optimizing slow queries and improving performance Strong understanding of relational database design Experience building dashboards Ability to understand and refactor legacy database logic Strong debugging and analytical skills TypeScript + Node.js PostgreSQL Prisma GraphQL Strong backend fundamentals (performance, scalability, clean architecture) Core Responsibilities Reporting & Dashboards Build and maintain AllUp reporting dashboards Translate business requirements into accurate SQL queries Design reusable query views and reporting models Ensure financial and membership reports are 100% accurate Query Optimization Analyze slow queries Improve indexes and execution plans Optimize heavy aggregation queries Handle large datasets efficiently Database Ownership Understand and document legacy reporting queries Clean up redundant or duplicated reporting logic Maintain reporting consistency across modules Ensure correct joins across memberships, payments, gyms, users, etc. Experience Required 4+ years working heavily with SQL/PostgreSQL Real production reporting experience Experience with financial or transactional systems preferred Experience in SaaS products is a plus Location Remote – Full-Time Only Egypt, India, Pakistan Important Immediate joiners preferred No part-time No freelancers No multiple jobs No hiring agencies (direct applicants only)