What are the responsibilities and job description for the Oracle Analytics Cloud Consultant position at CENTROID?
Location: Troy, MI
Department: Consulting
Type: Full Time
Min. Experience: Experienced
OAC Consultant
Centroid is looking for a Senior Oracle Analytics Cloud Consultant. We are seeking candidates that have expert level experience with OAC and preferably with BI Applications experience as well.
Employment Type: Full time employee or Contract-to-Hire
Location: 100% remote
Oracle Analytics and BI Classic Foundation Experience:
Oracle Database and Data Warehousing Experience:
Oracle BI Applications Experience (preferred):
General Experience:
Centroid is looking for a Senior Oracle Analytics Cloud Consultant. We are seeking candidates that have expert level experience with OAC and preferably with BI Applications experience as well.
Employment Type: Full time employee or Contract-to-Hire
Location: 100% remote
Oracle Analytics and BI Classic Foundation Experience:
- Hands on Experience in Designing and Developing Data Visualizations in OAC
- Experience working with Data Sets, building data flows to combine different sources of data and presenting them to the users via data visualizations.
- Hands on experience in utilizing the different machine learning algorithms for predicting and identifying patterns and “hidden” relationships within the data
- Hands on experience with the BI Classic (aka OBIEE) functionality including designing, developing & deploying RPD, including physical layer, business model and mapping layer, and presentation layers in OAC BI Classic and OAS/OBIEE 12c.
- Hands on experience in developing and deploying Analysis, Dashboards, BI Publisher, and Web Catalog.
- Experience developing complex data models and RTF templates using BI publisher.
- Experience with different migration techniques to promote objects, projects, etc. within different environments.
- Experience with advanced OAC features for performance tuning such as aggregates and cache management.
- Experience modeling and implementing security at object and data levels.
Oracle Database and Data Warehousing Experience:
- Data warehouse design and development experience.
- Excellent command of Data Warehousing, OLAP, and ETL best practices.
- Expertise in understanding Oracle database and OLAP concepts.
- Data modeling expertise with relational, multi-dimensional, and star and snowflake schemas.
- Proficient use of Oracle technologies like materialized views, PL/SQL, & Stored Procedures (triggers, functions).
- RPD Data Modelling
Oracle BI Applications Experience (preferred):
- Experience implementing and extending the Analytics Applications (Financial Analytics, Sales Analytics, Procurement & Spend Analytics, Supply Chain Analytics, Apps Service Analytics.) for Oracle E-Business Suite (EBS).
- Experience developing and extending ETL data mappings in Oracle Data Integrator (ODI) and Informatica.
- Experience with tuning data integration flows to ensure optimum use of resources.
- Experience developing and extending the Oracle Business Analytics Warehouse.
General Experience:
- 3 years of experience in Oracle Analytics Cloud
- 4 years of combined experience in the different releases of OBIEE (Oracle Business Intelligence Suite Enterprise Edition) or Oracle Analytics Server.
- 3 years of Oracle BI Applications experience preferably including ODI
- Bachelor's degree in Computer Science, Business Information Systems, or Computer Information Systems or equivalent required. Master’s degree preferred.
