Lead Analytics Engineer, AI Platform
Stream Companies
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Stream Companies in West Chester, PA, is seeking a Lead Analytics Engineer to own the semantic data layer underpinning our AI platform within OrangeOS. You will ensure data accuracy, reliability, and performance across ingestion, modeling, and retrieval for dealer, OEM, CRM, and marketing feeds.
Role requires Snowflake admin experience, advanced SQL, Python, and GenAI expertise to drive governance, testing, and scalable pipelines.
Qualifications
- Direct experience managing RBAC, roles, and grants in Snowflake.
- 3+ years building metric layers on cloud data warehouses with SQL.
- Proven production pipeline ownership and failure monitoring.
- Fluent Python for data manipulation, APIs, and automation.
- Hands-on experience with LLM APIs, prompt engineering, tool calls.
- Ability to explain AI data behavior to non-technical executives.
Responsibilities
- Own semantic views encoding business meaning: what counts as a sale, what counts as a lead, the grain each metric lives at, etc. An error there produces the same error in every downstream answer
- Audit, refactor, and rebuild existing data models during your first 60-90 days
- Own the ingestion pipelines feeding the platform: inventory, dealer & OEM feeds, CRM & DMS data, and marketing performance
- Monitor freshness and catch failures, so a broken feed reaches you as an alert before it reaches a client as a wrong number in the platform
- Work with platform engineers on how semantic layer output is queried, cached, and surfaced: what the API returns, how a metric renders in the interface, and what the product shows when a value should be labeled and qualified on screen
- Act as the standing point of contact between product engineering and the data team, carrying platform requirements that need warehouse-level work to them and translating their constraints into decisions product can act on
- Route data defects surfaced through the assistant to the data team with enough detail to be actionable, rather than a ticket reporting that the AI was wrong
- Define acceptance criteria with partners and review deliverables against them, and operate the system unassisted before an engagement closes
Skills
Job description
Stream Companies is a full-service, fully integrated advertising agency built for brands that want to move forward. Founded in 1997 and headquartered in Malvern, Pennsylvania, we partner with clients to launch, position, and manage brands through both full-service relationships and project-based work.
We operate with an entrepreneurial mindset- collaborative, curious, and always pushing what's next. By combining strategic planning, creative development, media planning and buying, digital, interactive, television, production, and co-op management with cutting-edge technology, we deliver integrated solutions designed for today’s marketing challenges.
Stream Companies is a full-service marketing agency building software for retail automotive dealerships. We operate an AI assistant built on Snowflake Cortex as part of our OrangeOS product suite.
When our AI assistant returns a wrong answer, the issue is almost always upstream—a frozen dealer feed or a mismatched metric definition. As Lead Analytics Engineer, you will take full ownership of the semantic data layer beneath the AI, ensuring complete data accuracy, pipeline reliability, and platform performance.
- Administer Snowflake roles, grants, and objects supporting the AI platform (warehouse-level decisions remain with the central data team)
- Gain fluency in our warehouse and navigate it effectively across platform work
- Own the semantic views that encode business meaning: what counts as a sale, what counts as a lead, the grain each metric lives at, etc. An error there produces the same error in every downstream answer
- Audit, refactor, and rebuild existing data models during your first 60-90 days
- Own the levers that determine retrieval accuracy: chunk size, document parsing, metadata design, and embedding configuration
- Test chunking approaches against dealer paperwork rather than assuming defaults. Snowflake recommends chunks under 512 tokens as a starting point
- Own the ingestion pipelines feeding the platform: inventory, dealer & OEM feeds, CRM & DMS data, and marketing performance
- Monitor freshness and catch failures, so a broken feed reaches you as an alert before it reaches a client as a wrong number in the platform
- Reconcile AI outputs against core reporting models to guarantee data precision
- Audit vehicle offers, payment calculations, and incentives to mitigate advertising compliance risk
- Expand evaluation test sets, turning output failures into specific data corrections
- Track inference and warehouse cost-per-dealer to ensure feature scalability
- Work with platform engineers on how semantic layer output is queried, cached, and surfaced: what the API returns, how a metric renders in the interface, and what the product shows when a value should be labeled and qualified on screen
- Review schema changes with backend engineers before they ship, and work through with front-end engineers how a number should be labeled and qualified on screen
- Act as the standing point of contact between product engineering and the data team, carrying platform requirements that need warehouse-level work to them and translating their constraints into decisions product can act on
- Route data defects surfaced through the assistant to the data team with enough detail to be actionable, rather than a ticket reporting that the AI was wrong
- Act as our technical counterpart on partner-built work: define the acceptance criteria, review deliverables against them, and operate the system unassisted before an engagement closes
- Ensure all work is easily administered and explainable
- Convert business questions from product and account teams into data structures within OrangeOS
- Track inference and warehouse cost per dealer, which determines whether a feature is viable at scale
- Snowflake Administration: Direct experience managing RBAC, roles, and grants (not query-only access)
- Semantic Modeling: 3+ years building metric layers on cloud data warehouses (Snowflake semantic views, dbt metrics, LookML, Cube, etc.) with deep SQL expertise
- Pipeline Ownership: Proven experience maintaining production pipelines, monitoring failures, and inheriting legacy models
- Python Skills: Fluent in Python for data manipulation, API integrations, and automation
- Applied GenAI Experience: Hands-on experience with LLM APIs, prompt engineering, tool call integration, and basic retrieval pipelines (independent projects count)
- Communication: Ability to clearly explain AI data behavior to non-technical executives
- Snowflake Cortex specifically: Analyst, Search, or Agents
- Applied RAG experience: chunking strategy, embedding selection, retrieval evaluation
- Output quality measurement using golden sets or human review
- Retail automotive or martech background, particularly exposure to dealership data
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
