GenBI Intern
TXU Retail Services Company, Irving, TX, United States
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 outputs2.
Document and execute a repeatable process to convert 3-5 manual email reports into Odin-generated automated distributions with scheduled email delivery3.
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-offs4.
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.**Vistra’s hardworking team is committed to its purpose, “lighting up lives, powering a better way forward” and is guided by four core principles: we do business the right way, we work as a team, we compete to win, and we care about our stakeholders, including our customers, our communities where we work and live, our employees, and our investors. Learn more about how Vistra is powering a better way forward at .
#J-18808-Ljbffr
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 outputs2.
Document and execute a repeatable process to convert 3-5 manual email reports into Odin-generated automated distributions with scheduled email delivery3.
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-offs4.
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.**Vistra’s hardworking team is committed to its purpose, “lighting up lives, powering a better way forward” and is guided by four core principles: we do business the right way, we work as a team, we compete to win, and we care about our stakeholders, including our customers, our communities where we work and live, our employees, and our investors. Learn more about how Vistra is powering a better way forward at .
#J-18808-Ljbffr