Senior Backend Data & Reporting Engineer

Senior Backend Data & Reporting EngineerAllUp Platform – One Tech CapitalWe’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 OverviewOwn all reporting logic and query layersBuild and optimize complex PostgreSQL queriesDevelop and maintain AllUp dashboardsEnsure reporting accuracy and performance at scaleGradually take ownership of legacy reporting logic and refactor it properlyMust-Have (Non-Negotiable)Expert-level PostgreSQLAdvanced SQL query writing (joins, aggregations, window functions, CTEs)Experience optimizing slow queries and improving performanceStrong understanding of relational database designExperience building dashboardsAbility to understand and refactor legacy database logicStrong debugging and analytical skillsTypeScript + Node.jsPostgreSQLPrismaGraphQLStrong backend fundamentals (performance, scalability, clean architecture)Core ResponsibilitiesReporting & DashboardsBuild and maintain AllUp reporting dashboardsTranslate business requirements into accurate SQL queriesDesign reusable query views and reporting modelsEnsure financial and membership reports are 100% accurateQuery OptimizationAnalyze slow queriesImprove indexes and execution plansOptimize heavy aggregation queriesHandle large datasets efficientlyDatabase OwnershipUnderstand and document legacy reporting queriesClean up redundant or duplicated reporting logicMaintain reporting consistency across modulesEnsure correct joins across memberships, payments, gyms, users, etc.Experience Required4+ years working heavily with SQL/PostgreSQLReal production reporting experienceExperience with financial or transactional systems preferredExperience in SaaS products is a plusLocationRemote – Full-Time OnlyEgypt, India, PakistanImportantImmediate joiners preferredNo part-timeNo freelancersNo multiple jobsNo hiring agencies (direct applicants only)#J-18808-Ljbffr