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.