ERP, Integrations, Business Systems administrator

TITLE: ERP, Integrations, Business Systems administrator FLSA: Exempt, Full Time  Department: IT  Primary Worksite: 6 West Colony Place, Durham, NC  Salary: $105,000-115,000 Supervisory Responsibilities: None Reports to: VP, IT Preference will be given to candidates who currently reside within 50 miles from Durham, North Carolina and can reliably commute to our Durham office. This is not a fully remote position. OCCUPATIONAL SUMMARY: The ERP, Integrations & Business Systems Administrator is responsible for the administration,  optimization, integration, data integrity, reporting, training, and continuous improvement of  Acumatica ERP and other enterprise business systems. The role serves as a subject-matter expert for  ERP configuration, business applications, integrations, data flows, analytics, and user enablement.  This position partners with IT, Finance, Operations, Claims, business-unit leaders, executive leadership,  developers, and external vendors to maintain reliable systems, resolve complex issues, improve  processes, and support data-informed decisions.  RESPONSIBILITIES:  Key Responsibilities  ERP and Business Systems Administration - • Serve as the primary administrator and escalation point for Acumatica ERP and assigned enterprise applications. • Manage users, roles, permissions, configurations, workflows, approval maps, dashboards, inquiries, imports, scheduled tasks, and system settings. • Maintain master data, monitor system processes, troubleshoot transactions, support reconciliations, and protect data integrity. • Coordinate application upgrades, releases, enhancements, and lifecycle activities. • Maintain system inventories, ownership records, dependencies, and configuration documentation. Enterprise Integrations • Administer and monitor integrations between Acumatica and platforms such as Shopify, Stripe, Avalara, FedEx, ShipStation/ShipBlink, Riskonnect/Ventiv, and reporting tools. • Investigate failed, delayed, incomplete, duplicated, or rejected transactions and validate inbound and outbound data. • Document integration architecture, mappings, business rules, schedules, and downstream dependencies. • Coordinate design, testing, deployment, maintenance, and issue resolution with developers and vendors. • Recommend improvements to integration reliability, performance, and scalability. Data, Reporting, Training, and Process Improvement Data Analytics and Business Intelligence • Retrieve, transform, validate, and analyze ERP and integrated-system data using SQL and approved reporting tools. • Analyze financial, operational, claims, customer, inventory, and integration data to identify trends, anomalies, recurring issues, and improvement opportunities. • Develop analytical datasets, KPIs, dashboards, management reports, exception reports, and ad hoc analyses. • Translate complex data into clear, actionable business information and establish consistent metric definitions. Reporting Tools Tools may include SQL Server, SSRS, Acumatica Generic Inquiries and Dashboards, Microsoft Power BI,  Excel, Microsoft Fabric, and other approved analytics platforms. Data Quality and Governance • Monitor data quality and identify duplicate, incomplete, inaccurate, or inconsistent records. • Develop validation, reconciliation, exception-reporting, and data-quality controls. • Investigate discrepancies and document data ownership, mappings, business rules, dictionaries, and critical definitions. • Support data governance, classification, retention, and stewardship initiatives. ERP Training and User Enablement - • Serve as ERP Training Lead and develop role-based curricula, onboarding, refresher, and advanced training. • Create manuals, job aids, quick-reference guides, videos, SOPs, process guides, and knowledgebase articles. • Provide advanced functional support, identify recurring training gaps, and partner with managers to improve adoption and proficiency. • Evaluate training effectiveness and recommend additional support. Process Improvement, Testing, and Change Management • Assess current-state processes, document future-state workflows, and identify manual, redundant, or error-prone work. • Recommend automation, integration, workflow, and system-utilization improvements and measure results. • Develop test cases with the Test Lead and perform system, integration, regression, and user acceptance testing. • Validate data before and after changes, document defects, coordinate resolution, support releases, and maintain change records. Vendor, Stakeholder, and Knowledge Management • Manage vendor support cases, escalations, release reviews, testing, demonstrations, and enhancement planning. • Communicate system impacts to stakeholders and coordinate across IT, business teams, developers, and technology partners. • Maintain approved documentation in SharePoint or Microsoft Teams, including SOPs, system guides, integration maps, functional specifications, test results, and troubleshooting resources. Required and Preferred Qualifications Education and Experience • Bachelor’s degree in Information Systems, Computer Science, Business, Accounting, Data Analytics, or a related field; equivalent education and experience may be considered. • Seven or more years of experience administering, supporting, implementing, or analyzing enterprise business applications. • At least three years of hands-on ERP administration, enterprise integration, or business systems administration experience. • Strong SQL experience, including complex queries, data validation, troubleshooting, and analysis. • Experience with integrations, data interfaces, imports/exports, data mapping, reporting, dashboards, training, data quality, and process improvement. Technical Knowledge Strong knowledge of Acumatica or a comparable ERP; enterprise systems administration; SQL Server;  application integrations; data imports, exports, mapping, and validation; reporting and dashboards;  workflow configuration; business process analysis; Excel; SharePoint; and Microsoft Teams. Preferred Qualifications - • Acumatica or comparable ERP certification and experience administering enterprise integrations. • Experience with Power BI, Microsoft Fabric, Power Automate, Riskonnect/Ventiv, Shopify, Stripe/BigCommerce, Avalara/AvaTax, and shipping platforms. • Knowledge of APIs, JSON, XML, web services, data migration, data cleansing, and ERP implementation or reimplementation. • Experience developing formal ERP training programs; relevant business analysis, project management, or data analytics certification. • Experience in insurance, financial services, nonprofit, healthcare, or another regulated environment. Core Competencies • ERP and business systems expertise, integration management, data analytics, and data integrity. • Clear technical communication, training development, and user support. • Business process knowledge, analytical problem-solving, root-cause analysis, and continuous improvement. • Cross-functional collaboration, stakeholder management, accountability, and ownership. Performance Measures Measures may include ERP and business-system reliability; integration success; reductions in transaction  failures, defects, recurring support issues, and manual work; data, import, report, and dashboard  accuracy; training completion and user adoption; successful upgrades and enhancements;  documentation completeness; process-improvement results; and stakeholder satisfaction. Work Environment This is a hybrid position based in Durham, North Carolina, with regular in-office collaboration. The role  interacts frequently with IT, Finance, Operations, Claims, executive leadership, business managers,  users, developers, vendors, and external technology partners. Occasional after-hours support may be  required for upgrades, releases, critical incidents, data migrations, major integrations, financial  processing periods, and IT project launches.