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)
Skills Required
- 4+ years working heavily with SQL/PostgreSQL
- 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 and Node.js
- Prisma
- GraphQL
- Strong backend fundamentals (performance, scalability, clean architecture)
- Real production reporting experience
- Experience with financial or transactional systems
- Experience in SaaS products
- Remote, full-time based in Egypt, India, or Pakistan
- Immediate joiners preferred
What We Do
One Tech Capital is a startup studio that specializes in building startups from the ground up by leveraging expertise, assets, and networks. The company's scope covers product evolution, seamless operations, market domination tactics, and compelling marketing maneuvers to establish ventures from the bottom up and patch disparities across various industries and ecosystems.
