AI Analyst

Young Living Essential Oils•Lehi, UT

1d•Onsite

About The Position

The AI Analyst is primarily responsible for building and operationalizing AI-driven data solutions across the organization. This role combines data analysis and light data engineering to create scalable data products and agentic AI tools leveraging Snowflake and Snowflake Cortex. This position extends beyond traditional reporting. The AI Analyst will work under guidance to architect data models and develop intelligent systems that automate insight generation and data exploration through applied AI.

Requirements

Advanced SQL proficiency, including complex joins, window functions and CTEs.
Python programming skills for data analysis (e.g., pandas).
Hands-on experience with Snowflake or other cloud-based data warehousing architecture.
Solid understanding of data modeling principles (dimensional modeling, normalization).
Experience working with large-scale structured and semi-structured datasets.
Working knowledge of AI/ML concepts.
Bachelor’s degree in Data Science, Computer Science, Information Systems or a related technical field; or equivalent experience.
2–4 years of experience in data analytics, data engineering, applied AI development, or data science.
Demonstrated experience building scalable solutions using SQL and Python.

Nice To Haves

Experience building or deploying solutions using Snowflake Cortex.
Familiarity with orchestration tools (e.g., dbt, Airflow, or similar frameworks).
Experience with data visualization softwares (e.g., Tableau, Power BI, Domo).
Strong analytical and systems-thinking mindset.
Ability to move from ambiguous problem statements to engineered solutions.
Excellent communication skills across technical and business audiences.
High ownership mindset with the ability to manage complex technical initiatives independently.

Responsibilities

Build and optimize scalable data models in Snowflake using advanced SQL techniques.
Implement data validation, monitoring, and governance standards to ensure data integrity.
Translate complex business problems into analytical frameworks and engineered AI solutions.
Perform data analysis, including segmentation, forecasting, statistical modeling, and experimentation.
Develop Python-based analytical workflows within Snowflake environments.
Support the development and deployment of agentic AI tools using Snowflake Cortex, including: LLM-powered data exploration agents Automated insight generation pipelines
Integrate Cortex capabilities with structured enterprise data to create intelligent, scalable solutions.
Partner with stakeholders to identify high-impact analytics and AI opportunities.
Translate business objectives into scalable technical solutions.
Serve as a subject matter resource for Snowflake Cortex capabilities.