Senior Backend Software Engineer - ERP & AI Core

About the job

Senior Backend Software Engineer - ERP & AI Core About the Project We are seeking a highly specialized Senior Backend Engineer to architect, build, and secure the mission-critical core of a sophisticated Construction ERP (Enterprise Resource Planning) system for Infratech AI (p. 1). This is not a typical CRUD application; it requires deep expertise in transactional integrity, financial ledger design, and high-performance data operations (p. 1). The Role This is a full-time position. You will work with a modern stack including NestJS, TypeScript, PostgreSQL (Prisma), Apollo GraphQL, Google Cloud Run, and Firebase Auth (p. 1). Core Responsibilities • Architect and optimize the PostgreSQL schema using Prisma ORM to support complex relational data. This includes the General Ledger (GL), Chart of Accounts, and Inventory Management systems. Implement reliable, atomic database transactions (ACID) for financial modules. Examples include automated double-entry journal postings, payroll finalization, and client billing. • Design, implement, and document a robust, high-performance API layer using NestJS and Apollo GraphQL (Code First). Implement caching strategies for frequently accessed data and build efficient data resolvers for complex queries required by the frontend's visual dashboards. Caching strategies may include Redis. • Manage secure backend integration with the Google Gemini API for high-value AI features. Architect the Retrieval-Augmented Generation (RAG) system for the "Ask Data" natural language query feature. • Integrate NestJS with Firebase Authentication for token validation. Implement role-based access control (RBAC). Work with DevOps to deploy and maintain the NestJS application on Google Cloud Run using containerization (Docker). Required Skills & Qualifications • Minimum 5+ years of professional experience in backend development. • Expertise in NestJS and TypeScript is mandatory. • Experience with PostgreSQL and an ORM (Prisma or TypeORM). This includes schema migration and advanced query optimization. • Expert in designing and implementing performant GraphQL APIs. • Working knowledge of Docker, Git, and deployment on Google Cloud (Cloud Run, Cloud SQL). Nice-to-Have Skills • Experience working on complex transactional systems, accounting software, or core ERP modules is a significant advantage. • Experience with GraphQL Code Generation tools or the Firebase Admin SDK. • Familiarity with financial reporting standards. Examples include the Chart of Accounts structure.

Requirements

• NestJS
• TypeScript
• PostgreSQL
• Prisma
• Apollo GraphQL
• Docker

Preferred Technologies

• NestJS
• TypeScript
• PostgreSQL
• Prisma
• Apollo GraphQL
• Docker