Senior Airtable Data Operations Architect

Department: Embedded

Location: Culver City, CA, New York, NY, Seattle, Wa

Compensation: $175K – $210K

Employment Type: FullTime

Advanced Systems Group, LLC enables creativity through better technology and operations for media creatives and content owners. From acquisition to delivery, on-premises or in the cloud, ASG ensures our clients’ success through tailored solutions. One of North America’s largest Media and Entertainment Technology and Operations suppliers, we provide engineering services, physical and cloud integration, training, support, and managed services. ASG delivers customized operations and services for all phases of media production, including creative and engineering. Founded in 1997, and providing nationwide services, ASG has teams based in North America, South America, and Europe.

Senior Airtable Data Operations Architect

Advanced 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 Role

You 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 Work

This 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.

Responsibilities

Technical Leadership and Architecture

• Lead the build-out of an enterprise Airtable ecosystem, creating the foundational framework that connects disconnected systems at scale

• Design and govern a multi-layer architecture that includes source tool integrations, centralized data hubs, departmental child bases, and executive output layers serving multiple teams simultaneously

• Develop governed, scalable data models that normalize metadata across Airtable, Smartsheet, and external API sources

• Define and maintain standards for schemas, data agreements, field-level governance, data flow documentation, and SOPs

• Ensure data reliability, consistency, and long-term maintainability across all interconnected bases

Data Governance and Access Control

• Design and enforce a governance framework that controls what data is shared across bases, what stays private within a team, and what is shared with executives

• Build and maintain field-level and base-level permission structures so the right people see the right data

• Maintain a single source of truth for shared fields such as people, titles, statuses, and campaign identifiers across all connected bases

Workflow Intelligence and Automation

• Translate complex, manual, human-driven workflows into structured, repeatable, observable systems

• Build and direct automations that trigger notifications, assign ownership, flag inconsistencies, and surface operational risks without manual intervention

• Architect data movement between systems using AWS S3 and Lambda or a comparable integration platform

• Design logic-based transformations that connect data across internal bases and external API sources

• Build mechanisms to monitor workflow health, detect data staleness, and surface risks in real time

Dashboarding and Visualization

• Design, develop, and maintain Airtable interface dashboards that give real-time visibility into KPI health for creative and business stakeholders

• Build executive-facing views that aggregate data from multiple bases into a single clean visualization without exposing underlying complexity

Cross-Functional Partnership

• Partner with studio operations, production, post, finance, and business stakeholders across multiple teams

• Act as a trusted technical advisor, translating business needs into durable data systems and recommending better approaches when requirements fall short

• Collaborate with analytics and reporting teams to enable downstream insights

Senior-Level Ownership and Influence

• Proactively challenge business requirements and push back to ensure the most efficient architectural outcome rather than simply executing instructions

• Operate independently on complex problems with minimal direction and a high tolerance for ambiguity

• Drive long-term roadmap planning for the operational data ecosystem

• Identify opportunities to simplify tooling, reduce operational friction, and improve data trust

• Provide technical leadership to a small team by assigning and directing build work, reviewing output, and mentoring junior team members, without formal people management duties

Required Experience

• Deep 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 design

• 5+ years of experience designing and operating data structures used for analytics and operational reporting

• Experience working within large enterprise environments where integrations require navigating corporate systems and formal approval processes

• Ability to pivot and architect alternative solutions when a preferred approach is blocked by platform restrictions or organizational constraints

• Experience acting as the sole decision-maker for a technical data system

• Experience providing technical direction and assigning work to team members without formal people management responsibilities

• Strong written communication and documentation skills, with comfort working within a formal written review process where approvals take time

• Proven ability to operate in ambiguous environments, learning unwritten norms and processes through research and by asking the right questions

Preferred Experience

• Media and Entertainment experience (studio, production, or network) for an immediate grasp of industry vernacular

• Advanced SQL, data modeling, and transformation logic

• Experience with cloud-based data platforms and services (data warehouses, object storage, ETL/ELT tools)

• Experience with Tableau or QuickSight dashboards

• Experience building governed datasets used across multiple stakeholder groups

• Experience establishing metadata standards, taxonomies, and workflow governance

Advanced 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.