Senior Backend Data & Reporting Engineer

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.