Python Developer

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

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.

• Design and develop LLM-poweredagents for natural language to data analysis workflows (CSV-first, thendatabase integrations).
• Build intelligent agentpipelines using Lang Chain, Lang Graph, Llama Index, 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.

• Develop and maintainpandas-based data analysis tools for CSV/Excel processing.
• Implement secure text-to-SQLgeneration and execution using SQL toolkits (e.g., SQL Database toolkit,DuckDB).
• Ensure schema-aware querygeneration by injecting metadata, table descriptions, and contextualinformation.
• Support self-correction,clarification prompts, and iterative reasoning for improved accuracy.

• Implement safeguards for safe Python and SQL execution (query validation, injection prevention, restrictedexecution environments, timeouts).
• Apply validation checks beforeexecuting generated queries.
• Minimize hallucinations andensure high execution reliability.

• Develop simple demo or internalinterfaces using Streamlit, Gradio, or Chainlit.
• Integrate connectors forrelational databases and metadata retrieval.

• 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 optimize performance and response latency.
• Collaborate with backend,frontend, and product teams to expand from CSV-only support to full databaseconnectivity.
• Maintain clear documentation for agent workflows, architecture decisions, and integration processes.
• Participate in sprint planning,technical discussions, and continuous improvement initiatives.

• Maintain detailed documentation of architecture, modules, and integration workflows.
• Provide periodic progress reports, technical evaluations, and release notes to the management team.

• 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.
• Experience implementing Retrieval-Augmented Generation (RAG) for schema or contextinjection

• Bachelor’s degree in computer science, AI, Data Science, or related field.
• 3+ years of experience in Python development.
• Strong proficiency in Python(3.9+), modular architecture, type hints, and basic async programming.
• Advanced experience with pandasand Num Py for data manipulation and analysis.
• Practical experience buildingLLM agents or chains using Lang Chain, Lang Graph, or Llama Index (minimum 1–2real projects).
• Strong understanding of SQL(SELECT, JOIN, GROUP BY, WHERE) and relational database concepts.
• Familiarity with prompt engineering, tool-calling, React patterns, and conversational memory.
• Experience using Git and writing basic tests with pytest.

• 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.