Oracle Reporting and Analytics-OBIEE-OAC-FDI-SQL-DW-Senior

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. EY-Consulting Oracle Fusion Analytics Warehouse Senior Consultant The opportunity Were looking for Senior Consultant with expertise in Fusion Data Intelligence (FDI) or OAC/OBIEE 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 Data Intelligence, 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: Oracle Analytics Cloud (OAC), Fusion Data Intelligence (FDI), 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 ERP,HCM,SCM 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 Oracle's 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 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. Experience on ETL tools like Oracle Data Integrator To qualify for the role, you must .