AI Solution Engineer (Agentic & Prompt)

Gigalabs; Lahore; On-site; PKR 2,411,000 - 2,678,000; Full time

Job summary

Gigalabs in Lahore is seeking an experienced backend engineer to build AI-driven APIs and data pipelines. You will implement FastAPI/Flask services, manage PostgreSQL databases, and optimize for performance and reliability.

You'll work with LangChain and OpenAI APIs, design robust prompts, and automate data workflows with n8n, ETL/ELT processes, and vector data techniques for RAG use cases.

Qualifications

• Advanced Python for data manipulation and backend logic.
• Experience building, documenting, and maintaining RESTful APIs with FastAPI and Flask.
• Ability to wrap data models and scripts into deployable microservices.
• Experience constructing LLM pipelines with LangChain, LlamaIndex, or custom scripts.
• Deep familiarity with OpenAI APIs and cost optimization strategies.
• Proven prompt engineering to yield structured JSON outputs from unstructured data.
• Advanced SQL with PostgreSQL and performance tuning; vector data and RAG tooling.
• Data modeling for historical data and LLM interaction logs.
• Strong n8n workflow automation for complex integrations; ETL/ELT pipelines.

Responsibilities

• Develop AI-driven APIs and internal tools using FastAPI that serve data insights.
• Automate business logic with autonomous n8n workflows.
• Ensure data quality for inputs and outputs of LLM pipelines.
• Maintain and optimize PostgreSQL for relational and vector data workloads.

Skills

Python proficiency

API development

Microservices

LLM pipelines

OpenAI API

Prompt engineering

PostgreSQL mastery

Vector data (pgvector)

Data modeling

n8n workflow automation

ETL/ELT with Python

Tools

FastAPI

Flask

LangChain

LlamaIndex

pgvector

Job description

Job Brief:
Employment Type: Full time, Onsite
Timings: 12PM-9PM
Location: Johar Town, G4
Experience: 3+ years
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.