AI Analytics Engineer (Business Analytics) at Airtable · Syracuse-…

Summary: Airtable is the no-code app platform that empowers organizations to transform how work gets done. The AI Analytics Engineer will support Strategic Finance and Accounting teams by building analytics infrastructure and tooling, enabling Finance stakeholders to access and leverage data for informed decision-making. Responsibilities: - Design and maintain trusted data models for core financial metrics including ACV, ARR, billings, revenue recognition, and cost allocation, managing the full lifecycle from prototyping through production - Develop and govern dbt data pipelines, establishing data integrity standards and SLAs that ensure timely and accurate delivery of financial data across Finance and Accounting - Build and optimize dashboards that deliver real-time, self-serve insights across key financial areas including revenue performance, expense tracking, budget variance, and forecasting accuracy - Enable data independence for Finance stakeholders by eliminating reliance on ad-hoc data requests and manual reporting, building scalable self-service datasets in Looker and Omni for the Finance team and broader company - Collaborate with Finance and data partners to establish the AI Business Context layer for financial use cases, translating accounting logic, metric definitions, and business rules into structured formats that AI tools can interpret accurately - Develop tools that enable natural language access to financial data and AI-assisted reporting, empowering non-technical Finance stakeholders to explore insights independently - Design and implement AI-powered workflows that automatically surface patterns, anomalies, and meaningful changes in financial data, delivering insights proactively to stakeholders - Serve as the primary data partner for FP&A, Accounting, and Finance leadership, supporting strategic financial analysis and decision-making aimed at growing the business - Translate complex data insights into clear business recommendations through dashboards, memos, and presentations that drive action - Drive cross-functional adoption of analytics and AI tooling, partnering with Finance stakeholders to onboard users, answer questions, triage issues, and train teams on new capabilities - Develop deep expertise in Airtable’s financial data models, pipelines, and BI tools (dbt, Looker, Omni) within the first six months, becoming the go-to internal expert for Finance data Required Qualifications: - 1–4 years of professional experience - Design and maintain trusted data models for core financial metrics including ACV, ARR, billings, revenue recognition, and cost allocation, managing the full lifecycle from prototyping through production - Develop and govern dbt data pipelines, establishing data integrity standards and SLAs that ensure timely and accurate delivery of financial data across Finance and Accounting - Build and optimize dashboards that deliver real-time, self-serve insights across key financial areas including revenue performance, expense tracking, budget variance, and forecasting accuracy - Enable data independence for Finance stakeholders by eliminating reliance on ad-hoc data requests and manual reporting, building scalable self-service datasets in Looker and Omni for the Finance team and broader company - Collaborate with Finance and data partners to establish the AI Business Context layer for financial use cases, translating accounting logic, metric definitions, and business rules into structured formats that AI tools can interpret accurately - Develop tools that enable natural language access to financial data and AI-assisted reporting, empowering non-technical Finance stakeholders to explore insights independently - Design and implement AI-powered workflows that automatically surface patterns, anomalies, and meaningful changes in financial data, delivering insights proactively to stakeholders - Serve as the primary data partner for FP&A, Accounting, and Finance leadership, supporting strategic financial analysis and decision-making aimed at growing the business - Translate complex data insights into clear business recommendations through dashboards, memos, and presentations that drive action - Drive cross-functional adoption of analytics and AI tooling, partnering with Finance stakeholders to onboard users, answer questions, triage issues, and train teams on new capabilities - Develop deep expertise in Airtable's financial data models, pipelines, and BI tools (dbt, Looker, Omni) within the first six months, becoming the go-to internal expert for Finance data - SQL-proficient and have experience with modern data tools (dbt, Databricks, Snowflake, or similar) - Strong intuition for when data 'looks wrong' and can validate query logic and troubleshoot issues independently - Detail-oriented with financial rigor - A clear communicator and strong writer - Business-minded - Thrives in ambiguity - Not married to legacy tooling Preferred Qualifications: - 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/Claude Code, ChatGPT, or Manus, 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're comfortable picking up new technical skills and exploring unfamiliar domains, especially with AI tooling accelerating what's possible Required Skills: AI tooling, Large Language Models (LLMs), Prompt engineering, SQL, dbt, Databricks, Snowflake, Data modeling, Financial data analysis, Dashboard development, Looker, Omni Benefits: The opportunity to receive benefits, Restricted stock units, Incentive compensation