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)