Business Systems Analyst - Airtable

FERGUSON • Newport News, VA

5d • $5,445 - $9,537 • Hybrid

About The Position

Ferguson is seeking a highly skilled and motivated Business Systems Analyst with extensive knowledge of Airtable. The Airtable BSA will serve as one of the primary functional experts and administrators for Airtable, partnering with business stakeholders to design, implement, and optimize solutions that improve operational efficiency, data visibility, and process automation. This role translates business requirements into scalable Airtable applications, workflows, integrations, and reporting solutions while ensuring data quality, governance, and user adoption. This role will be Hybrid in Newport News, VA HQ location.

Requirements

• Extensive knowledge of Airtable.
• Ability to translate business requirements into scalable Airtable applications, workflows, integrations, and reporting solutions.
• Ensuring data quality, governance, and user adoption.
• Experience gathering and documenting business requirements.
• Solid understanding of relational databases and data modeling concepts.
• Experience creating workflows, automations, and reporting solutions.
• Experience writing code and implementing scripting software integrations in Airtable
• Excellent analytical, problem-solving, communication and interpersonal skills
• Project management protocols to include project plan management and risk and dependency identification
• Experience with change management and user adoption initiatives to include training.

Nice To Haves

• Bachelor's degree in Business, Information Systems, Computer Science, or 3+ years of experience in business analysis, process optimization and advanced Airtable expertise including Interfaces, Automations, and API integrations.

Responsibilities

• Partner with business teams to understand operational challenges and document business requirements.
• Facilitate discovery sessions, process mapping workshops, and stakeholder interviews.
• Analyze current-state processes and recommend technology-enabled improvements.
• Create business requirements documents, workflow diagrams, and solution designs.
• Design, build, and maintain Airtable bases, tables, interfaces, automations, and dashboards.
• Develop scalable data models using linked records, lookups, rollups, formulas, and custom views.
• Configure Airtable Interfaces to support various user groups and business processes and manage user permissions, access controls, and governance standards.
• Create and maintain Airtable automations to eliminate manual processes.
• Collaborate with technical teams to integrate Airtable with other business systems using APIs, middleware, or integration platforms.
• Monitor automation performance and solve workflow issues.
• Find opportunities for increased efficiency through automation and digital transformation.
• Establish data standards and ensure data integrity across Airtable solutions.
• Develop reports, dashboards, and KPIs that provide actionable business insights.
• Perform data analysis and recommend process improvements based on trends and metrics.
• Serve as the main point of contact for Airtable-related questions and issue resolution.
• Create user documentation, training materials, operating procedures and provide guidance on Airtable guidelines and governance standards
• Conduct training sessions and support ongoing user adoption initiatives.
• Participate in system enhancement projects, platform implementations and support testing activities including user acceptance testing (UAT).
• Track project achievements, risks, and dependencies.
• Collaborate with multi-functional teams to deliver solutions on schedule.

Benefits

• health, dental, vision, paid time off, life insurance and a 401(k) with a company match
• mental health coverage
• gender affirming and family building benefits
• paid parental leave
• associate discounts
• community involvement opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level