Senior Analytics Engineer

Role Overview

Orchard is seeking a Senior Analytics Engineer to rebuild how the business derives answers from its data. The team is transitioning from a sprawling Looker footprint to certified gold-tier models backed by a prose-based semantic layer that enables stakeholders to ask questions in plain language and receive trustworthy results.

Responsibilities

• Own major initiatives on the analytics platform roadmap from scoping through delivery, shaping future roadmap direction with the Director.
• Migrate new data sources from raw ingestion to production gold-tier dbt models that the company can trust.
• Build and maintain the prose semantic layer (markdown documentation for model meaning, metric definitions, historical data decisions, and known pitfalls).
• Build and tune an LLM-powered query layer, including:
  • prompts
  • retrieval
  • evals
  • feedback loops when answers are incorrect
• Stand up and iterate on agent analysts to monitor certified dashboards for anomalies and trend shifts until executives trust and act on alerts.

Requirements

• 4+ years in analytics engineering, data engineering, or a hybrid data role, including ownership of a significant data platform or end-to-end migration.
• Deep fluency in dbt and SQL.
• Strong opinions on grain, testing, and documentation, including the limitations of each.
• Comfort working with Redshift (or similar) data warehouses at scale.
• Experience building useful solutions with LLMs on your own data and the ability to evaluate what works.
• Clear technical writing (able to explain metrics simply for executives).
• Demonstrated ability to own technical decisions and align stakeholders; ability to push back when data cannot support requested metrics.

Nice to Have

• Hands-on experience with retrieval or evals for LLM systems.