Pay: Salary not listed in the saved posting
Work setup: Unconfirmed
Employment: Unconfirmed

Apply at Onetechcapital

What you’ll work on

Full posting

Own all reporting logic and query layers

Build and optimize complex PostgreSQL queries

Tools in this posting

SQL
PostgreSQL
TypeScript
Node.js

Source

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

- Expert-level PostgreSQL - Advanced SQL query writing (joins, aggregations, window functions, CTEs) - Experience optimizing slow queries and improving performance

- Build and maintain AllUp reporting dashboards - Translate business requirements into accurate SQL queries - Design reusable query views and reporting models

Experience Required - 4+ years working heavily with SQL/PostgreSQL - Real production reporting experience

- Own all reporting logic and query layers - Build and optimize complex PostgreSQL queries - Develop and maintain AllUp dashboards

Must-Have (Non-Negotiable) - Expert-level PostgreSQL - Advanced SQL query writing (joins, aggregations, window functions, CTEs)

- TypeScript + Node.js - PostgreSQL - Prisma

- Strong debugging and analytical skills - TypeScript + Node.js - PostgreSQL

Job description

View original posting ↗

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)

Your next step

Have your CV and examples of relevant work ready.
Check the listed location, eligibility and core experience before starting.
Ask the employer about the salary range before committing time to the process.

Complete your application on onetechcapital.bamboohr.com. The employer’s form will show what is required.

Already applied? Track this application

Source & posting history

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay: No pay amount identified in the saved description.
Location & working pattern: Dubai, United Arab Emirates
Location Remote – Full-Time Only Egypt, India, Pakistan
Work authorization: No clear work-authorization passage found. Eligibility is unconfirmed.

Open source at onetechcapital.bamboohr.com ↗Read the full description ↓

Status in our records: Active
First seen by us: Jun 4, 2026
Recorded sightings: 57
Last seen by us: Oct 8, 2026

These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.

Report an error

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Upload resume Add LinkedIn