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 to join our Category Management and Marketing Operations team. The BSA will serve as one of the primary functional experts and administrators for vendor-funded marketing processes built in Airtable. This role partners 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 applications, workflows, integrations, and reporting solutions while ensuring data quality, governance, and user adoption.
Location: This role is approved to be either Remote within the United States or Hybrid for associates in Newport News, VA, in accordance with company policy.
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.
- 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.
- 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.
- Experience gathering and documenting business requirements.
- Solid understanding of relational databases and data modeling concepts and 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.
At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!
#LI-REMOTE
-
Pay Range:
-
Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience.
-
$5,444.76 - $9,537.00-
Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.
-
This role is Bonus or Incentive Plan eligible.
-
Ferguson complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements.
-
The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.
Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.
Equal Employment Opportunity and Reasonable Accommodation Information
Skills Required
- Extensive knowledge and hands-on experience with Airtable (bases, tables, interfaces, automations, dashboards)
- Design, build, and maintain Airtable data models using linked records, lookups, rollups, and formulas
- Configure Airtable Interfaces, manage user permissions, access controls, and governance standards
- Create and maintain Airtable automations and monitor automation performance
- Integrate Airtable with other systems using APIs, middleware, or integration platforms
- Business analysis skills: requirements gathering, process mapping, stakeholder facilitation, and solution design
- Solid understanding of relational databases and data modeling concepts
- Experience writing code and implementing scripting/software integrations in Airtable
- Bachelor's degree in Business, Information Systems, Computer Science OR 3+ years of relevant experience
- Project management, change management, training, and user adoption experience
Ferguson Enterprises Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Ferguson Enterprises and has not been reviewed or approved by Ferguson Enterprises.
-
Healthcare Strength — Health coverage includes multiple medical plan options with HSA availability and a PPO, plus dental, vision, life, disability, mental health, and family-forming and women’s health support. Feedback suggests these offerings add significant perceived value to the overall package.
-
Retirement Support — Retirement programs include a 401(k) with company match and profit-sharing, alongside an employee stock purchase plan and executive deferral options. Feedback suggests these features strengthen long-term financial security.
-
Leave & Time Off Breadth — Time-off provisions are wide-ranging, including vacation, sick, holiday, personal, parental, and paid volunteer time. Feedback suggests generous PTO is a key attraction and complements cash compensation.
Ferguson Enterprises Insights
What We Do
Ferguson plc (NYSE: FERG; LSE: FERG) is a leading North American value-added distributor providing expertise, solutions, and products from infrastructure, plumbing and appliances to HVAC, fire, fabrication and more. We exist to make our customers’ complex projects simple, successful and sustainable. Ferguson Enterprises, LLC is the largest operating subsidiary of Ferguson plc. For more information on Ferguson plc, please visit www.fergusonplc.com.
