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.