GenBI Intern at Vistra Corp. in Irving, TX

Summary: Vistra Corp. is a global leader in the energy sector, and they are seeking a GenBI Intern to contribute to the development of a Generative BI platform. The intern will work on data modeling, AI agent tuning, and automation of business insights within the retail energy portfolio. Responsibilities: - 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 - 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 - 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 - 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 - 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 - 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 Required Qualifications: - Contribute to the continued development and expansion of the AskBI platform - Work on real-world business problems across Vistra's retail energy portfolio - Design and enrich Snowflake-based semantic schemas that power natural language querying across retail KPIs - Document business logic, metric definitions, and data lineage - Craft and refine system prompts and contextual instructions for LLMs - Evaluate query accuracy across retail KPIs and identify failure patterns - Build reusable ECharts-based visualization templates - Explore diagram generation for process documentation - Build a native Snowflake Cortex AI agent that mirrors AskBI capabilities - Benchmark accuracy, latency, and user experience between agents - Identify and catalog existing manual email-based reports - Design and implement a repeatable process to replicate reports as Odin-generated outputs - Participate in user feedback sessions to iterate on the conversational UX - Create onboarding materials, use-case guides, and demo scripts Required Skills: Snowflake, Semantic Layer Development, SQL, Data Modeling, Prompt Engineering, Large Language Models (LLM) Integration, Data Visualization, ECharts, AI Agent Development, Business Intelligence (BI), Retail Energy Domain Knowledge, Automated Report Generation