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

Summary: Airtable is a no-code app platform that empowers organizations to transform their work processes. The AI Analytics Engineer will support the Strategic Finance and Accounting teams by building analytics infrastructure and tooling that enhances data access and insights for Finance stakeholders. 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 - 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 - Collaborate with Finance and data partners to establish the AI Business Context layer for financial use cases - Develop tools that enable natural language access to financial data and AI-assisted reporting - Design and implement AI-powered workflows that automatically surface patterns, anomalies, and meaningful changes in financial data - Serve as the primary data partner for FP&A, Accounting, and Finance leadership - Translate complex data insights into clear business recommendations through dashboards, memos, and presentations - Drive cross-functional adoption of analytics and AI tooling - Develop deep expertise in Airtable's financial data models, pipelines, and BI tools (dbt, Looker, Omni) within the first six months - Technically curious and AI-forward - A builder at heart - Analytically grounded: SQL-proficient and experience with modern data tools (dbt, Databricks, Snowflake, or similar) - Detail-oriented with financial rigor - A clear communicator and strong writer - Business-minded - Thrives in ambiguity - Not married to legacy tooling Required Skills: SQL, dbt, Databricks, Snowflake, Data Modeling, Data Pipeline Development, Dashboard Development, AI Tooling, Prompt Engineering, Financial Data Analysis, Context Engineering Benefits: The opportunity to receive benefits, Restricted stock units, Incentive compensation