Oracle Cloud Reporting Consultant

This is a fully remote position, open to applicants in India.

📋 Description

• Develop, tailor, and sustain reports utilizing BI Publisher (BIP), OTBI (Oracle Transactional BI), and Smart View.

• Design and create SQL data models employing joins, subqueries, aggregations, and data templates.

• Generate BI Publisher templates in RTF, Excel, and XML formats.

• Create OTBI analyses, dashboards, KPIs, and custom subject areas as necessary.

• Develop ad-hoc queries using Smart View along with financial and management reports.

• Utilize SQL queries for data extraction and manage both logical and physical data layers.

• Oversee report security and role-based access management.

• Configure scheduling and bursting functionalities within BI Publisher.

• Conduct data validation and reconciliation processes.

• Optimize report performance.

• Provide support for enterprise reporting and analytics solutions across Oracle Fusion ERP, HCM, SCM, and EPM applications.

⛳️ Requirements

• Minimum of 4 years of relevant experience.

• Proficient in Oracle Cloud reporting.

• Essential skills: Oracle Cloud Reporting Consultants, BI Publisher, OTBI.

• Preferred skill: Smart View.

• Proficient in SQL, including joins, subqueries, and aggregations.

• Experience with Oracle Fusion applications, such as ERP, HCM, SCM, and EPM.

• Familiarity with BI Publisher templates in RTF, Excel, and XML.

• Understanding of OTBI analyses, dashboards, KPIs, and custom subject areas.

• Knowledge of Smart View and Excel-based reporting.

• Awareness of report security, role-based access, scheduling, bursting, data validation, reconciliation, and performance optimization.

🏝️ Benefits

• Competitive salary and performance-based incentives.

• Comprehensive health, dental, and vision insurance.

• Opportunities for professional development and training.

• Flexible working hours and remote work options.

• Collaborative and inclusive work environment.