If you have what it takes to become part of the Vistra family and would like to start a promising career with a global leader, take a look at the exciting employment opportunities that are currently available and apply online.

Job Summary

The BI Retail team is building Retail AskBI Agent, a Generative BI platform that empowers business users to query enterprise data using natural language, automatically generating SQL, interactive visualizations, and executive-ready insights without needing to write code. The intern will contribute to the continued development and expansion of the AskBI platform, working on real-world business problems across Vistra's retail energy portfolio. This is a hands-on role that blends data engineering, AI/LLM integration, and retail energy business analysis.

Job Description

Responsibility

Description

Data Modeling & Semantic Layer Development

Design and enrich Snowflake-based semantic schemas that power natural language querying across retail KPIs such as customer counts, sales forecasts, and margin performance. Document business logic, metric definitions, and data lineage to ensure AI agents can accurately interpret and query the data.

Prompt Engineering & AI Agent Tuning

Craft and refine system prompts and contextual instructions that guide LLMs to generate accurate SQL and business narratives. Evaluate query accuracy across retail KPIs, identify failure patterns, and build a test harness of 50+ validated question-answer pairs.

Visualization & Insight Automation

Build reusable ECharts-based visualization templates that auto-render from queried datasets, including bar charts, line charts, and heatmaps. Explore diagram generation for process documentation and design executive-ready chart formatting standards.

Snowflake Cortex AI Agent Development

Build a native Snowflake Cortex AI agent that mirrors the AskBI capabilities currently deployed in Odin, leveraging the same underlying data sources and semantic models. Benchmark accuracy, latency, and user experience between the Odin-based and Snowflake-native agents to inform platform strategy, and document a reusable deployment playbook.

Automated Report Generation & Email Distribution

Identify and catalog existing manual email-based reports across the Retail organization, mapping their content, recipients, frequency, and data sources. Design and implement a repeatable process to replicate these reports as Odin-generated outputs with automated email distribution, and document an end-to-end migration playbook for future onboarding.

User Experience & Adoption

Participate in user feedback sessions to iterate on the conversational UX. Create onboarding materials, use-case guides, and demo scripts to drive platform adoption across the Retail organization.

What the Intern Will Learn

·        How Generative AI is applied to enterprise BI at scale

·        End-to-end data pipeline architecture (Snowflake → AI Agent → Visualization)

·        Prompt engineering best practices for structured data querying

·        Snowflake Cortex AI: building native AI agents within a cloud data platform

·        Business process automation: converting manual workflows into AI-driven pipelines

·        Platform benchmarking: evaluating multi-platform AI solutions to inform enterprise strategy

·        Retail energy business fundamentals: customer acquisition, margin performance, market dynamics

Project Deliverables

1.      Expanded semantic layer covering at least 2 BI focus areas, generating new knowledge sources each validated through a suite of tested prompts to ensure reliable outputs

2.      Document and execute a repeatable process to convert 3-5 manual email reports into Odin-generated automated distributions with scheduled email delivery

3.      Snowflake Cortex AI Agent: a working native agent connected to the same Retail BI data sources as Odin, with a comparison analysis documenting accuracy, performance, and UX trade-offs

4.      Final presentation to leadership showcasing project outcomes and platform impact

Job Family

General Services

Company

Vistra Retail Operations Company

Locations

Irving, TexasTexas

We are a company of people committed to:  Exceeding Customer Expectations, Great People, Teamwork, Competitive Spirit and Effective Communication.  If this describes you, then apply today!

If you currently work for Vistra or its subsidiaries, please apply via the internal career site.

It is the policy of the Company to comply with all employment laws and to afford equal employment opportunity to individuals in all aspects of employment, including in selection for job opportunities, without regard to race, color, religion, sex, sexual orientation, gender identity, pregnancy, national origin, age, disability, genetic information, military service, protected veteran status, or any other consideration protected by federal, state or local laws.

If you are an individual with a disability and need assistance submitting an application or would like to request an accommodation, please email us at assistance@vistraenergy.com to make a request.