AI Solution Engineer Agentic And Prompt

Gigalabs (Pvt) Ltd.; Lahore; On-site; PKR 1,800,000 - 3,200,000; Full time

Job summary

Gigalabs (Pvt) Ltd. in Lahore (Johar Town) is seeking a backend AI engineer to develop AI-driven APIs and automate data workflows. You will focus on building services with Python, FastAPI/Flask, and PostgreSQL, including vector data handling for RAG.

The role requires 4–5 years of hands-on experience with LLM integrations, API design, and data modeling. This onsite position emphasizes scalable microservices and comprehensive ETL/ELT workflows.

Qualifications

• Proficient in Python for backend data manipulation and logic.
• Experience building, documenting, and maintaining RESTful APIs with FastAPI and Flask.
• Experience wrapping data/models into deployable microservices.
• Experience constructing LLM pipelines with LangChain or LlamaIndex.
• Familiarity with OpenAI APIs, GPT-4, and cost-optimization strategies.
• ability to design prompts for structured JSON outputs from unstructured data.
• Advanced SQL skills including joins, window functions, and performance tuning in PostgreSQL.
• Experience with vector embeddings and pgvector for RAG implementations.
• Data modeling to store historical data and LLM interaction logs.
• Experience creating complex n8n workflows for APIs, webhooks, and databases.
• ETL/ELT automation with Python scripts.

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 and hallucination-free.
• Database Management: Maintain and optimize PostgreSQL for relational and vector data.

Skills

Python

API Development

Microservices

LangChain/LlamaIndex

OpenAI API

Prompt Engineering

PostgreSQL

Vector Data (pgvector)

Data Modeling

n8n Workflow

ETL/ELT

Tools

FastAPI

Flask

PostgreSQL tooling

LangChain

LlamaIndex

OpenAI SDK

Job description

Job Description:

Job Brief:

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

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 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.