PYTHON DEVELOPER

Job posted on11/02/2026LocationSOSOCIALFunctionIT DepartmentDepartmentINFORMATION TECHNOLOGYDesignationIT SUPPORTEntitySOSOCIALNumber of Position(s)1Openings Valid Till28/02/2026Company DescriptionCapital 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 DescriptionKey ResponsibilitiesDesign 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 SystemsDevelop 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 ExecutionImplement 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 DevelopmentDevelop simple demo or internalinterfaces using Streamlit, Gradio, or Chainlit.Integrate connectors forrelational databases and metadata retrieval.Testing, Evaluation &OptimizationWrite 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 & ReportingMaintain detailed documentationof architecture, modules, and integration workflows.Provide periodic progressreports, technical evaluations, and release notes to the management team.Preferred/ Strong AdvantageExperience 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 contextinjectionQualificationsQualifications & SkillsBachelor’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 InformationThe 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.#J-18808-Ljbffr