Senior Analytics Engineer - AI Platform & Data Reliability

Stream Companies; West Chester (Chester County); On-site; USD 140,000 - 180,000; Full time

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

Snowflake Administration

Semantic Modeling

Pipeline Ownership

Python Skills

Applied GenAI Experience

Communication

Job description

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.