Lead AI-Enabled Analytics & Data Architecture

amerivet; San Antonio (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

Amerivet in San Antonio, TX is seeking an AI/Data Solutions Architect to lead scalable analytics, reporting, and AI-enabled solutions across the organization. The role sits at the intersection of AI design, data/BI architecture, and business analytics.

The ideal candidate has hands-on experience with Microsoft Fabric, Power BI, Python, Claude, RAG frameworks, token optimization, and MCP server concepts to move AI-enabled analytics from concept to production.

Qualifications

• 5+ years in data architecture, analytics architecture, BI architecture, AI architecture, or related roles.
• Strong hands-on experience with Power BI, data modeling, semantic models, and dashboard delivery.
• Strong understanding of Microsoft Fabric or modern cloud-based analytics platforms.
• Practical knowledge of AI, LLMs, RAG patterns, and enterprise AI use cases.
• Experience working directly with business stakeholders to define metrics, requirements, and solution architecture.
• Ability to design scalable, governed, and production-ready data and AI solutions.
• Strong analytical thinking, problem-solving, communication, and documentation skills.
• Ability to operate independently and lead solution design from concept to delivery.

Responsibilities

• Design AI-enabled analytics use cases using Claude, OpenAI, Python, and modern LLM frameworks.
• Build or support RAG-based solutions connecting enterprise data to LLM-powered workflows.
• Identify opportunities where AI can improve analytics, reporting, automation, and decision intelligence.
• Apply best practices for prompt engineering, context management, model selection, token optimization, and cost control.
• Define scalable, secure, governed, production-ready AI solution patterns.
• Support AI governance practices including responsible usage, data privacy, access controls, auditability, and documentation.
• Support architecture and implementation of MCP server-based integrations.
• Help design AI agents and assistant workflows that securely interact with enterprise tools and data sources.
• Collaborate with engineering to define tool access, retrieval logic, and integration standards.
• Design scalable data, BI, and analytics architecture using Microsoft Fabric, Power BI, and cloud platforms.
• Lead development of semantic models, curated datasets, reporting layers, and enterprise analytical structures.
• Drive Power BI reporting solutions, dashboards, and self-service analytics capabilities.
• Define data modeling, metric standardization, governance, reporting architecture, and BI platform development.
• Translate strategic requirements into scalable data and analytics solutions.
• Support enterprise KPI frameworks, executive dashboards, and reusable reporting patterns.

Skills

Microsoft Fabric

Power BI

Python

Claude

OpenAI

RAG frameworks

Prompt engineering

Token optimization

MCP server concepts

Data modeling

Semantic layer design

Dashboard design

Data governance

API integrations

Analytics architecture

Tools

MCP server concepts

Job description

Amerivet in San Antonio, TX is seeking an AI/Data Solutions Architect to lead scalable analytics, reporting, and AI-enabled solutions across the organization. The role sits at the intersection of AI design, data/BI architecture, and business analytics.

The ideal candidate has hands-on experience with Microsoft Fabric, Power BI, Python, Claude, RAG frameworks, token optimization, and MCP server concepts to move AI-enabled analytics from concept to production.