AI Solution Engineer (Agentic & Prompt)

gigalabs-private-ltd; Lahore; On-site; PKR 2,400,000 - 4,200,000; Full time

Job summary

gigalabs-private-ltd in Lahore (Johar Town, G4) seeks an experienced backend engineer to build AI-driven APIs and automate data workflows using FastAPI and n8n. You will ensure data quality for LLM pipelines, manage PostgreSQL databases with vector data, and design scalable microservices.

The role requires deep Python, API development, and experience with LLM integrations (LangChain/LlamaIndex) and OpenAI ecosystems. Onsite work with 12PM-9PM timings, 4–5 years of relevant experience.

Qualifications

• Hands-on proficiency in Python for data manipulation and backend logic.
• Experience building, documenting, and maintaining RESTful APIs using FastAPI and Flask.
• Ability to wrap data models and scripts into deployable microservices.
• Experience constructing LLM pipelines and agents to process text and data.
• Familiarity with OpenAI ecosystem and cost optimization strategies.
• Advanced SQL skills in PostgreSQL, including joins, window functions, and performance tuning.
• Experience with vector embeddings and vector similarity search in PostgreSQL for RAG implementations.
• Experience with n8n workflow automation for building complex, conditional workflows.
• Ability to design data models and store LLM interaction logs.

Responsibilities

• Develop AI-Driven APIs using FastAPI to serve data insights powered by LLMs.
• Automate business logic with autonomous n8n workflows.
• Ensure data quality for inputs to LLM pipelines and outputs.
• Maintain and optimize PostgreSQL for relational and vector data loads.

Skills

Python proficiency

API development

Microservices

LLM pipelines

Prompt engineering

Data modeling

n8n workflow automation

ETL/ELT

Tools

FastAPI

Flask

pgvector

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.