AES Oracle Oracle Analytics Server (OAS). Senior Associate Operate

Bengaluru - India

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Industry/Sector

Not Applicable

Specialism

Oracle

Management Level

Senior Associate

Job Description & Summary

At PwC our people in business application consulting specialise in consulting services for a variety of business applications helping clients optimise operational efficiency. These individuals analyse client needs implement software solutions and provide training and support for seamless integration and utilisation of business applications enabling clients to achieve their strategic objectives.

Those in Oracle customer at PwC will specialise in providing consulting services for Oracle customer relationship management (CRM) applications. Working in this area you will analyse client requirements implement CRM software solutions and provide training and support for seamless integration and utilisation of Oracle CRM applications. Your work will enable clients to optimise operational efficiency and achieve their strategic objectives.

Focused on relationships you are building meaningful client connections and learning how to manage and inspire others. Navigating increasingly complex situations you are growing your personal brand deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients and to deliver quality. Embracing increased ambiguity you are comfortable when the path forward isnt clear you ask questions and you use these moments as opportunities to grow.

Examples of the skills knowledge and experiences you need to lead and deliver value at this level include but are not limited to:

Respond effectively to the diverse perspectives needs and feelings of others.
Use a broad range of tools methodologies and techniques to generate new ideas and solve problems.
Use critical thinking to break down complex concepts.
Understand the broader objectives of your project or role and how your work fits into the overall strategy.
Develop a deeper understanding of the business context and how it is changing.
Use reflection to develop self awareness enhance strengths and address development areas.
Interpret data to inform insights and recommendations.
Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance) the Firms code of conduct and independence requirements.

Job Title: Oracle Analytics Server (OAS) Specialist

Job Summary

Oracle Analytics Server (OAS) Specialist with 5 years of hands-on experience in designing developing administering and optimizing enterprise BI and analytics solutions. The ideal candidate will have strong expertise in Oracle Analytics Server architecture data modeling dashboard development performance tuning and integration with Oracle and non-Oracle data sources. This role involves close collaboration with business stakeholders data engineers and IT teams to deliver scalable high-performance analytics solutions.

Key Responsibilities

OAS / BI Development

Design develop and maintain Oracle Analytics Server (OAS) solutions including dashboards analyses and reports.
Develop and manage RPD (Repository) models: Physical Business Model & Mapping (BMM) and Presentation layers.
Implement subject areas KPIs prompts filters and interactive dashboards.
Migrate and upgrade solutions from OBIEE to OAS where applicable.

Data Modeling & Integration

Integrate OAS with Oracle Database Exadata Autonomous DB ADW ATP and non-Oracle sources (SQL Server Teradata etc.).
Develop optimized logical and physical data models aligned with business requirements.
Work with ETL teams to ensure accurate consistent and performant data pipelines.

Administration & Performance

Install configure and administer Oracle Analytics Server environments (Dev/Test/Prod).
Perform performance tuning for queries dashboards and RPD models.
Manage security: users roles application roles data-level security and integration with LDAP/SSO.
Monitor system health logs usage tracking and capacity planning.

Reporting & Advanced Analytics

Build pixel-perfect and operational reports using BI Publisher.
Enable advanced analytics features such as data visualization forecasting and trend analysis.
Support ad-hoc analysis and self-service BI capabilities.

Required Skills & Qualifications

Technical Skills

5 years of experience with Oracle BI technologies (Oracle Analytics Server and/or OAC / OBIEE).
Strong expertise in RPD development and complex SQL.
Hands-on experience with Oracle Analytics Server architecture and administration.
Experience with BI Publisher dashboards and analyses.
OBIEE to OAS migration or upgrade experience.
Proficiency in SQL PL/SQL and query optimization.
Knowledge of data warehousing concepts (star/snowflake schemas).
Experience with Unix/Linux WebLogic and basic scripting is a plus.

Professional Skills

Strong troubleshooting and problem-solving skills
Ability to work in production support and on-call environments
Good communication and documentation skills
Ability to work independently and within cross-functional teams

Preferred Qualifications

Graduate ()
Experience with Oracle Analytics Server and/or Oracle Analytics Cloud.
Oracle BI / Analytics certifications.

Experience

510 years of experience in Oracle Analytics server and/or Oracle Analytics Cloud

Travel Requirements

Not Specified

Job Posting End Date

Required Experience:

Senior IC

Industry/SectorNot ApplicableSpecialismOracleManagement LevelSenior AssociateJob Description & SummaryAt PwC our people in business application consulting specialise in consulting services for a variety of business applications helping clients optimise operational efficiency. These individuals analy...