Data & AI Platform, Intern

About the Role

This is a Summer 2027 internship on Lightmatter's Central Data Platform team. The team provides the Snowflake foundation for engineering, product, and analytics teams. This summer, you will contribute to bringing AI into the platform by developing Cortex Agents for natural language queries, designing semantic views for shared metric definitions, and integrating AI features into existing Snowflake applications. The components developed will be documented and reused across Lightmatter.

Key Responsibilities

• Build and evaluate Cortex Agents that combine Cortex Analyst (structured data) and Cortex Search (documents) to answer engineering and analytics questions in natural language.
• Design semantic views over core data products, defining metrics, dimensions, and relationships for consistent answers from agents and BI tools.
• Integrate AI into applications deployed in Snowflake, such as Streamlit apps, using Cortex AI SQL functions and agents exposed through Snowflake's managed MCP server.
• Set up the AI gateway, observability, and orchestration layer: governed model access, evaluations and tracing, cost and usage monitoring, and scheduled workflows.
• Package work as reusable, documented platform components (templates, Cortex Code skills, runbooks) and demo them to engineering teams.

Requirements & Tech Stack

• Currently enrolled in a Master's program in Computer Science, Data Science, or a related field.
• Interest in data engineering, data platforms, and applied AI.
• Demonstrated interest in building and improving AI-based tools, shown through personal projects, coursework, research, or open-source contributions.
• Preferred Qualifications: Coursework, projects, or internship experience with SQL, Python, and cloud data warehouses (Snowflake preferred).

Hourly Rate in USD: $50 — $55

Candidates should have capacity to comply with the federally mandated requirements of U.S. export control laws.