Business Intelligence Developer

IBA InfoTech Inc.
St. Louis, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

St. Louis, United States of America

Tech stack

Data analysis
Systems Engineering
Data Governance
Data Warehousing
Oracle Data Service Integrator
Oracle
Oracle Applications
Oracle SQL Developer
Performance Tuning
PL-SQL
SQL Databases
Tableau
Warehouse Management Systems
Ansi Sql
Information Technology
Star Schema
Real Time Data
Vertica
Oracle Erp

Job description

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.

Requirements

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.

Apply for this position