AI Data Architect

3Pillar

United States

On-site

USD 180,000 - 250,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Disability Insurance

Life Insurance

AD&D Insurance

Unlimited PTO

Paid parental leave

401K

Flexible Work Policy

Paid Holidays

Job summary

3Pillar is seeking an AI Data Architect to design, govern, and evolve the enterprise data platform powering all AI initiatives across the organization. You will own data contracts, architecture, and the end-to-end data stack to support RAG-based applications, dashboards, and autonomous agents.

This role requires deep experience with data lakehouse concepts, data mesh patterns, and event-driven architectures, plus hands-on work with vector stores and LLM-related tooling.

Qualifications

15+ years of hands-on data engineering and architecture experience.

Responsibilities

Architect and own the enterprise AI data platform—the unified, governed layer used by AI systems across the organization.
Design multi-domain data models (lakehouse, data mesh, event-driven) with clean lineage and versioned schemas.
Define tools and technologies to develop automated data pipelines and write ETL processes in Python/Java/Scala.
Own the full data stack: real-time streaming, batch processing, cloud storage and compute, and data quality/metadata management.
Drive modernization of legacy pipelines to cloud-native, AI-ready architectures with cost, latency, and velocity improvements.

Skills

Python

SQL

Data Modeling

Data Governance

Data Architecture

ETL

Real-time Streaming

Security

Access Governance

Vector Stores

RAG

LLMOps

Tools

Databricks

Snowflake

AWS

Kubernetes

Terraform

GitHub Actions

LangChain

LlamaIndex

LLM APIs

Pinecone

FAISS

ChromaDB

OpenSearch

Neo4j

Kafka

Job description

3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology — helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation — doing work that is open, portable, and built to last. We are building the future of enterprise AI.

AI Data Architect

We are looking for an AI Data Architect to design, build, govern, and evolve the single source of truth that powers every AI initiative in our organization.

This platform will serve as the foundational nervous system for conversational AI assistants, dashboard intelligence, autonomous AI agents, RAG-powered applications, predictive ML models, and any AI product we build today or in the future. The resource will architect the system, drive implementation, own the data contracts that agents and AI applications depend on, enforce security and access governance for both human and agent consumers, and continuously monitor and improve the accuracy and reliability of AI outputs that flow from this platform.

Requirements:

Architect and own the enterprise AI data platform — the unified, governed layer that ingests, transforms, stores, and serves all data consumed by AI systems across the organisation.

Design multi-domain data models (lakehouse, data mesh, event-driven) that are structured from day one to serve AI workloads: clean lineage, versioned schemas, well-documented contracts, and low-latency serving APIs.

Strong exposure to different Data architectures, data lake & data warehouse

Define tools & technologies to develop automated data pipelines, write ETL processes, develop dashboard & report and create insights

Responsibilities

Technical Skills
Primary Skills:

Python, SQL, Snowflake/Databricks, AWS (S3, Glue, EKS, Bedrock, Kinesis, Redshift), Docker, Kubernetes, Terraform, GitHub Actions, LangChain, LlamaIndex, LLM APIs (OpenAI, AWS Bedrock, Claude, HuggingFace), (Pinecone, FAISS, ChromaDB, OpenSearch), knowledge graphs (Neo4j).

Secondary Skills: MLflow, FastAPI, CI/CD pipelines, observability tooling (CloudWatch, Grafana, or equivalent), data lineage and metadata management platforms.

15+ years of hands-on data engineering and architecture experience, alongside building production AI/ML and LLM-era data infrastructure.
Strong Experience with either Databricks or Snowflake; experience with both is desirable.
Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures
Expertise in designing and writing ETL processes in Python / Java / Scala
Own the full data stack: real-time streaming (Kafka, Spark Structured Streaming), batch processing (Databricks, PySpark, Delta Lake), cloud storage and compute (AWS, Azure), and data quality /metadata management.
Drive modernisation of legacy pipelines (on-prem ETL, batch DWH) to cloud-native, AI-ready architectures with measurable improvements in cost, latency, and delivery velocity.
Proven experience designing enterprise-scale AI data platforms that serve multiple AI consumers —not just one application or pipeline.
Hands-on experience with vector stores, semantic models, knowledge graphs, and retrieval infrastructure in production environments.
Working knowledge of LLMOps: model serving pipelines, MLflow, CI/CD for AI, automated evaluation, and production monitoring.

AI Experience

RAG, Vector & Retrieval Infrastructure
Design the retrieval infrastructure that powers RAG-based AI applications: embedding pipelines, vector stores (Pinecone, FAISS, ChromaDB, OpenSearch), chunking strategies, and hybrid retrieval layers combining semantic search with structured queries.

Agentic Behaviour Observability & Output Accuracy
Own the observability stack for AI agent behaviour: instrument agents to capture inputs, retrieved context, tool calls, reasoning traces, and outputs — creating a complete audit trail of every agentic action driven by platform data.

Design and operate evaluation frameworks that continuously measure AI output quality: factual accuracy, context faithfulness, retrieval relevance, hallucination rates, and task completion success— across all AI consumers of the platform.

Architecture Standards & Engineering Enablement
Define and maintain the reference architecture for the AI data platform — documenting design patterns, data contracts, integration standards, and decision records (ADRs) that all engineering teams follow.

Establish data engineering standards: pipeline testing frameworks, code review practices, CI/CD automation, infrastructure-as-code (Terraform), reusable component libraries, and observability instrumentation.

Benefits