About this role
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)