Business Systems Analyst - Airtable

**Job Posting:** Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers’ complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson, a Fortune 500 company, is proud to provide best-in-class products, service and capabilities across the following industries: Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in. **Job Description: Business Systems Analyst (Airtable)** We are 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. **Location:** This role will be Hybrid in Newport News, VA HQ location. ## **Key Responsibilities:** **Business Analysis & Requirements Gathering** - 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. ## **Airtable Design & Administration** - 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. ## **Process Automation & Integration** - 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. ## **Data Management & Reporting** - 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. ## **User Support & Training** - 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. ## **Project Support** - 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. ## **Preferred Qualifications** - Bachelor's degree in Business, Information Systems, Computer Science, or 3+ years of experience in business analysis, process optimization and advanced Airtable expertise incl…