GenBI Intern

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

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 convert3-5 manual email reportsinto 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

Company

Locations

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 usmake a request.