EY EA_Oracle Analytics Cloud (OAC) – Senior Consultant in Gurgaon, India
EA_Oracle Analytics Cloud (OAC) – Senior Consultant
Requisition # GGN00487
Post Date Jan 27, 2021
We’re looking for Senior Consultant with expertise in Oracle Analytics Cloud to join the EA group of our consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.
We are seeking experienced and motivated Cloud Engineer with a strong track record of business analytics and data warehousing to join our team providing deep technical expertise in Analytics, Business Intelligence, Essbase and Machine Learning across all industry sectors. Our Cloud Engineers work closely with external clients, presales, other architects and internal teams to design, build and enable solutions on different cloud & BI Stacks
This role demands a highly technical, extremely hands-on cloud engineer who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on Oracle Analytics Cloud, ETL & Data Warehouse. The ideal candidate must have a good understanding of the value of data and analytics and proven experience in delivering solutions to different lines of business and technical leadership. From top to bottom approach, the Cloud Engineer will engage with a customer to discover business problems and goals, and develop solutions using different cloud services.
Your key responsibilities
Lead Analytics offerings: Oracle Analytics Cloud, Data Visualization, OBIEE,BI Publisher
Deliver high quality client solutions that meet and exceed client and EY expectations and are delivered on-time and on-budget.
Manage client solution delivery, including defining project approach, leading and motivating project teams, monitoring and managing project risks, managing client and EY key stakeholders, and successfully delivering client solutions.
Identifying new business opportunities, including building strong client relations, understanding client needs and EY solution offerings, communicating client opportunities to EY leadership, and helping develop client opportunities.
Skills and attributes for success
Primary focus on developing customer solutions using Oracles analytics offerings: Oracle Analytics Cloud, Oracle Data Visualization, Fusion Analytics for Warehouse, OBIEE, OBIA, Machine Learning and Autonomous Data warehouse (ADW).
Experience in requirement gathering, solution blueprint, performing fit gap analysis, Business process design.
Experience to translate business analyst requirements into analytics metadata.
Must have extensive hands on/end to end implementation experience using OAC/OBIEE and BI Publisher.
Must possess solid knowledge on OBIEE RPD design, development & deployment
Must have experience in designing customized interactive dashboards and reports in OBIEE using drill down, prompts, filters, and variables.
Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the use experience.
Experience in configuring OBIEE /OACS security (Authentication and Authorization – Object level and Data level security).
Experience in working with session and repository variable and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
Experience on working with report performance optimization.
Experience in developing Dimensional Hierarchies and adding multiple sources to business model objects.
Possess skills to creating and scheduling iBots and Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
Expertise in developing Logical Data Model (Business Model), Metadata and reports including logical columns, aliases, hierarchies, and subject areas.
Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL
Determine requirements for aggregate tables, hierarchies, level-based measures etc
Deep understanding of dimensional data modelling techniques.
Experience on OBIEE rpd deployment and report migration.
To qualify for the role, you must have
Minimum of 2 years of experience in Oracle Analytics Cloud
Minimum of 4 years of consulting experience in OBIEE and Sql.
Overall 6-12 years of industry experiences with sound knowledge of Data warehousing & Data Modelling
Ideally, you’ll also have
Engaging with business partners and IT to understand requirements from various parts of an organization to drive the design, programming execution, and UAT for future state capabilities within the platform.
Working in a fast-paced and dynamic environment while managing multiple projects and strict deadlines
Good understanding of outsourcing and off shoring, building win/win strategies and contracts with suppliers
Knowledge of Other Data Visualization tools like with Power BI & Tableau
Experience with ETL tools such as ODI, Informatica etc
Experience or good knowledge of Oracle Applications – Oracle E-business Suite or Oracle ERP, Oracle HCM (the Oracle cloud SaaS offering) and its connectivity with different data visualization tools
Integration development to/from other systems
What we look for
Consulting experience, including assessments and implementations
Documenting requirements and processes (e.g., process flows)
Working collaboratively in a team environment
Excellent oral and written communication skills
Strong analytical and problem-solving skills
B.E. / Master’s degree required.
What working at EY offers
At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:
Support, coaching and feedback from some of the most engaging colleagues around
Opportunities to develop new skills and progress your career
The freedom and flexibility to handle your role in a way that’s right for you