Job posted on
11/02/2026
Location
SOSOCIAL
Function
IT Department
Department
INFORMATION TECHNOLOGY
Designation
IT SUPPORT
Entity
SOSOCIAL
Number of Position(s)
1
Openings Valid Till
28/02/2026
Company Description
Capital Motion owns and operates some of the UAE’s leading licensed restaurants, delivering high-quality dining experiences across diverse concepts. As a growing hospitality group, we are continuously looking for passionate and motivated individuals to join our team.
We are currently hiring for various roles within restaurant operations, including F&B service, waitresses/waiters, hostesses, kitchen and bar operations, and venue management.
All positions offer a competitive and complete employment package, including residence visa, accommodation allowance, transportation allowance, annual paid leave, health insurance, and basic salary. Operations staff are provided with uniforms, duty meals, and have the opportunity to earn tips, incentives, and performance-based bonuses. Employees also enjoy exclusive discounts across Capital Motion restaurants.
Job Description
Key Responsibilities
- Design and develop LLM-poweredagents for natural language to data analysis workflows (CSV-first, thendatabase integrations).
- Build intelligent agentpipelines using LangChain, LangGraph, LlamaIndex, or similar frameworks.
- Implement multi-step reasoningstrategies (ReAct, plan-and-execute) to handle complex analytical queriesincluding joins, aggregations, subqueries, and trend analysis.
- Optimize prompt design,tool-calling logic, and conversation memory handling.
Data Processing &Text-to-SQL Systems
- Develop and maintainpandas-based data analysis tools for CSV/Excel processing.
- Implement secure text-to-SQLgeneration and execution using SQL toolkits (e.g., SQLDatabase toolkit,DuckDB).
- Ensure schema-aware querygeneration by injecting metadata, table descriptions, and contextualinformation.
- Support self-correction,clarification prompts, and iterative reasoning for improved accuracy.
Security & Safe Execution
- Implement safeguards for safePython and SQL execution (query validation, injection prevention, restrictedexecution environments, timeouts).
- Apply validation checks beforeexecuting generated queries.
- Minimize hallucinations andensure high execution reliability.
API & Interface Development
- Develop simple demo or internalinterfaces using Streamlit, Gradio, or Chainlit.
- Integrate connectors forrelational databases and metadata retrieval.
Testing, Evaluation &Optimization
- Write clean, modular, andmaintainable Python code with proper type hints.
- Develop basic unit tests usingpytest.
- Contribute to evaluationdatasets measuring accuracy, execution success rate, and hallucinationreduction.
- Continuously optimizeperformance and response latency.
- Collaborate with backend,frontend, and product teams to expand from CSV-only support to full databaseconnectivity.
- Maintain clear documentationfor agent workflows, architecture decisions, and integration processes.
- Participate in sprint planning,technical discussions, and continuous improvement initiatives.
Documentation & Reporting
- Maintain detailed documentationof architecture, modules, and integration workflows.
- Provide periodic progressreports, technical evaluations, and release notes to the management team.
Preferred/ Strong Advantage
- Experience building naturallanguage to pandas or text-to-SQL agents (including personal prototypes).
- Hands-on experience with DuckDB, SQL Alchemy, psycopg2, or other database connectors.
- Experience building agentinterfaces using Streamlit, Gradio, or Chainlit.
- Knowledge of secure executionenvironments, sandboxing, and query validation techniques.
- Experienceimplementing Retrieval-Augmented Generation (RAG) for schema or contextinjection
Qualifications
Qualifications & Skills
- Bachelor’s degree in computerscience, AI, Data Science, or related field.
- 3+ years of experience inPython development.
- Strong proficiency in Python(3.9+), modular architecture, type hints, and basic async programming.
- Advanced experience with pandasand NumPy for data manipulation and analysis.
- Practical experience buildingLLM agents or chains using Lang Chain, LangGraph, or LlamaIndex (minimum 1–2real projects).
- Strong understanding of SQL(SELECT, JOIN, GROUP BY, WHERE) and relational database concepts.
- Familiarity with promptengineering, tool-calling, React patterns, and conversational memory.
- Experience using Git andwriting basic tests with pytest.
Additional Information
- The work location is Yas Bay, Waterfront, Y as Island, Abu Dhabi.
- Please ensure you are willing and able to work within the Abu Dhabi area before applying.