Lead Analytics Engineer, AI Platform & Snowflake

Stream-Global-Service; West Chester (Chester County); On-site; USD 150,000 - 210,000; Full time

Job summary

Stream Companies seeks a Lead Analytics Engineer to own the semantic data layer behind the AI assistant in our OrangeOS product suite. You will ensure data accuracy, reliability, and performance across ingestion, modeling, and retrieval for dealership-level insights.

The role requires deep Snowflake expertise, strong SQL, and hands-on GenAI experience, with a focus on governance and scalable data solutions across the marketing tech stack.

Qualifications

• Snowflake RBAC, roles and grants management.
• 3+ years building metric layers on cloud data warehouses with SQL.
• Production pipeline ownership and monitoring.
• Python for data manipulation, API integrations, and automation.
• Hands-on GenAI with LLMs, prompt engineering, tool calls, and retrieval pipelines.
• Ability to explain AI data behavior to non-technical executives.

Responsibilities

• Own semantic layer encodings: what counts as a sale, lead, grain of metrics.
• Audit and refactor data models in first 60–90 days.
• Own retrieval quality: chunking, parsing, metadata design, embedding config.
• Manage ingestion pipelines: inventory, dealer, OEM, CRM, DMS, marketing data.
• Monitor freshness and alert on failures before client impact.
• Collaborate with product Eng to ensure API outputs and UI labeling are accurate.

Skills

Snowflake Administration

Semantic Modeling

Pipeline Ownership

Python Skills

Applied GenAI Experience

Communication

Tools

Snowflake Cortex

dbt metrics

LookML

Cube

Job description

Stream Companies seeks a Lead Analytics Engineer to own the semantic data layer behind the AI assistant in our OrangeOS product suite. You will ensure data accuracy, reliability, and performance across ingestion, modeling, and retrieval for dealership-level insights.

The role requires deep Snowflake expertise, strong SQL, and hands-on GenAI experience, with a focus on governance and scalable data solutions across the marketing tech stack.