Artificial Intelligence (AI) Analyst

Factory Motor Parts; Eagan, Northern (MN, KY); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision

401K / profit sharing

Paid holidays/vacation/sick time

Life insurance

Job summary

Factory Motor Parts in Minnesota is seeking an AI Analyst who will design, build, and maintain end-to-end AI systems, including retrieval over internal documents, live data access via agents, and automations that push outputs into daily operations.

The role requires hands-on Python/SQL, deep data modeling, and experience with RAG pipelines, embeddings, vector search, and production tooling like n8n. You will collaborate across Finance, Operations, Merchandising, and Legal.

Qualifications

• Bachelor's degree in CS/SE/DS or related field.
• 2+ years hands-on software, data, or AI engineering.
• Strong Python and SQL abilities.
• Experience with LLM APIs, prompts, and structured outputs.
• End-to-end RAG pipeline experience with embeddings and retrieval evaluation.
• Relational data modeling and query performance understanding.
• REST APIs and webhooks integration experience.
• Version control, testing, and code reviews.
• Clear written communication for non-technical stakeholders.

Responsibilities

• Design, build, and maintain RAG pipelines over internal documents - chunking, embedding, indexing, and hybrid retrieval.
• Develop agent workflows and MCP tools for secure access to live business data, including text-to-SQL against analytics warehouse.
• Build and maintain ELT pipelines and dbt models for analytics and AI consumption.
• Build production automations (n8n) that connect AI output to daily processes across finance, operations, sales, and warehouse teams.
• Build evaluation frameworks, monitoring, and cost controls so AI output is trustworthy before it reaches users.
• Partner with Merchandising, Pricing, Finance, Operations, HR, and Legal to turn business problems into working systems.

Skills

Python

SQL

LLM APIs

Prompt design

RAG pipelines

Embeddings

Vector search

REST APIs

Webhooks

Data modeling

Testing

Version control

Documentation

Education

Bachelor's degree in Computer Science, Software Engineering, Data Science, or related field

Tools

Pinecone

Weaviate

Qdrant

LangChain

LangGraph

LlamaIndex

Claude SDK

dbt

n8n

Snowflake

AWS / GCP

Job description

Factory Motor Parts is moving its AI and data platform past reporting and into production systems: retrieval over unstructured company documents, agents that query live business data, and automations that push AI output into daily operations. The AI Analyst builds and supports those systems end to end - retrieval pipelines, the agent and tool layer, the data models underneath them, and the evaluation and monitoring that keep the output trustworthy enough for people to act on.

This is a hands on, build focused role on a small team with wide scope. The right person writes Python and SQL comfortably, thinks clearly about how data is modeled, and iterates fast on systems where correctness matters more than novelty.

KEY RESPONSIBILITES

• Design, build, and maintain RAG pipelines over FMP's internal documents - chunking, embedding, indexing, and hybrid retrieval - and continuously improve retrieval quality against measured baselines
• Develop agent workflows and MCP tools that give AI governed, secure access to live FMP business data, including text-to-SQL against the analytics warehouse
• Build and maintain ELT pipelines and dbt models that land and curate data in FMP's data lake for both analytics and AI consumption
• Build and maintain production automations (n8n) that connect AI output to daily processes across finance, operations, sales, and warehouse teams
• Build evaluation frameworks, monitoring, and cost controls so AI output is measured and trustworthy before it reaches users
• Partner directly with Merchandising, Pricing, Finance, Operations, HR, and Legal to turn business problems into working systems, including teams new to AI tooling

REQUIRED QUALIFICATIONS

• Bachelor's degree in Computer Science, Software Engineering, Data Science, or a related technical field
• 2+ years of hands‑on experience in software, data, or AI engineering
• Strong Python and strong SQL
• Working experience with LLM APIs, prompt design, and structured outputs
• Demonstrated experience building a RAG pipeline end to end, including embeddings, vector search, and retrieval evaluation
• Solid understanding of relational data modeling, joins, and query performance
• Experience integrating systems through REST APIs and webhooks
• Version control and basic software engineering discipline, including code review and testing
• Clear written communication and the ability to explain technical tradeoffs to non‑technical stakeholders

PREFERRED QUALIFICATIONS

• Vector databases such as Pinecone, Weaviate, or Qdrant
• Agent frameworks and orchestration: LangGraph, LangChain, LlamaIndex, or the Claude Agent SDK
• Model Context Protocol (MCP) and tool design for agent access to internal systems
• dbt for transformation, testing, documentation, and lineage
• Cloud data platform experience — Snowflake, AWS, or GCP preferred
• Workflow automation experience, n8n preferred (or Make, Zapier, Airflow)
• LLM evaluation and observability tooling such as RAGAS, Langfuse, or LangSmith

TECHNOLOGY ENVIRONMENT

Claude Enterprise and the Anthropic API, MCP, Python, Firebird SQL, Snowflake, Apache Doris, dbt, n8n, Pinecone, Power BI, Google Workspace, on‑premises Linux infrastructure, and a large purpose-built analytics warehouse spanning sales, product, customer, inventory, fleet, HR, and finance data

WHY THIS ROLE

FMP already runs Claude Enterprise across the organization, a purpose‑built analytics database wired directly to AI through MCP, and a growing portfolio of production automations. This is not a research seat or an indefinite pilot — work reaches real users quickly, ownership is real, and the scope will grow with the person who fills it.

We are an EEOC/AA Employer.

An industry leader, FMP offers well-balanced compensation and benefits programs, which may include medical, dental, vision, life, 401K, profit sharing, paid holidays/vacation/sick time, STD/LTD.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.