NetSuite Business Systems & Integration Analyst
Posted
Description
NetSuite Business Systems and Integration Analyst
|
Department
|
Information Technology
|
|
Reports to
|
Chief Information Officer
|
|
Business units supported
|
SpectronRx and NukeMed
|
|
Employment type
|
Full-time, exempt
|
|
Location
|
On-site at any of our locations: Indianapolis, IN; South Bend, IN; Bunker Hill, IN; or Danbury, CT.
|
|
Compensation
|
$120,000 - $150,000
|
About the role
SpectronRx is a radiopharmaceutical contract development and manufacturing organization (CDMO). NetSuite is our corporate ERP and the system of record for customer invoicing, inventory and financial reporting. Several of the operational systems that run our business do not connect to NetSuite today, so production, quality and engineering data reaches it through PDFs, files and manual entry. Some of these source systems have no vendor-supported API, so integration paths range from direct database reads and scheduled file transfers to document extraction.
We are creating this role to own those connections. The NetSuite Business Systems and Integration Analyst will be accountable for the architecture, specification and ongoing audit of every integration between NetSuite and our operational systems, building some directly and managing external NetSuite contractors for others. Regardless of who builds, this role owns the design, the acceptance criteria, the documentation and the production monitoring. The role sits between Finance, Operations, Quality, Procurement and our external consulting partners, and is responsible for making sure that every integration does exactly what it was designed to do every day.
Initial integration portfolio
The first priorities for this role are the following integrations. The list will grow as the business adds systems, customers and product lines.
|
Integration
|
Objective
|
|---|---|
|
Pharmacy production to NetSuite billing
|
Capture billing data in a structured form and create invoices in NetSuite automatically on a daily or weekly cycle. The source system has no vendor-supported API; the analyst will need to work with direct database reads, scheduled file exports, or document extraction to capture billing data.
|
|
NukeMed manufactures parts to NetSuite order/build to support MRP
|
An existing third-party conversion tool produces structured output files that are currently entered into NetSuite manually; this role will automate that ingest into NetSuite to support MRP order/build and PO processes. Working with the NukeMed procurement lead.
|
|
QA material Specification check in NetSuite PO process
|
Build an integration so that the presence of a correct Material Specification record check in POs is automatic.
|
Key responsibilities
Integration design and delivery
- You own requirements gathering, integration specifications, field mappings and business rules for every integration.
- You determine the delivery model to build directly when the scope and complexity fit or produce a statement of work with acceptance criteria for external contractors where you will manage their delivery.
- Regardless of who builds, you ensure SpectronRx owns the code, configuration, credentials and documentation.
- Design for real-world cases. Plan for corrections, cancellations, partial fulfillment, credits, rebilling duplicate prevention, and reported processing problems/exceptions.
Integration auditing and deviation management
Every integration this role owns is treated as a controlled process with a defined intended function. The analyst is responsible for continuously confirming that each integration performs as designed, and for catching and correcting any deviation.
- Write a baseline for each integration at go-live that states its intended function, data flows, schedules, volumes, controls and expected outcomes.
- Build and run automated monitoring, alerting and daily reconciliation between source systems and NetSuite (for example, Pharmacy billable batches against NetSuite invoices).
- Detect, log and investigate deviations from intended function, including failed or partial transfers, duplicates, mapping errors, pricing or quantity variances, and unexpected changes after vendor upgrades.
- Drive each deviation to root cause and corrective action, document the resolution, and confirm the fix through retesting.
- Run periodic reviews of every integration, with findings and trends reported to the CIO and the business owners.
- Keep a complete audit trail of integration activity, changes and approvals that supports financial audits and, where applicable, quality and regulatory inspections.
NetSuite business systems center of competence
- Act as the internal NetSuite subject-matter expert for order-to-cash, inventory and procure-to-pay processes as they relate to integrated data.
- Configure the NetSuite records, custom fields, saved searches, workflows and roles that integrations depend on.
- Manage integration credentials and access securely using token-based authentication and least-privilege roles.
- Assess the impact of NetSuite releases and source-system upgrades on each integration before they reach production.
Change control, validation and compliance
- Run every integration change through documented change control: requirements, risk assessment, testing, approval and release.
- Keep patient and other protected health information out of NetSuite and integration logs unless there is a documented business need and the required safeguards are in place.
- Maintain runbooks, data-flow diagrams and support procedures so integrations can be supported without depending on one person.
Vendor and stakeholder management
- Serve as the technical point of contact for NetSuite consultants and line of business application vendors for NetSuite integration matters.
- Hold vendors to agreed scope, quality, documentation and knowledge-transfer commitments.
- Train business users on new or changed integrated processes and explain integration status and issues in plain business language.
Required qualifications
- Bachelor's degree in Information Systems, Computer Science, Accounting Information Systems or a related field, or equivalent experience.
- 6 or more years in business systems or ERP integration roles, including at least 4 years of hands-on NetSuite experience.
- Working knowledge of NetSuite integration methods: SuiteTalk REST and SOAP web services, SuiteScript 2.x (including RESTlets and scheduled or map/reduce scripts), CSV import, saved searches and token-based or OAuth 2.0 authentication.
- Proficiency in SQL and in at least one scripting language such as Python or JavaScript for data extraction, transformation and automation.
- Experience with file-based and on-premises integrations, including scheduled jobs, secure file transfer and reading from on-premises application databases.
- Solid understanding of order-to-cash, inventory and procure-to-pay processes and how they post in an ERP.
- Demonstrated experience building monitoring, reconciliation and exception-handling processes for integrations.
- Clear written documentation skills: specifications, mappings, runbooks and deviation reports.
- Ability to manage external contractors and vendors to defined scope and acceptance criteria.
Preferred qualifications
- Experience in a regulated life sciences, pharmaceutical or medical device environment.
- Exposure to quality management or production batch reporting record systems.
- Familiarity with PLM systems, or with engineering bill-of-materials data flowing into an ERP for the NukeMed line of business.
- Experience with an integration platform such as Celigo, Boomi or Workato.
- Understanding of HIPAA privacy and security requirements for system data flows.
- NetSuite certification (for example, NetSuite Administrator or SuiteCloud Developer).
Success measures
At 90 days, the analyst has documented the current state of the business system’s data flows, produced an integration roadmap with the CIO, and delivered or contracted the first automated integration with an agreed baseline and reconciliation process.
At 12 months, the analyst has delivered pharmacy billing and NukeMed’s manufacturing data flow into NetSuite without manual rekeying. Each production integration has a written baseline, active monitoring, daily reconciliation and a deviation log, and deviations are found by monitoring before they reach customers or the general ledger.
Working relationships
Internally, the role works closely with the CIO, Finance and Accounting, Operations and Production Scheduling, Quality Assurance, Procurement, and the NukeMed business unit. Externally, it works with NetSuite implementation contractors, and business system solution providers.
Skills
Sign in to read and join the discussion.