Advanced Systems Group, LLC Logo

Advanced Systems Group, LLC

Senior Airtable Data Operations Architect

Posted 2 Months Ago
Be an Early Applicant
In-Office
Culver City, CA, USA
175K-210K Annually
Senior level
In-Office
Culver City, CA, USA
175K-210K Annually
Senior level
Architect and build unified operational data systems connecting fragmented tools and workflows. Develop governed data models, schemas, transformations, lineage, and dashboards using SQL and cloud platforms. Automate reporting, monitor workflow health, improve data reliability, and support executive decision-making. Partner with production, studio, finance, and business stakeholders to translate operational needs into scalable systems while providing technical leadership, roadmap ownership, and mentorship.
The summary above was generated by AI

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.

Similar Jobs

2 Hours Ago
Hybrid
2 Locations
57K-101K Annually
Junior
57K-101K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Manages routine to moderately complex workers’ compensation claims from investigation through resolution. Evaluates coverage, liability, compensability, damages, and reserves; develops action plans; conducts investigations; negotiates settlements; and coordinates with claimants, policyholders, attorneys, appraisers, and other parties. Requires strong analytical, interpersonal, communication, and negotiation skills, plus a bachelor’s degree or equivalent and one year of claims-handling experience.
2 Hours Ago
Hybrid
15-22 Hourly
Junior
15-22 Hourly
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
Serve as a Coach brand ambassador by delivering personalized luxury retail experiences, building client relationships, styling customers, driving sales, meeting KPIs, and using POS, clienteling, and social selling tools. Support store operations through transactions, inventory processing, replenishment, visual merchandising, stockroom organization, and online pickups. Maintain service standards, collaborate with teammates, participate in training, and work flexible retail schedules.
Top Skills: Clienteling ToolsIpadLaptopMobile PosPosSocial Selling Platforms
15-22 Hourly
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
Supports store sales and operations by welcoming customers, operating POS, handling cash, suggesting products, processing shipments, maintaining stock levels, replenishing merchandise, executing visual merchandising updates, and keeping sales and stockroom areas organized. The role also supports customer service, social media engagement, loss prevention, and brand standards while working flexible retail schedules.
Top Skills: Cash Register SystemsInternetIpadLaptopMobile PosPosWalkie-Talkie

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account