AI Solutions Analyst

doTERRA International LLC • Pleasant Grove, UT

3d • Onsite

About The Position

The AI Solutions Analyst I helps build, deploy, and continuously improve AI-powered data solutions that enable employees to ask business questions and perform ad hoc analysis using natural language. Working closely with the Data Warehousing team and business stakeholders, this role configures and optimizes AI agents within Snowflake, translates business requirements into effective agent experiences, tests and evaluates agent performance, and improves the quality and usefulness of agent responses over time. This is an early-career technical analytics role at the intersection of data, artificial intelligence, and business enablement. Its primary focus is making enterprise AI agents accurate, useful, reliable, governed, and accessible to business users rather than developing production software or owning core data warehouse models.

Requirements

• Bachelor's degree in Business Analytics, Information Systems, Data Analytics, Computer Science, Finance, Accounting, or another related analytical field.
• Foundational understanding of relational data, databases, metrics, and analytical concepts, with the ability to translate business questions into structured requirements and testable expected outcomes.
• Hands-on experience with generative AI, AI agents, LLM-based workflows, or related technologies through employment, internships, academic work, or substantial personal projects.
• Strong analytical, problem-solving, troubleshooting, and attention-to-detail skills, together with the curiosity to experiment, test, learn, and iterate.
• Strong written and verbal communication skills and the ability to work independently and collaboratively with technical teams, business stakeholders, and end users.

Nice To Haves

• Experience with Snowflake and Snowflake Cortex, including Cortex Agents, Cortex Analyst, Cortex Search, or related capabilities.
• Experience configuring, testing, monitoring, or evaluating AI agents, with familiarity in prompt and instruction design, orchestration, semantic layers or views, or retrieval-based AI systems.
• Working knowledge of SQL and relational databases; familiarity with tools such as Python, Git, or VS Code is a plus.
• Experience with business intelligence or data visualization tools such as Tableau or Power BI.
• Experience designing evaluations or testing the accuracy and reliability of AI-generated results.

Responsibilities

• Build and configure internal AI agents that help employees interact with approved enterprise data through natural language.
• Define and refine agent instructions, context, tools, workflows, guardrails, and expected response behaviors.
• Configure agents to use approved Snowflake data assets, Cortex Analyst semantic views, and other governed resources as appropriate.
• Create and maintain evaluation sets that include representative questions, expected outcomes, edge cases, and known limitations.
• Diagnose inaccurate, incomplete, unsupported, or inconsistent responses and iterate on configurations to improve results.
• Evaluate emerging Snowflake AI and agent capabilities and recommend where they can strengthen doTERRA's internal AI ecosystem.
• Establish repeatable methods for evaluating response correctness, relevance, groundedness, consistency, reliability, and usability.
• Review agent interactions, evaluation results, and user feedback to identify recurring failure patterns and improvement opportunities.
• Test and document changes to instructions, tools, and configurations before broader deployment.
• Partner with Data Warehousing team members when agent performance reveals gaps in source data, business definitions, semantic resources, or access patterns.
• Help develop standards, documentation, and lifecycle practices for creating, releasing, monitoring, and maintaining enterprise AI agents.
• Follow applicable data governance, security, privacy, and responsible AI requirements, escalating risks or control gaps when identified.
• Meet with business leaders and end users to understand common questions, workflows, terminology, metrics, and decision-making needs.
• Translate business requirements into clear agent use cases, acceptance criteria, representative questions, and expected behaviors.
• Identify which questions and workflows are appropriate for AI-enabled self-service analytics and clarify boundaries for out-of-scope or higher-risk requests.
• Work with technical partners to confirm that required data is available, governed, defined consistently, and structured for the intended use case.
• Validate solutions with business stakeholders and incorporate their feedback into prioritized improvements.
• Support the rollout of AI agents across business functions through pilots, demonstrations, training, and practical usage guidance.
• Help users learn how to ask effective questions, interpret results, and recognize when additional validation is needed.
• Document agent capabilities, limitations, intended use cases, data coverage, and known behaviors in clear language.
• Gather structured feedback, maintain an improvement backlog, track adoption, and identify opportunities to reduce manual analysis or improve access to information.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level