Senior Backend Data & Reporting Engineer

COFE App; Dubai; On-site; AED 293,793 - 367,242; Full time

Job summary

A technology company is seeking a Senior Backend Data & Reporting Engineer to lead the optimization of databases and reporting for their AllUp SaaS platform. This role requires expert-level SQL/PostgreSQL proficiency and the ability to design and maintain dashboards. Ideal candidates should have a minimum of 4 years of relevant experience, particularly in production reporting and financial systems. This is a remote, full-time position, and immediate joiners are preferred.

Qualifications

• 4+ years working heavily with SQL/PostgreSQL.
• Real production reporting experience.
• Experience with financial or transactional systems preferred.

Responsibilities

• Build and maintain AllUp reporting dashboards.
• Translate business requirements into accurate SQL queries.
• Optimize heavy aggregation queries.

Skills

Expert-level PostgreSQL

Advanced SQL query writing

Debugging and analytical skills

Strong backend fundamentals

TypeScript

Node.js

Prisma

GraphQL

Tools

PostgreSQL

Job description

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

• 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)