ERP Analytics-OAC and SQL Developer-Senior

EY-Consulting Oracle Analytics Cloud Staff Consultant

The opportunity

We're looking for a Staff Consultant with expertise in BI and ETL tools, especially on tools like OAC/OBIEE/Power BI/ODI/Informatica, to join the EA group of our consulting team. This is a fantastic opportunity to be part of a leading firm while being instrumental in the growth of a new service offering.

We are seeking an experienced and motivated engineer with a strong track record in OAC/OBIEE/Power BI, business analytics, and data warehousing to join our team providing deep technical expertise in Analytics, Business Intelligence, Data Warehouse, ETL, and the power & utility sector. Our engineers work closely with external clients, presales, other architects, and internal teams to design, build, and enable solutions on different analytics solutions.

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, 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, the candidate will engage with a customer to discover business problems and goals, and develop solutions using different cloud services.

Your key responsibilities

• Expertise in Oracle's analytics offerings: Oracle Analytics Cloud, Data Visualization, OBIEE, Fusion Analytics for Warehouse
• Strong design skills in BI and ETL based on various scenarios
• Experience in other BI tools like Power BI or Tableau is preferred
• Have solution design skills to provide expertise and guide customers for specific needs
• Be extremely hands-on with Analytics and Data Warehousing report/solution development
• Deliver PoCs tailored to customers needs
• Run and deliver customer hands-on workshops
• Interact with all roles at the customer, including Executives, Architects, technical staff, and business representatives
• Building effective relationships, customer focus, effective communication, and coaching
• Knowledge on FDI is an advantage
• Have some experience in ETL process and ETL tools like ODI or Informatica

Skills and attributes for success

• Primary focus on developing customer solutions using Oracle's analytics offerings: Oracle Analytics Cloud, Data Visualization, Fusion Analytics for Warehouse, OBIEE, OBIA, etc.
• Experience in other BI tools like Power BI or Tableau is preferred
• Must have extensive hands-on/end-to-end implementation experience using OAC/OBIEE and BI Publisher
• Knowledge in the development of Oracle BI Repository (RPD)
• Experience in configuring OBIEE / OAC security (Authentication and Authorization Object-level and Data-level security) as well as tuning reports
• Experience in working with session and repository variables 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
• Solid knowledge of data extraction using SQL
• Good knowledge of Oracle Applications Oracle E-business Suite or Oracle ERP, Oracle HCM (the Oracle cloud SaaS offering) is preferable
• Deep knowledge of Database, Cloud Concepts, Autonomous Data Warehouse (ADW), Data Integration tools such as ODI, Informatica, etc. is an added advantage

To qualify for the role, you must have

• 3-7 years of Data warehousing and Business Intelligence projects experience
• Having 2-5 years of projects experience on OBIEE/Power BI or any other BI tools
• Having at least 2 years of OAC implementations experience
• Worked on Oracle ERP data

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 offshoring, building win/win strategies and contracts with suppliers
• Experience on other Data visualization tools like Power BI or Tableau would be a plus
• Experience or good knowledge of Oracle Applications such as Oracle CC&B, Oracle MDM, etc.
• 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. / B.Tech / 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

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.