Back to jobs

Senior Backend Data & Reporting Engineer

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

Own all reporting logic and query layers

Build and optimize complex PostgreSQL queries

  • Build and maintain AllUp reporting dashboards

  • Build and optimize complex PostgreSQL queries

  • Analyze slow queries and improve indexes and execution plans

  • Refactor legacy reporting logic and clean up duplicated logic

  • Design reusable query views and reporting models

From the employer’s posting
Own all reporting logic and query layers
Build and optimize complex PostgreSQL queries
Build and maintain AllUp reporting dashboards
Analyze slow queries
Gradually take ownership of legacy reporting logic and refactor it properly
Design reusable query views and reporting models

What you’ll bring

All qualifications

Core experience

  • 4+ years working heavily with SQL/PostgreSQL
  • Expert-level PostgreSQL
  • Advanced SQL: joins, aggregations, window functions, CTEs
  • TypeScript and Node.js, with Prisma and GraphQL
  • Experience building dashboards and production reporting

Preferred experience

  • Experience with financial or transactional systems
  • Experience in SaaS products
Qualification wording
4+ years working heavily with SQL/PostgreSQL
Expert-level PostgreSQL
Advanced SQL query writing (joins, aggregations, window functions, CTEs)
TypeScript + Node.js
Real production reporting experience
Experience with financial or transactional systems preferred
Experience in SaaS products is a plus
Apply at One Tech Capital

Posting record

Report an error

Open 5 monthsWe first saw this posting 170 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 4, 2026170 days ago
Recorded sightings
97
Last seen by us
Nov 21, 2026

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

How this job compares

Time since we first saw it

Day 170

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,020 similar postings that came down. Coming down is not always a hire.

One Tech Capital is hiring

1 open job

  • No new data jobs since June
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • TypeScript
  • PostgreSQL
  • Node.js
Where the posting names them
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
- Strong debugging and analytical skills - TypeScript + Node.js - PostgreSQL
- 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

Your next step

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

Applying through BambooHR

  • No account needed. The form takes images too, but an image of a resume has no text for anyone to search: upload a PDF or Word file.

Already applied? Track this application

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)

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

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.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.