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.