Develop the Workflow API Service: Design and build the primary backend microservice using Python (preferably with FastAPI). This service will act as a "Backend for Frontend" (BFF) and the central coordinator for the business process.
Implement Multi-Tenancy: Build robust data isolation logic to support different business user groups (HBEU, HBUK, Group). This includes ensuring all database queries and API logic are tenant-aware (tenant_id).
Design & Build RESTful APIs: Create clean, secure, and efficient RESTful endpoints for the React frontend to consume for actions like initiating uploads, fetching staged data for approval, and submitting adjustments.
Integrate with GCP Services:
- Publish messages to Google Cloud Pub/Sub to asynchronously trigger data processing pipelines (following an event-driven pattern).

- Interact with Cloud SQL (PostgreSQL) for all state management and data retrieval, writing efficient and secure queries.

- Integrate with Google Secret Manager for secure handling of database credentials and API keys.
- Containerize and Deploy: Package the application using Docker and write Kubernetes manifests (Deployments, Services) for deployment on Google Kubernetes Engine (GKE).
- Testing: Write comprehensive unit and integration tests using frameworks like Pytest to ensure API reliability and correctness.

Senior Data/backend Engineer

Job Description