Lead Analytics Engineer, AI Platform

🕒 August 27

🔔 Pennsylvania – Remote

🔔 Pennsylvania – Remote

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 12%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Stream Companies

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1997

📣 Marketing

📱 Media

💼 Consulting

💰 Private Equity Round - Stream Companies on 2019-04

Marketing • Media • Consulting

Stream Companies is a full-service advertising and marketing agency that partners with businesses to drive growth through integrated digital and traditional advertising. Founded in 1996 and headquartered in West Chester, PA, Stream provides performance marketing, creative & content, and technology-driven marketing solutions (including capabilities tied to proprietary/partnered tech like fullthrottle. ai). The firm serves multiple verticals — notably automotive, commerce/retail, healthcare, finance, manufacturing, and home services — and highlights strong client retention and growth metrics on its website.

📋 Description

• Administer Snowflake roles, grants, and objects supporting the AI platform • Navigate the data warehouse effectively across platform work • Own semantic views encoding business definitions and metric grain • Audit, refactor, and rebuild existing data models during the first 60–90 days • Optimize retrieval accuracy through chunk size, document parsing, metadata design, and embedding configuration • Test chunking approaches against dealer paperwork • Own ingestion pipelines for inventory, dealer and OEM feeds, CRM and DMS data, and marketing performance • Monitor data freshness and detect pipeline failures before they affect clients • Reconcile AI outputs against core reporting models • Audit vehicle offers, payment calculations, and incentives to mitigate advertising compliance risk • Expand evaluation test sets and convert output failures into data corrections • Track inference and warehouse cost per dealer • Collaborate with platform, backend, front-end, and central data teams on querying, caching, APIs, schemas, interface rendering, and stale or null values • Serve as the point of contact between product engineering and the data team • Route actionable data defects to the data team • Define acceptance criteria for partner-built work, review deliverables, and operate systems before engagement closure • Convert business questions into data structures within OrangeOS

🎯 Requirements

• Direct experience managing Snowflake RBAC, roles, and grants (not query-only access) • 3+ years building metric layers on cloud data warehouses, including Snowflake semantic views, dbt metrics, LookML, Cube, or similar • Deep SQL expertise • Proven experience maintaining production pipelines, monitoring failures, and inheriting legacy models • Fluent in Python for data manipulation, API integrations, and automation • Hands-on experience with LLM APIs, prompt engineering, tool call integration, and basic retrieval pipelines; independent projects count • Ability to clearly explain AI data behavior to non-technical executives • Preferred: Snowflake Cortex experience, specifically Analyst, Search, or Agents • Preferred: Applied RAG experience, including chunking strategy, embedding selection, and retrieval evaluation • Preferred: SnowPro certification • Preferred: Output quality measurement using golden sets or human review • Preferred: Retail automotive or martech background, particularly dealership data exposure