AI/Data Solutions Architect

Dewittvets; San Antonio, Northern (TX, KY); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

On-site 3 days/week

Medical, dental, vision

401(k) matching

Student loan assistance

Paid time off

Job summary

AmeriVet seeks an AI/Data Solutions Architect to lead scalable analytics and AI-enabled solutions. The role blends AI design, data architecture, BI, and business analytics, requiring hands-on skills with Fabric, Power BI, Python, Claude, and RAG patterns.

You will partner with stakeholders to translate requirements into production-ready AI/analytics solutions while ensuring governance, security, and cost control across enterprise data assets.

Qualifications

• Five-plus years in data, analytics, BI, or AI architecture.
• Hands-on with Power BI, data modeling, and semantic models.
• Experience designing scalable, governed AI and analytics solutions.
• Experience partnering with stakeholders to define metrics and solutions.

Responsibilities

• Design and enable AI-enabled analytics use cases with Claude/OpenAI.
• Build or support RAG-based data-to-workflow integrations.
• Lead governance, cost control, and secure production patterns.
• Collaborate with engineering on tool access and integration standards.
• Create scalable data/BI architectures using Microsoft Fabric and Cloud platforms.

Skills

Microsoft Fabric

Power BI

Python

Claude

OpenAI

Generative AI / LLMs

RAG frameworks

Prompt engineering

Token optimization

MCP server concepts

Data modeling

Semantic layer design

SQL

Dashboard design

KPI development

Data governance

API-based data and AI integrations

Tools

Vector databases

Embeddings

Semantic search

Enterprise knowledge retrieval

Azure AI

Azure OpenAI

Tool calling

Workflow orchestration

Job description

## AI/Data Solutions ArchitectApplylocations: San Antonio, TXtime type: Full timeposted on: Posted Todayjob requisition id: JR108886**Role Summary**Amerivet is looking for a AI/Data Solutions Architect who can lead thedesign of scalable analytics, reporting, and AI-enabled solutions across the organization.This role will sit at the intersection of AI solutions design, data architecture, BI architectureand business analytics.The ideal candidate will have strong hands-on experience with Microsoft Fabric, PowerBI, Python, Claude, RAG frameworks, token optimization, and MCP server concepts.This individual should be able to design modern data and AI solutions, partner withbusiness stakeholders, and help move AI-enabled analytics from concept to production.A Claude certified / Anthropic certification is preferred.**Key Responsibilities**AI Architecture & Enablement• Design and support AI-enabled analytics use cases using Claude, OpenAI, Python,and modern LLM frameworks.• Build or support RAG-based solutions that connect enterprise data,documentation, and business context to LLM-powered workflows.• Identify opportunities where AI can improve analytics, reporting, automation,decision intelligence, and business productivity.• Apply best practices for prompt engineering, context management, modelselection, token optimization, and cost control.• Help define scalable, secure, governed, and production-ready AI solution patterns.• Support AI governance practices including responsible usage, data privacy, accesscontrols, auditability, and documentation.**MCP / Agentic Workflow Support**• Support architecture and implementation of MCP server-based integrationswhere applicable.• Help design AI agents and assistant workflows that can securely interact withenterprise tools, reporting assets, data sources, and documentation.• Collaborate with engineering teams to define tool access, retrieval logic,orchestration patterns, and integration standards.**Data, BI & Analytics Architecture**• Design scalable data, BI, and analytics architecture using Microsoft Fabric, PowerBI, and modern cloud-based data platforms.• Build and guide the development of semantic models, curated datasets, reportinglayers, and enterprise analytical data structures.• Lead the architecture and design of Power BI reporting solutions, dashboards, andself-service analytics capabilities.• Define best practices for data modeling, metric standardization, data governance,reporting architecture, and BI platform development.• Partner with business and technical teams to translate strategic requirements intoscalable data and analytics solutions.• Support enterprise KPI frameworks, executive dashboards, operational reporting,and reusable reporting patterns.**Required Technical Skills**The candidate should have strong working knowledge of the following:• Microsoft Fabric• Power BI• Python• Claude• OpenAI• Generative AI / LLMs• RAG frameworks• Prompt engineering• Token optimization• MCP server concepts• Data modeling and semantic layer design• SQL and analytical data structures• Dashboard design and KPI development• Data governance and reporting standardization• API-based data and AI integrations**Preferred Skills & Certifications**• Claude / Anthropic certification preferred.• Experience building production-grade AI or GenAI solutions.• Experience with vector databases, embeddings, semantic search, and enterpriseknowledge retrieval.• Experience with enterprise AI governance, model evaluation, and cost monitoring.• Experience with Azure AI, Azure OpenAI, or related cloud AI services.• Familiarity with agentic AI frameworks, tool calling, workflow orchestration, and AI-assisted analytics.• Experience supporting executive, finance, operations, clinical, & businessperformance analytics.**Required Qualifications**• 5+ years of experience in data architecture, analytics architecture, BI architecture,AI architecture, or related roles.• Strong hands-on experience with Power BI, data modeling, semantic models, anddashboard delivery.• Strong understanding of Microsoft Fabric or modern cloud-based analyticsplatforms.• 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 documentationskills.• Ability to operate independently and lead solution design from concept to delivery.This role is located in San Antonio, TX and requires the employee to be on-site at our office 3 days a week.At AmeriVet, we’re committed to your growth, development, well-being, and success. We empower team members with the resources, support, and opportunities needed to thrive in their careers and make a lasting impact in our communities.Here’s what you can expect when you join our team:* Tailored development programs, mentorship, and career pathing to help you achieve your unique goals.* Competitive pay, performance bonuses, 401(k) matching, and student loan assistance to foster your financial well-being.* Health, dental, vision, life insurance, and mental health resources to support your overall well-being.* Generous paid time off and holidays, because your personal time matters.* A supportive, collaborative environment where everyone feels a sense of belonging.Please note: Any Benefits listed above apply to full-time employees.At AmeriVet, your unique skills and passion are celebrated, and every team member has the tools to thrive. Our people-focused approach is centered on helping you grow in your career while making a meaningful impact on the communities we serve.At AmeriVet we believe thriving teams build thriving communities. You will have the tools, resources and opportunities to grow your career – no matter where you start.