Overview
Skills
Job Details
HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Oracle BI Reporting Specialist in Remote. Below is the detailed job description.
Role: Oracle BI Reporting Specialist
Location: Remote
Job Description
- 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.
2. 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.
- 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