Oracle OAC , Power BI Architect- mumbai - 8 + yrs only - Group Manager - RNA
Oracle OAC , Power BI Architect- mumbai - 8 + yrs only - Group Manager - RNA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Job Alert
You will be updated with latest job alerts via email
Job Description
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) modelsPhysical Business and Presentation layersensuring 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.
Qualifications :
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 to work independently and manage multiple priorities.
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time