Oracle OAC & Power BI Architect

Must Have

• Strong expertise in Power BI including data modeling, DAX, Power Query, custom visuals, and embedding. Along with UI UX
• Drive the migration of legacy Oracle Discoverer reports to OAC
• Build enterprise-grade Power BI data models (star/snowflake schemas), custom DAX calculations, and data flows using Power Query
• Design visually engaging and user-centric reports following best UI/UX practices
• 4 years of hands-on experience in Oracle OAC including RPD development
• Deep understanding of Oracle EBS data structures and reporting integration

Good to Have

- SQl

Role Overview

Highly skilled Senior BI Consultant with deep expertise in Oracle Analytics Cloud (OAC), Oracle E-Business Suite (EBS), and Power BI, to support a strategic client engagement. This individual will support the design, development, and delivery of data and reporting solutions leveraging both Oracle and Microsoft BI ecosystems.

The ideal candidate must have hands-on experience with Oracle RPD development, Discoverer report migration, and should be capable of playing a Power BI Solution Architect roletranslating business requirements into scalable and user-friendly BI solutions.

Key Responsibilities

Oracle Analytics (OAC) & Oracle EBS:

• Lead the design, development, and maintenance of interactive dashboards and reports in Oracle OAC, including the use of the Data Visualization (DV) module for self-service analytics and ad hoc reporting.
• Perform advanced development and customization of RPD (Repository) models—Physical, Business, and Presentation layers—ensuring alignment with Oracle EBS schemas and data logic.
• Configure and manage data sources, connection pools, and subject areas to ensure high-performance reporting and secure access.
• Set up and manage Schedulers, Agents, and Jobs in OAC to enable automated delivery of reports and alerts to business users.
• Monitor and troubleshoot scheduled reports and jobs for execution issues, data freshness, and delivery failures.
• Build and maintain datasets within DV and across subject areas to ensure reuse, consistency, and optimized performance.
• Drive the migration of legacy Oracle Discoverer reports to OAC, including analysis, mapping, validation, and performance tuning.
• Work closely with Oracle EBS functional leads to extract meaningful business insights across modules like Financials, Procurement, HR, and SCM.

Power BI Architecture & Development

• Work as the Power BI Solution Architect, leading stakeholder discussions to define KPIs, data flows, and dashboard requirements.
• Translate functional and business needs into technical designs and reporting solutions in Power BI, ensuring accuracy, performance, and usability.
• Build enterprise-grade Power BI data models (star/snowflake schemas), custom DAX calculations, and dataflows using Power Query.
• Design visually engaging and user-centric reports following best UI/UX practices, ensuring clarity and actionable insight for stakeholders.
• Ensure seamless integration with on premise or cloud data sources, and enforce row-level security, data refresh schedules, and version control.

End-to-End BI Project Delivery

• Drive complete BI project lifecycle: requirements gathering, data discovery, architecture, development, UAT, deployment, and hyper-care.
• Collaborate with business users, Oracle functional teams, DBAs, and other BI developers to ensure alignment on data definitions, timelines, and deliverables.
• Proactively monitor performance, usage, and adoption of OAC and Power BI reports and recommend enhancements.
• Maintain documentation of technical architecture, RPD logic, data flows, and report inventory.

Required Skills & Qualifications

• 8+ years of overall BI/DW experience with strong exposure to Oracle and Microsoft ecosystems.
• Minimum 4 years of hands-on experience in Oracle OAC including RPD development.
• Deep understanding of Oracle EBS data structures and reporting integration.
• Proven experience in Oracle Discoverer report migration projects.
• Strong expertise in Power BI including data modeling, DAX, Power Query, custom visuals, and embedding.
• Demonstrated ability to design aesthetically pleasing and highly functional dashboards.
• Experience working in agile environments and collaborating with cross-functional teams.
• Ability to work independently and manage multiple priorities.

  Role & responsibilities