Master Data, IT & Compliance (35)
about 21,126 hrs/yr
- Part master governance (Daily / Monthly, about 650 hrs/yr) Data stewards enforce part numbering, description standards, units of measure, and classification codes across the part master, fixing inconsistencies and blocking duplicate parts.
- UOM conversion maintenance (Daily / Monthly, about 650 hrs/yr) Unit of measure conversions, such as purchase unit to stocking unit, are maintained per part or globally in the ERP; a wrong factor causes receiving, costing, and MRP errors.
- Warehouse/bin master maintenance (Daily / Monthly, about 650 hrs/yr) ERP admins create, rename, or retire warehouses and bins when layouts change, setting attributes such as location type, capacity, and allowed transactions.
- Chart of accounts maintenance (Daily / Monthly, about 650 hrs/yr) Finance adds, changes, or deactivates GL accounts and segments when reporting needs change, keeping mappings to financial reports and consolidation current.
- GL control/account mapping (Daily / Monthly, about 650 hrs/yr) Accounting maintains which GL accounts each transaction type posts to, such as inventory, COGS, variances, and AR, by product group, site, or customer class.
- Tax code maintenance (Daily / Monthly, about 650 hrs/yr) Tax staff maintain tax codes, jurisdictions, rates, and exemption rules in the ERP, updating them whenever rates change or the company begins collecting in a new jurisdiction.
- Payment terms maintenance (Daily / Monthly, about 650 hrs/yr) Finance maintains payment terms codes, such as net days and early-payment discounts, and assigns them to customers and suppliers according to contracts and credit policy.
- Price list master maintenance (Daily / Monthly, about 650 hrs/yr) Pricing staff maintain master price lists, price groups, and discount structures that customer-specific lists and quotes draw from, each with effective dates and approvals.
- User access provisioning (Daily / Monthly, about 650 hrs/yr) New users and role changes need ERP accounts and security roles.
- User deprovisioning (Daily / Monthly, about 650 hrs/yr) When employees leave or change jobs, IT removes or reduces ERP and system access promptly based on HR notifications, and documents completion for audit.
- ERP workflow rule maintenance (Daily / Monthly, about 650 hrs/yr) ERP admins maintain approval workflows and business rules, such as PO approval limits or automatic credit holds, updating them when policy or the organization changes.
- EDI map monitoring (Daily / Monthly, about 650 hrs/yr) IT monitors EDI maps and trading partner connections for failures, version changes, and new partner requirements so orders, ASNs, and invoices keep flowing.
- EDI transaction error resolution (Daily / Monthly, about 650 hrs/yr) Failed EDI transactions, such as orders, ASNs, or invoices, are investigated, corrected in the data or mapping, and resent, with the trading partner notified.
- Integration job monitoring (Daily / Monthly, about 650 hrs/yr) IT watches scheduled integration jobs between the ERP and MES, CRM, WMS, and banks, confirming each ran, completed, and moved the expected number of records.
- Data import validation (Daily / Monthly, about 650 hrs/yr) Before mass imports, such as price updates, new parts, or opening balances, staff validate the file for format, required fields, and duplicates, then check the loaded results.
- Mass master-data update (Daily / Monthly, about 650 hrs/yr) Bulk changes to parts, customers, or suppliers, such as lead times or classifications, are prepared in spreadsheets, approved, loaded into the ERP, and verified afterward.
- BI dataset refresh (Daily / Monthly, about 650 hrs/yr) BI datasets that pull from the ERP refresh on a schedule, and analysts check refresh success and data freshness before anyone relies on the reports built on them.
- KPI dashboard refresh (Daily / Monthly, about 650 hrs/yr) Operations and finance dashboards in Power BI or Tableau are refreshed with the latest ERP data and checked for obvious errors before leaders see them.
- Scheduled report distribution (Daily / Monthly, about 650 hrs/yr) Standard reports, such as backlog, shipments, or aging, run on schedule from the ERP and go to recipient lists by email or SharePoint.
- Ad hoc report generation (Daily / Monthly, about 650 hrs/yr) Analysts build one-off reports from ERP data to answer managers' questions, extracting, combining, and formatting the data in Excel or a BI tool.
- SOX/control evidence collection (Daily / Monthly, about 650 hrs/yr) For each key control, finance and IT collect evidence that it operated, such as approvals, reconciliations, and reviews, and store it for internal and external auditors.
- Retention-policy administration (Daily / Monthly, about 650 hrs/yr) Records are kept or destroyed on retention schedules.
- Backup/restore test (Daily / Monthly, about 650 hrs/yr) IT periodically restores ERP and file backups to a test environment to prove the backups work, and records the result, timing, and any problems found.
- Disaster recovery test (Daily / Monthly, about 650 hrs/yr) IT runs a failover or recovery exercise for the ERP and key systems, measures recovery against the agreed objectives, and documents gaps.
- ERP change-request intake (Daily / Monthly, about 650 hrs/yr) Users request ERP changes, such as new fields, reports, or workflows, through tickets; the ERP team logs, clarifies, and prioritizes each request.
- ERP enhancement testing (Daily / Monthly, about 650 hrs/yr) Before an enhancement goes live, testers run scripts in the test environment, record results and defects, and get signoff from the business users who asked for it.
- ERP release/UAT testing (Daily / Monthly, about 650 hrs/yr) For vendor updates or releases, the team runs regression and user acceptance tests across key processes and documents approval to deploy to production.
- Role/security review (Daily / Weekly, about 546 hrs/yr) Periodically, IT and managers review each ERP role's permissions and each user's assigned roles, confirming they are still appropriate, and remove excess access.
- Segregation-of-duties review (Daily / Weekly, about 546 hrs/yr) Compliance checks that no user holds conflicting duties, such as creating suppliers and approving payments, and documents mitigating controls where a conflict must remain.
- Interface reconciliation (Daily / Weekly, about 546 hrs/yr) IT and business users reconcile records between connected systems, such as ERP and MES or CRM, to find records that failed to transfer or now differ.
- Audit log review (Daily / Weekly, about 546 hrs/yr) IT or compliance reviews ERP audit logs for sensitive changes, such as bank details, prices, or permissions, and investigates any entry that was not expected.
- Cybersecurity access review (Daily / Weekly, about 546 hrs/yr) Security reviews privileged and remote access, service accounts, and dormant accounts across systems in the IAM tool, removing access that is no longer needed.
- Master-data quality review (Daily / Weekly, about 546 hrs/yr) Data stewards run periodic checks on master data for missing fields, duplicates, invalid values, and stale records, and assign fixes to the owning department.
- Customer master creation (Per event / project, about 150 hrs/yr) Master data staff create customer records from approved requests, applying naming standards, checking for duplicates, and setting required fields such as tax status, terms, currency, and GL mapping.
- Supplier master creation (Per event / project, about 150 hrs/yr) Master data staff create supplier records from approved onboarding packets, checking for duplicates, validating tax ID and address, and setting payment terms, currency, and 1099 status.