Business Systems Analyst - Airtable
$65,337–$114,444 year
RemoteNewport News, Virginia, United States
Newport News, Virginia, United StatesRemoteFull Time$65,337–$114,444 yearEnterprise
Full TimeEnterprise
Job Summary
Partner with business teams to understand operational challenges, document requirements, and facilitate discovery sessions for vendor-funded marketing processes. Design, build, and maintain Airtable bases, interfaces, and automations while developing scalable data models and integrating systems via APIs. Establish data standards, create dashboards and KPIs, and serve as the primary point of contact for user support and training initiatives. Participate in system enhancements, manage project risks, and ensure data governance across all solutions. This role supports the Category Management and Marketing Operations team at Ferguson, a Fortune 500 distributor serving over 36,000 associates across 1,700 locations.
Required Qualifications
- extensive knowledge of Airtable
- Partner with business stakeholders to design, implement, and optimize solutions that improve operational efficiency, data visibility, and process automation
- Translate business requirements into scalable applications, workflows, integrations, and reporting solutions
- Ensure data quality, governance, and user adoption
- 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
- 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
Desired Qualifications
- 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 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.