GDS Consulting_Oracle Reporting Senior Technical Consultant (Oracle Fusion Analytics Warehouse)

At EY youll have the chance to build a career as unique as you are with the global scale support inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better too. Join us and build an exceptional experience for yourself and a better working world for all.

The opportunity

Were looking for Senior Consultant with expertise in Fusion Data Intelligence (FDI) 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 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 FAW 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 Candidate will engage with a customer to discover business problems and goals and develop solutions using different cloud services.

Your key responsibilities

• Lead Analytics offerings: Fusion Analytics Warehouse Oracle Analytics Cloud OBIEE BI Publisher ODI
• 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

• Deep expertise in Oracle BI & analytics offerings: Fusion Analytics Warehouse (FAW) Oracle Analytics Cloud (OAC) Oracle Data Integrator Market Place(ODICS) Oracle Autonomous Datawarehouse(ADW) BI Publisher Oracle Transactional BI (OTBI) etc.
• Should have hands on Experience Oracle Fusion Analytics warehouse.
• Very good exposure on different data extraction mechanism from Oracle Fusion ERPHCMSCM Oracle CX etc.
• Have good hands on experience in pushing big chunks of data to Oracle Object storage either from on-premise or from different SaaS products.
• Primary focus on developing customer solutions using Oracles analytics offerings: Oracle Analytics Cloud Oracle Data Visualization Oracle Utility Analytcis 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 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 configuringOBIEE/OACS security (Authentication and Authorization Objectlevel 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.
• Experience on ETL tools like Oracle Data Integrator

To qualify for the role you must have

• At least of 2 years of consulting experience in FAW/OBIEE/OACS/ODI and SQL.
• Overall 2 to 7 years of industry experiences with sound knowledge of Data warehousing & Data Modelling
• Experience with reporting and analytics and exposure to ETL and Data Loading
• Cloud experience: Azure GCP and AWS
• Have experience leading a project or a team
• Agile Scrum methodology experience (good-to-have)

Ideally youll 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
• Experience on other Data visualization tools like Power BI or Tableau would be a plus
• 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
• Bachelor or Masters degree required.

What working at EY offers

At EY were dedicated to helping our clients from startups 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 thats right for you

About EY

As a global leader in assurance tax transaction and advisory services were using the finance products expertise and systems weve developed to build a better working world. That starts with a culture that believes in giving you the training opportunities and creative freedom to make things better. Whenever you join however long you stay the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people well make our ambition to be the best employer by 2020 a reality.

If you can confidently demonstrate that you meet the criteria above please contact us as soon as possible.

Join us as we shape the future with confidence.

Apply now!

EY Building a better working world

EY exists to build a better working world helping to create long-term value for clients people and society and build trust in the capital markets.

Enabled by data and technology diverse EY teams in over 150 countries provide trust through assurance and help clients grow transform and operate.

Working across assurance consulting law strategy tax and transactions EY teams ask better questions to find new answers for the complex issues facing our world today.