Artificial Intelligence (AI) Analyst

Factory Motor Parts Co; Eagan (MN); On-site; USD 120,000 - 160,000; Full time

Job summary

Factory Motor Parts Co is seeking an AI/Data Platform Engineer to design, build, and operate end-to-end AI systems. You will implement RAG pipelines on internal documents, create live-data agent workflows, and develop robust ELT processes with dbt models for analytics and AI consumption.

You’ll also deliver production automations with n8n, establish evaluation frameworks, and collaborate with cross‑functional teams to translate business problems into trustworthy AI solutions that drive daily

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

Responsibilities

• Design, build, and maintain RAG pipelines over internal documents—chunking, embeddings, indexing, and hybrid retrieval
• Develop agent workflows and MCP tools for AI-governed, secure access to live business data
• Build and maintain ELT pipelines and dbt models for analytics and AI consumption
• Build production automations (n8n) connecting AI output to daily processes
• Create evaluation frameworks, monitoring, and cost controls to keep outputs trustworthy
• Partner with Merchandising, Pricing, Finance, Operations, HR, and Legal to translate business problems into working AI tools

Skills

Python

SQL

LLM APIs

REST APIs

Data modeling

Software testing

Code review

Communication

Education

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

Tools

Pinecone

Weaviate

Qdrant

dbt

n8n

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 RESPONSIBILITIES

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