AI Analytics Engineer (AI & Analytics… at Airtable · Syracuse-…

Summary: Airtable is a no-code app platform empowering organizations to transform their business processes. They are seeking an AI Analytics Engineer to build and maintain the infrastructure for AI-powered analytics, ensuring that the organization can self-serve with confidence. Responsibilities: - Build and maintain context infrastructure: Translate institutional business knowledge into structured formats — business glossaries, DBT model enrichment, semantic layer definitions in Omni Analytics — so that AI tools can answer questions accurately, not just confidently - Design and run evaluation frameworks: Develop predefined test cases, accuracy benchmarks, and validation workflows that measure whether AI-generated insights are trustworthy. Own the feedback loop between eval results and context improvements - Build and orchestrate AI agent systems: Help design, build, and iterate on the agent architectures that power our analytics tools — including prompt pipelines, tool orchestration, query routing logic, and guardrails that determine when AI should answer autonomously vs. escalate for human validation - Experiment and evaluate: Test prompt configurations, agent behaviors, and model outputs across different use cases — using eval results and accuracy metrics to drive continuous improvement - Develop internal AI tooling and workflows: Build tools and automations that improve DS&A's own efficiency — identifying opportunities where AI can accelerate the team's work and executing on them - Build automated insight generation systems: Design and develop AI-powered systems that proactively surface patterns, anomalies, and meaningful changes in business data — delivering the right insights to the right people without waiting to be asked. Think less 'answer questions' and more 'anticipate them.' - Drive cross-functional adoption: Partner with GTM, Product, Finance, and other teams to onboard users, field questions, triage issues, and train stakeholders on how to get the most out of our AI-powered analytics tools - Surface insights from usage patterns: Monitor query logs and user behavior to identify gaps in context coverage, recurring questions that should become standard reporting, and opportunities to expand self-service capabilities Required Qualifications: - 1–4 years of professional experience - Build and maintain context infrastructure: Translate institutional business knowledge into structured formats — business glossaries, DBT model enrichment, semantic layer definitions in Omni Analytics — so that AI tools can answer questions accurately, not just confidently - Design and run evaluation frameworks: Develop predefined test cases, accuracy benchmarks, and validation workflows that measure whether AI-generated insights are trustworthy. Own the feedback loop between eval results and context improvements - Build and orchestrate AI agent systems: Help design, build, and iterate on the agent architectures that power our analytics tools — including prompt pipelines, tool orchestration, query routing logic, and guardrails that determine when AI should answer autonomously vs. escalate for human validation - Experiment and evaluate: Test prompt configurations, agent behaviors, and model outputs across different use cases — using eval results and accuracy metrics to drive continuous improvement - Develop internal AI tooling and workflows: Build tools and automations that improve DS&A's own efficiency — identifying opportunities where AI can accelerate the team's work and executing on them - Build automated insight generation systems: Design and develop AI-powered systems that proactively surface patterns, anomalies, and meaningful changes in business data — delivering the right insights to the right people without waiting to be asked. Think less 'answer questions' and more 'anticipate them.' - Drive cross-functional adoption: Partner with GTM, Product, Finance, and other teams to onboard users, field questions, triage issues, and train stakeholders on how to get the most out of our AI-powered analytics tools - Surface insights from usage patterns: Monitor query logs and user behavior to identify gaps in context coverage, recurring questions that should become standard reporting, and opportunities to expand self-service capabilities - Technically curious and AI-forward: You're energized by LLMs, prompt engineering, and the evolving landscape of AI tooling. You've experimented with tools like Claude, ChatGPT, or Cursor — and you're eager to build systems around them, not just use them - A builder at heart: You have a bias toward making things. Whether it's a prototype, a pipeline, or a quick script to test an idea — you default to building rather than theorizing. You may not have deep software engineering experience, but you're comfortable picking up new technical skills and exploring unfamiliar domains, especially with AI tooling accelerating what's possible - Analytically grounded: You're SQL-proficient and have experience with modern data tools (dbt, Databricks, Snowflake, or similar). You have strong intuition for when data 'looks wrong' and can validate query logic and troubleshoot issues independently - Not married to legacy tooling: You're more interested in what's emerging than what's established. You evaluate tools based on what they enable, not how long they've been around — and you're quick to adopt new approaches when they're better - A clear communicator and strong writer: Context engineering is fundamentally a writing discipline. You can translate complex business logic into precise, structured documentation that both humans and LLMs can interpret - Business-minded: You're genuinely curious about how the business works — how we sell, how customers use the product, what metrics matter and why. You ask 'what decision does this support?' not just 'is the SQL correct?' - Energized by building something new: AI-powered analytics is an emerging discipline — the best practices don't exist yet. You're excited to learn as you go, experiment, iterate, and help shape the playbook rather than follow one - Independent and proactive: You can own workstreams end-to-end — from scoping the problem, to building the solution, to iterating based on feedback. You bring ideas to the table and move things forward without waiting for step-by-step direction - Experience: 2 - 4 years in data-related roles (analytics engineer, data analyst, data scientist, or similar), including experience partnering with business stakeholders - Must-Have Skills: Strong SQL proficiency and experience working with modern data tools (dbt, Databricks, Snowflake, or similar) - Must-Have Skills: Clear, structured writing — can translate complex business logic into documentation that both humans and LLMs can interpret - Must-Have Skills: Hands-on experience with AI tools (Claude, ChatGPT, Cursor, or similar) beyond casual use — has applied them to build or accelerate real work - Must-Have Skills: Cross-functional communication — can partner with non-technical stakeholders to understand needs, triage issues, and drive adoption - Must-Have Skills: Builder mindset — comfortable picking up new technical skills, prototyping solutions, and iterating quickly Preferred Qualifications: - Experience with BI semantic modeling (Looker, Omni Analytics, or similar) - Familiarity with Python and LLM APIs - Experience building evaluation or testing frameworks - Background in context engineering, knowledge management, or technical writing - Experience with agent architectures, prompt engineering, or AI system design - Familiarity with data science and ML concepts (e.g., experimentation, time series analysis, statistical modeling, clustering, anomaly detection) Required Skills: SQL, Modern data tools dbt, Modern data tools Databricks, Modern data tools Snowflake, AI tools Claude, AI tools ChatGPT, AI tools Cursor, Cross-functional communication, Structured writing for business logic, LLMs, BI semantic modeling Looker, BI semantic modeling Omni Analytics, Python, LLM APIs, Evaluation/testing frameworks, Context engineering, Agent architectures, Prompt engineering, AI system design, Data science, machine learning concepts, Builder mindset, Business-mindedness, Independence Benefits: Opportunity to receive benefits, Restricted stock units, May include incentive compensation