# Senior Consultant Specialist

**Company**: GCIO
**Location**: Guangzhou, Guangdong
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Technology

**Apply**: https://portal.careers.hsbc.com/careers/job/563774612658075?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/job/senior-consultant-specialist-f60979e4-18b/

## Description

We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist.

**Principal Responsibilities:**

- Full-Stack Development: Design, build, and maintain production features for FinSphere across high-performance FastAPI backends and responsive React 19 / TypeScript user interfaces.

- Build AI-Powered Capabilities: Implement and optimize RAG retrieval engines, vector embeddings with PostgreSQL/pgvector, and real-time streaming interfaces (Server-Sent Events / WebSockets) for financial Q&A and agent interactions.

- Agentic & Analytical Workflows: Develop backend data pipelines enabling Natural Language-to-SQL conversions, dynamic chart/report generation, and automated document synthesis (PowerPoint/Word/JSON).

- Quality & Performance: Write comprehensive automated unit, integration, and end-to-end tests; proactively identify and resolve performance bottlenecks across API endpoints and database queries.

- DevOps & Collaboration: Collaborate within an Agile team to deploy microservices onto GCP/GKE via modern CI/CD pipelines, actively participating in peer code reviews and sprint ceremonies.

**Requirements:**

- Proven Track Record: 5+ years of full-stack or backend software engineering experience building scalable web applications.

- Backend Expertise: Proficiency in Python (FastAPI / Pydantic / SQLAlchemy) and building clean, secure RESTful APIs and asynchronous background tasks.

- Modern Frontend Skills: Strong experience with React, TypeScript, modern state management, and component libraries.

- Database & Vector Search: Solid knowledge of PostgreSQL, relational data modeling, and practical experience with vector search / embeddings (pgvector or similar).

- Generative AI Fundamentals: Hands-on experience integrating LLM APIs, building RAG components, document chunking, and handling streaming responses.

- Software Engineering Discipline: Rigorous approach to automated testing (pytest, Jest/Vitest), Git workflows, and containerization with Docker.

For more fresh new jobs, check out [yubhub.co](https://yubhub.co/).

## Skills

### Required
- Python
- FastAPI
- Pydantic
- SQLAlchemy
- React
- TypeScript
- PostgreSQL
- pgvector
- LLM APIs

---

Source: [Apply at portal.careers.hsbc.com](https://portal.careers.hsbc.com/careers/job/563774612658075?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)
