Oracle Business Intelligence Consultant

Job Title Oracle BI Senior ERP Specialist / Contractor / Associate Experience Required: 12+ Years Job Summary The Senior ERP Specialist with expertise in Oracle BI will be responsible for designing, developing, implementing, and maintaining ERP solutions, with a strong focus on Oracle Business Intelligence. This role involves optimizing data models, enhancing reporting capabilities, and ensuring the ERP system efficiently meets organizational business requirements. Key Responsibilities • Designing and implementing Oracle BI solutions within the ERP system • Developing and maintaining data models to support BI reporting • Optimizing BI dashboards and reports for performance and usability • Collaborating with cross-functional teams to gather requirements for BI solutions • Providing technical support and troubleshooting for BI tools and applications • Ensuring data accuracy and integrity within the ERP system • Keeping abreast of industry trends and best practices in Oracle BI to recommend improvements Skill Requirements • In-depth knowledge of Oracle Business Intelligence tools and technologies • Proficiency in Oracle ERP systems and modules • Strong understanding of data warehousing concepts and methodologies • Experience in designing and optimizing data models for BI reporting • Ability to collaborate effectively with different teams and stakeholders • Strong analytical mindset with problem-solving skills • Excellent communication and presentation abilities Certifications • Oracle BI certification is preferred but not mandatory Additional Requirements Primary Skill: OBIEE Senior Profile with exposure to SAP • In-depth understanding of SAP modules: SD, MM, FI, CO, PS • Good understanding of end-to-end business processes: • O2C (Order to Cash) • P2P (Procure to Pay) • PL2PRC2R (Plan to Produce to Record to Report) • Strong knowledge of S/4HANA tables and reports related to these processes • Ability to understand S/4 system customizations including custom tables, CDS views, and reports • Strong understanding of data structures, data analysis, and data reconciliation methods in S/4 systems Requirements Gathering & BI Expertise • Experience working with business stakeholders to gather reporting requirements and translate them into technical specifications • Experience with Oracle Analytics Server (OAS) and DV (Data Visualization) • Ability to handle complex business logic • Experience in Data Warehouse integration with ETL knowledge • Ability to resolve data discrepancies by tracing through ETL and source systems • Experience in end-to-end BI processes from source system analysis to OBIEE deployment, including data reconciliation and validation OBIEE Technical Expertise • Designing, developing, and maintaining BI solutions using Oracle Business Intelligence Enterprise Edition (OBIEE) • Proficiency in writing SQL queries for data extraction and manipulation • Strong analytical and problem-solving skills for data-related issues • Experience in OBIEE RPD modeling and designing Star and Snowflake schemas • Thorough understanding of OBIEE architecture and components, including: • Analytic Server • Web Server • RPD • Web Catalog • Security • Dashboards • Reports • iBots • Scheduler Advanced Oracle & OBIEE Capabilities • Experience in writing and profiling complex PL/SQL queries to efficiently retrieve data from large Oracle datasets • Expertise in OBIEE features including: • Cache • Usage Tracking • Dimensional Hierarchies • Variable Initialization Blocks configuration • Experience in converting Snowflake Schemas to Star Schemas • Strong skills in Dimensional Hierarchies, Dimension Extensions, and Physical & Logical Data Modeling Soft Skills • Strong communication and interpersonal skills • Ability to quickly grasp new technical and business concepts • Flexible and capable of working independently or in a team environment