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)