Business Analytics Intern

Req ID: 7013

Department: Sales

Status: Intern , Nonexempt

Location: Napa, California (US-CA)

Workplace Location: On-Site

The Commercial Analytics Intern role supports the Commercial organization by turning business data into meaningful insights that inform sales and brand decisions in a fast‑paced CPG environment. This role fills a critical gap by providing dedicated analytical capacity for exploratory analysis, dashboard development, and data support. The internship focuses on foundational analytics, hands‑on learning, and project ownership within a structured support environment, going beyond observation to deliver tangible outputs. Through this work, the intern contributes to the department’s strategic priorities by strengthening data literacy, enhancing reporting capabilities, and supporting data‑driven decision‑making, while building confidence working with business data, developing practical Power BI and Excel skills, and gaining exposure to how analytics supports commercial strategy.

The following reflects management’s definition of essential functions for this job but does not restrict the tasks that may be assigned. Management may assign or reassign duties and responsibilities to this job at any time due to reasonable accommodation or other reasons.

Analytics Enablement & Exploration

• Test and document Power BI Copilot capabilities, providing feedback on strengths, limitations, and use cases
• Develop process for leveraging Data Agents in Copilot to streamline Out of Stock resolution on Key Chains
• Leverage Copilot & Power BI to optimize new product launches, including category framing, account segmentation, and performance tracking

Power BI & Circana Analysis

• Build and maintain simple Power BI reports and visuals using existing datasets
• Support category, share, and performance reporting using Circana (e.g., category trends, Top‑X account views)

Reporting & Documentation Support

• Create and enhance documentation on core Power BI reports including developing “About” pages, documenting purpose, metrics, filters, and usage guidelines
• Support cleanup and organization of Power BI report files, Data Flows, and Manual Source files, including identifying inactive or duplicate reports
• Assist in improving documentation for internal reporting tools and dashboards

Data Organization & Maintenance

• Support product and account mapping maintenance, including fiscal year updates and general upkeep
• Update Custom Master Data keeping products and account groupings up to date and accurate (MDS, Call Points)
• Help validate data consistency across products, accounts, and reporting views

Required

• Currently pursuing a Bachelor’s degree in Business, Analytics, Finance, Marketing, or a related field
• Strong proficiency in Excel (sorting, formulas, basic analysis)
• Interest in analytics, reporting, and data‑driven decision making
• Strong attention to detail and organization
• Clear written and verbal communication skills

Preferred (Not Required)

• Introductory exposure to Power BI or other data visualization tools
• Experience tracking sales, inventory, or performance data
• Interest in the wine, beverage, or CPG industry

• Curiosity about AI or analytics automation tools (e.g., Copilot)

• Office environment
• Prolonged periods of sitting at a desk and working on a computer
• May be required to work at any of Trinchero’ s locations
• Frequent deadline pressures
• Numerous projects in progress at any given time
• Comply with company safety regulations

Salary Range: $23.00 - $28.00

The starting pay will be based on several factors, including but not limited to experience, training, education, and geographic location.

Trinchero Family Estates provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Trinchero Family Estates complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.