Business Architect​/Portland, OR ( Remote

ERP Data / Business Architect

Location – Portland, Oregon State (Preferable) or Remote

The client is in the design phase for the ERP transformation. From the data strategy point of view, the requirement is for a data architect who has some background with ERP systems and who can prepare a blueprint for the data architecture on bringing the ERP related data to the cloud data lake and assess impacts to the current data solutions.

Detailed JD:

• Minimum of 15+ years of technical experience in Oracle ERP (Oracle Cloud/People Soft)
• Experience with preparation of data strategy, migration plan, object dependencies, etc.
• Experience in Oracle Financials Cloud Schema and Data model
• Experience with Master (customer, supplier, COA, etc.) and transaction (GL, PO, AP, etc.) data in Oracle Financials Cloud
• Experience with conducting impact assessment on outbound data payload from Oracle Financials Cloud to data lake
• Experience in creating design document for accommodating changes to the payload
• Experience with optimizing data transfer (Extraction, Cleansing, Transformation, Loading and Validation) from Oracle Financials Cloud to data lake
• Hands on with writing complex SQL
• Excellent oral and written communication skills
• Good understanding of People Soft financial data model
• Experience in data lake architecture