AI Solution Engineer (Agentic & Prompt)

Gigalabs; Lahore; On-site; PKR 1,200,000 - 2,400,000; Full time

Job summary

Gigalabs in Lahore is seeking an experienced AI/API backend engineer to build and maintain AI-driven APIs and data tools. You will work onsite in Johar Town, implementing data pipelines and ensuring data quality for LLM workflows.

Responsibilities include expanding RESTful services with FastAPI/Flask, wrapping data models into deployable microservices, and optimizing PostgreSQL with vector data storage.

Qualifications

• Hands-on proficiency in Python for data manipulation and backend logic.
• Experience building RESTful APIs with FastAPI and Flask.
• Experience wrapping data models into deployable microservices.
• Experience with LLM pipelines using LangChain, LlamaIndex, or similar.
• Deep familiarity with the OpenAI API and cost optimization.
• Strong PostgreSQL skills including advanced SQL and tuning.
• Experience with vector embeddings and pgvector for vector search.
• Ability to design efficient data schemas for logs and history.
• Experience with n8n workflow automation for data pipelines.

Responsibilities

• Develop AI-Driven APIs: Build internal tools and endpoints using FastAPI that serve data insights powered by LLMs.
• Automate Business Logic: Replace manual data entry and analysis tasks with autonomous n8n workflows.
• Data Quality Assurance: Ensure inputs to LLM pipelines are clean and outputs are accurate.
• Database Management: Maintain and optimize PostgreSQL with relational and vector data.

Skills

Python proficiency

API development

FastAPI

Flask

Microservices

LangChain

LlamaIndex

OpenAI API

Prompt engineering

PostgreSQL

pgvector

n8n

ETL/ELT

Tools

PostgreSQL

OpenAI API

pgvector

n8n

LangChain

LlamaIndex

Job description

Job Brief:
Employment Type: Full time, Onsite
Timings: 12PM-9PM
Location: Johar Town, G4
Experience: 4-5years

• Develop AI-Driven APIs: Build internal tools and endpoints using FastAPI that serve data insights powered by LLMs.
• Automate Business Logic: Replace manual data entry and analysis tasks with autonomous n8n workflows.
• Data Quality Assurance: Ensure the inputs fed into LLM pipelines are clean and the outputs generated are accurate and hallucination-free.
• Database Management: Maintain and optimize the PostgreSQL instance to handle increasing loads of relational and vector data.
  

Requirements:

Candidates must possess hands-on proficiency in the following areas:

Core Programming & APIs

• Python Proficiency: Advanced knowledge of Python for data manipulation and
  backend logic.
  
• API Development: Proven experience building, documenting, and maintaining RESTful APIs using FastAPI (preferred for async capabilities) and Flask.
• Microservices: Ability to wrap data models and scripts into deployable services.

AI & LLM Integration

• LLM Pipelines: Experience constructing chains and agents (e.g., using LangChain,
  LlamaIndex, or custom scripts) to process text and data.
  
• OpenAI API: Deep familiarity with the OpenAI ecosystem (GPT-4, Assistants API, function calling) and cost optimization strategies.
• Prompt Engineering: Demonstrated ability to design system prompts that yield consistent, structured outputs (JSON) from unstructured data.

Database & Data Management

• PostgreSQL Mastery: Advanced SQL skills including complex joins, window
  functions, and performance tuning.
  
• Vector Data: Experience with vector embeddings and vector similarity search (e.g., using pgvector in PostgreSQL) for RAG (Retrieval-Augmented Generation) implementations.
• Data Modeling: Ability to design efficient database schemas to store historical data and LLM interaction logs.

Automation & Orchestration

• n8n Workflow Automation: Strong experience creating complex, conditional
  workflows in n8n to connect disparate services (Webhooks, APIs, Databases).
  
• ETL/ELT: Ability to automate data extraction and transformation pipelines using n8n and Python scripts.