PYTHON DEVELOPER

Capital Motion; Abu Dhabi; On-site; AED 201,000 - 312,000; Full time

Benefits offered by this job

Health insurance

Accommodation allowance

Transportation allowance

Annual paid leave

Uniforms and duty meals

Exclusive discounts

Duty meals

Tips, incentives and performance-based

Job summary

A leading hospitality group in Abu Dhabi is seeking an IT Support professional. This role involves designing LLM-powered agents for data workflows, ensuring secure execution of queries, and developing analysis tools using Python and SQL. Candidates should have a bachelor's degree in a relevant field along with at least three years of Python experience. The position offers competitive benefits and requires a willingness to work in the Abu Dhabi area.

Qualifications

• 3+ years of experience in Python development.
• Strong proficiency in Python (3.9+) and modular architecture.
• Advanced experience with pandas and NumPy.
• Experience with pandas and NumPy for data manipulation.
• Practical experience building LLM agents using Lang Chain/LangGraph/LlamaIndex.
• Strong understanding of SQL and relational databases.
• Familiarity with prompt engineering, tool-calling, React patterns, and memory handling.
• Experience using Git and pytest.

Responsibilities

• Design and develop LLM-powered agents for data analysis workflows.
• Implement multi-step reasoning strategies to handle complex analytical queries.
• Develop and maintain data analysis tools for CSV/Excel processing.
• Optimize prompt design, tool-calling logic, and conversation memory handling.

Skills

Python programming

Data analysis with pandas

SQL knowledge

Experience with LLM development

Modular architecture understanding

Basic async programming

Education

Bachelor’s degree in computer science, AI, Data Science, or related field

Tools

DuckDB

SQLAlchemy

Git

Streamlit

Gradio

Chainlit

Job description

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.