Oracle OAC & Power BI Architect
- WNS Holdings
- 8 - 13 years
- Pune
- 14 days ago
- Email to a friend
- Report this job
Job Description
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
Detailed 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.Role & responsibilities
Job Classification
Industry: BPM / BPOFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: BI ArchitectEmployement Type: Full timeContact Details:
Company: WNS HoldingsLocation(s): Pune
Keyskills: Oac UI UX Power BI Oracle EBS Power Query
Similar positions
WNS Holdings
WNS (Holdings) Limited (NYSE: WNS) is a leading global Business Process Management (BPM) company. WNS offers business value to 200+ global clients by combining operational excellence with deep domain expertise in key industry verticals, including Banking and Financial Services, Healthcare, Insurance...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in