Oracle BI - BICC/OTBI - Fusion

Role: Oracle BI Reporting Specialist Location : Remote Duration : Contract Job Description: 1. BICC (Business Intelligence Cloud Connector): • Design and manage BICC Data Extract Definitions (DEDs) and subject areas for Fusion ERP/HCM/SCM. • Schedule and automate incremental and full data extracts to Oracle Object Storage or external systems. • Optimize extract performance and troubleshoot failures or data quality issues. • Support integration of extracted data into enterprise data lakes, data warehouses, or reporting platforms. 1. BI Reporting (Oracle Fusion): • Develop interactive reports and dashboards using Oracle Transactional Business Intelligence (OTBI). • Design and deploy pixel-perfect reports using BI Publisher, including bursting and delivery • Understand and model Oracle Fusion subject areas, dimensions, and transactional data flows. • Work closely with business users to gather reporting requirements and translate them into efficient BI solutions. o Ensure all reports meet compliance, audit, and performance standards. 1. Cross-functional Support: • Collaborate with data engineers, architects, and business analysts to deliver end-to-end data solutions. • Provide support and training to business users on reporting tools and data interpretation. • Maintain documentation for data models, extract definitions, and report specifications. • Stay current on Oracle Fusion reporting best practices and new features. Knowledge, Skills and Abilities Experience integrating BICC with cloud data platforms (e.g., Azure, Oracle ADW). • Familiarity with Oracle Analytics Cloud (OAC) or other BI tools like Power BI. • Experience with Oracle Cloud roles, data security, and access controls in reporting. • Oracle certification in Cloud Reporting or Analytics is a plus. • Strong analytical and problem-solving mindset. • Ability to work independently and in a team environment. • Excellent verbal and written communication skills. • Comfortable working in a fast-paced, evolving enterprise environment