Senior Python AI Developer Needed for Retail Analytics MVP (PostgreSQL + LLM + FastAPI)

Senior Python AI Developer Needed for Retail Analytics MVP (PostgreSQL + LLM + FastAPI) Description: We are building an AI-powered Retail Analytics platform (RetailMind) focused on helping retailers analyze sales, inventory, stock availability, overstock, and shrinkage through natural language questions and business insights. This is an MVP project focused on validating the concept before expanding into a full SaaS platform. Project Goal: A user should be able to ask questions such as: * What were sales yesterday? * Which branch had the highest shrinkage this week? * Which products are out of stock? * Which products are overstocked? The system should: 1. Understand the question 2. Generate accurate SQL 3. Query PostgreSQL 4. Return results 5. Generate a business explanation MVP Scope: Data Areas: * Sales * Inventory * Product Master * Branch Master * Shrinkage Technology Stack: Backend: * Python * FastAPI Database: * PostgreSQL AI: * Claude API and/or OpenAI API Infrastructure: * Docker What Already Exists: * Business requirements defined * Retail use cases defined * Top KPI framework defined * Initial data model defined Responsibilities: * Design and implement PostgreSQL database schema * Build data ingestion process from CSV files * Build KPI calculation layer * Implement Text-to-SQL workflow * Integrate Claude/OpenAI APIs * Build business explanation layer * Develop REST APIs * Implement logging and error handling * Support testing and validation Required Skills: * Python * FastAPI * PostgreSQL * SQL * API Development * OpenAI / Claude Integration * Prompt Engineering * Docker * Git Preferred Skills: * LangChain or LangGraph * Data Warehouse Design * Analytics Platforms * Business Intelligence * Retail Analytics * Inventory Management Systems * ERP Integration Experience Deliverables: Milestone 1: * Database Schema * Data Model * Sample Data Load Milestone 2: * KPI Engine * SQL Query Layer Milestone 3: * AI Integration * Natural Language Question Processing Milestone 4: * Testing * Documentation * Deployment Package Project Duration: Estimated 6-10 weeks. Engagement Type: Fixed Price with Milestones. When Applying Please Include: 1. Similar AI projects completed 2. Experience with Text-to-SQL systems 3. Experience with PostgreSQL and analytics platforms 4. Proposed architecture for this solution 5. Estimated timeline 6. Availability Screening Questions: 1. Describe how you would design a system that converts natural language questions into accurate SQL queries while minimizing hallucinations. 2. Have you built any Text-to-SQL, AI analytics, RAG, or LLM-based applications? Please provide examples. 3. Which would you choose for this project and why: FastAPI, Django, or Node.js? 4. How would you prevent an AI model from generating incorrect answers when querying business data? 5. Have you worked with retail, inventory, ERP, POS, supply chain, or business intelligence systems before? If yes, please describe.