Senior Airtable Data Operations Architect

Senior Airtable Data Operations ArchitectAdvanced Systems Group (ASG) is seeking a Senior Airtable Data Operations Architect to lead the implementation of an enterprise data ecosystem for a major global live-streaming and commerce platform through an embedded engagement. This is a full-time, on-site position, 5 days per week, in the office in Culver City, CA, New York City, or Seattle, WA.Candidates must live within a commutable distance of the work location, and we are not considering relocation at this time. All applicants must have Airtable experience to be considered. Please read the job description carefully before applying.About the RoleYou will operate as a senior technical lead within the Client's live production and business operations environment, turning fragmented workflows and operational data into reliable, scalable systems that drive visibility, accountability, and decision-making. The architecture is designed, the roadmap is approved, and the ecosystem foundation is in place. The heavy build work lies ahead, and you will lead it. This is not a maintenance role.The scope spans multiple departments, numerous bases, and integrations with several external systems, and it will grow as the organization expands. You will lead a small team of embedded team members, set technical direction, and assign build work, without formal people-management responsibilities. You are expected to lead architecture decisions and drive the build forward independently.How We WorkThis is a documentation-driven organization. Work moves through a formal written review before approval and implementation, so clear writing and a structured approach to documentation are central to how you will deliver. The environment is fast-paced and highly collaborative, supporting teams across creative production, monetization, marketing, and real-time audience engagement. You will have room to shape the work, and the people who thrive here are self-directed and curious, learning the organization's norms through research and by asking the right questions.ResponsibilitiesTechnical Leadership and ArchitectureLead the build-out of an enterprise Airtable ecosystem, creating the foundational framework that connects disconnected systems at scaleDesign and govern a multi-layer architecture that includes source tool integrations, centralized data hubs, departmental child bases, and executive output layers serving multiple teams simultaneouslyDevelop governed, scalable data models that normalize metadata across Airtable, Smartsheet, and external API sourcesDefine and maintain standards for schemas, data agreements, field-level governance, data flow documentation, and SOPsEnsure data reliability, consistency, and long-term maintainability across all interconnected basesData Governance and Access ControlDesign and enforce a governance framework that controls what data is shared across bases, what stays private within a team, and what is shared with executivesBuild and maintain field-level and base-level permission structures so the right people see the right dataMaintain a single source of truth for shared fields such as people, titles, statuses, and campaign identifiers across all connected basesWorkflow Intelligence and AutomationTranslate complex, manual, human-driven workflows into structured, repeatable, observable systemsBuild and direct automations that trigger notifications, assign ownership, flag inconsistencies, and surface operational risks without manual interventionArchitect data movement between systems using AWS S3 and Lambda or a comparable integration platformDesign logic-based transformations that connect data across internal bases and external API sourcesBuild mechanisms to monitor workflow health, detect data staleness, and surface risks in real timeDashboarding and VisualizationDesign, develop, and maintain Airtable interface dashboards that give real-time visibility into KPI health for creative and business stakeholdersBuild executive-facing views that aggregate data from multiple bases into a single clean visualization without exposing underlying complexityCross-Functional PartnershipPartner with studio operations, production, post, finance, and business stakeholders across multiple teamsAct as a trusted technical advisor, translating business needs into durable data systems and recommending better approaches when requirements fall shortCollaborate with analytics and reporting teams to enable downstream insightsSenior-Level Ownership and InfluenceProactively challenge business requirements and push back to ensure the most efficient architectural outcome rather than simply executing instructionsOperate independently on complex problems with minimal direction and a high tolerance for ambiguityDrive long-term roadmap planning for the operational data ecosystemIdentify opportunities to simplify tooling, reduce operational friction, and improve data trustProvide technical leadership to a small team by assigning and directing build work, reviewing output, and mentoring junior team members, without formal people management dutiesRequired ExperienceDeep hands-on Airtable experience, including architectural design and structural building of new database systems, complex relational schemas, and multiple bases within large-scale ecosystems (required)Experience building and governing multi-base environments where multiple teams pull from a shared data layer, including field-level and base-level permissions and access controls (required)Experience with AWS S3 and Lambda or a comparable integration platform, architecting connections that move data between systems (required)Experience connecting Airtable to external platforms and data sources via API, including authentication, data mapping, and troubleshooting broken connections (required)Strong scripting and automation skills, with experience writing and directing automations (required)7+ years of experience in data engineering, operations engineering, or workflow systems design5+ years of experience designing and operating data structures used for analytics and operational reportingExperience working within large enterprise environments where integrations require navigating corporate systems and formal approval processesAbility to pivot and architect alternative solutions when a preferred approach is blocked by platform restrictions or organizational constraintsExperience acting as the sole decision-maker for a technical data systemExperience providing technical direction and assigning work to team members without formal people management responsibilitiesStrong written communication and documentation skills, with comfort working within a formal written review process where approvals take timeProven ability to operate in ambiguous environments, learning unwritten norms and processes through research and by asking the right questionsPreferred ExperienceMedia and Entertainment experience (studio, production, or network) for an immediate grasp of industry vernacularAdvanced SQL, data modeling, and transformation logicExperience with cloud-based data platforms and services (data warehouses, object storage, ETL/ELT tools)Experience with Tableau or QuickSight dashboardsExperience building governed datasets used across multiple stakeholder groupsExperience establishing metadata standards, taxonomies, and workflow governanceAdvanced Systems Group LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.