Acumatica Data Warehousing Specialist ERP

An organization undergoing an Acumatica ERP implementation is seeking a Data Warehousing Specialist to support master data transformation, mapping, and validation activities during the transition from a legacy system to Acumatica. The legacy platform utilizes text‑based item descriptors rather than structured item numbers, creating a complex data normalization requirement. This role will serve as the dedicated resource to manage and execute these data tasks, working closely with the implementation partner and internal stakeholders.

Key ResponsibilitiesLead the conversion of legacy master data from descriptor‑based formats to structured item numbers required by Acumatica.

Develop, document, and execute data mapping, transformation, and validation rules to ensure accuracy and consistency.

Collaborate with internal subject matter experts to understand existing descriptors, item definitions, and business logic.

Coordinate with external implementation partners to ensure timely and accurate data processing and troubleshoot roadblocks.

Maintain an organized inventory of data assets, mapping tables, transformation logic, and reference documentation.

Perform hands-on data cleansing, normalization, and enrichment to prepare data for Acumatica ingestion.

Conduct root-cause analysis on data inaccuracies and develop scalable correction and prevention methods.

Support data testing cycles, including mock conversions, validation scripts, and exception reporting.

Provide ongoing oversight of data structure alignment with ERP design, workflows, and reporting needs.

Serve as the primary point of contact for all data-related tasks within the ERP project.