81FB: Digital Solutions and Integration Developer (SQL + Web + Visual FoxPro) — with AI as a differentiator.

Description

Job Summary: Digital Solutions and Integration Developer, focused on productivity and usability, with AI as a differentiator for process optimization. Key Highlights: 1. Development of web applications for productivity and automation. 2. Integration of legacy systems with modern technologies (Visual FoxPro and SQL). 3. Opportunity to apply Artificial Intelligence in innovative solutions. Digital Solutions and Integration Developer (SQL \+ Web \+ Visual FoxPro), with AI as a differentiator. * Develop web applications oriented toward productivity (e.g., preparing quotations, configuring products, browsing catalogs, generating PDFs). * Implement business rules in a simple and clear “rules engine” (compatibilities, exceptions, price ranges, deadlines). * Create and consume APIs to integrate data from the current system (including DBF/Visual FoxPro databases) with new applications. * Model and optimize SQL queries for high-performance read/write operations. * Build concise frontend interfaces (UI) focused on usability for sales staff/internal departments. * Ensure basic security (authentication, access profiles) and quality (logging, error handling). * Document workflows and decisions simply for non-technical teams. Typical deliverables: a quotation app with pricing/compatibility rules; an internal dashboard applying rules and suggesting combinations; PDF generation with visual summary and data; a service exposing legacy data via API for use in new UIs. Where AI can be applied (desirable, not mandatory): * Intelligent suggestions in the configurator (e.g., similar finishes by color/fabric/price range based on rules \+ historical data). * In-app assistants for filling out or explaining fields (e.g., “Why is this combination not allowed?” in natural language). * Catalog classification/normalization (e.g., unifying fabric/color names via embeddings/rules). * Automatic summaries of commercial rules in plain language for sales staff. * Document information extraction (e.g., OCR of lists, reading file metadata) to accelerate data entry. * Integration playbooks: RAG over internal documentation; automatic validation of generated text (guardrails); AI logging and auditing. Important: AI as a means to improve user experience and efficiency — with data security, explainability, and fallback to traditional rule-based logic. Essential Technical Requirements * Advanced SQL: modeling, complex queries, indexing, and performance optimization. * Visual FoxPro (VFP): maintenance/integration of legacy systems, DBF manipulation, connectivity (ODBC/OLE DB/COM), and exposure of data/functionality to modern applications. * Web Development: * Backend using a modern stack (e.g., Node.js/TypeScript, .NET/C\#, or Python). * Frontend using a modern framework (e.g., React/Vue/Angular). * Creation/consumption of APIs (REST/GraphQL) and profile-based authentication/authorization. * Integrations with internal systems/ERP and development of intermediate layers (services/facades). * PDF generation from templates and data. * Best practices: Git, basic testing, logging, error handling, data security. Desirable Qualifications (nice-to-have, not required) * Practical experience embedding AI into internal products: * LLMs for assistants/context (basic prompt engineering, RAG, embeddings). * Simple rule/data-driven recommendations. * OCR/classification/normalization of data. * Security best practices and “guardrails” (limits, validations, auditing). * Product configurators/CPQ or catalogs with extensive rules. * ETL/data synchronization between DBF and relational databases (e.g., SQL Server). * Familiarity with consuming CAD services when needed (without developing 3D).