Oracle OAC , Power BI Architect- mumbai - 8 + yrs only - Group Manager - RNA

WNS Global Services

Company Description

WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.

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 role—translating 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.

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 teams.Ability to work independently and manage multiple priorities.

Read Full Description
Confirmed 3 hours ago. Posted 2 days ago.

Discover Similar Jobs

Suggested Articles