Senior Backend Data & Reporting Engineer

One Tech Capital LLC · Dubai

Hybrid: DubaiFull TimeInformation Technology
Posted 1 months ago

Job description

Responsibilities

  • 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
  • Analyze slow queries
  • Improve indexes and execution plans
  • Optimize heavy aggregation queries
  • Handle large datasets efficiently
  • 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.

Requirements

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

Preferred Qualifications

  • 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

Benefits

About the Company

One Tech Capital is a tech-driven platform focused on providing SaaS solutions for retail, fitness, and F&B industries. The company is looking for a Senior Backend Data & Reporting Engineer to take full ownership of reporting, dashboards, and database query optimization for the AllUp SaaS platform.

Skills & tools

PostgreSQLSQLTypeScriptNode.jsGraphQLDashboard DevelopmentQuery Optimization

What the team is looking for

Use this list as a quick fit check before you apply.

  1. 01PostgreSQL
  2. 02SQL
  3. 03Dashboard Development
  4. 04Query Optimization
  5. 05Relational Databases
  6. 06Node.js
  7. 07TypeScript
  8. 08GraphQL