Requirements/Job Duties:
Analyze business requirements to provide intelligent analytics to efficiently run supply chain business process and warehousing operations and provide accurate real-time data; analyze data model and key data intricacies between Oracle ERP for supply chain modules like Oracle Order Management, Oracle Purchasing, Oracle Inventory and Oracle warehouse management system along with other key applications like Transportation management and Global Trade compliance; design, develop and test supply chain transactional reporting and data set within Oracle database using technologies like Oracle SQL, Oracle PLSQL and IBI as reporting platform; performance tuning to key reporting queries developed in Oracle SQL and Oracle PLSQL to run access key transactional and analytical data in seconds; design, develop and test dimensional model (Star Schema) for supply chain business processes within data warehouse using Oracle ODI to organize data efficiently and make query performant; perform data governance and ensure data quality in data warehouse to ensure data accuracy; design, create, and implement complex data models (including canonical, conceptual, logical, and physical models) to connect multiple tables and data elements to avoid data redundancy; design and develop supply chain data source using columnar database technology Vertica, ANSI SQL and store in data warehouse using Oracle Data Integrator (ODI), use data sources to develop intelligent and analytical dashboard using Tableau to enable business to make key strategic decisions.
Qualifications:
Position requires Master's or equivalent level degree in Industrial and Systems Engineering, Management Information Systems; Computer Information Systems; Computer Science, or closely related field.