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.

Application Developer-Open Source

Data Scientist

ERP Analytics-OAC and SQL Developer-Senior

IT Executive

ETL/BI Tester QA

Data Analyst

IN-Senior Associate_Power BI Developer _Advisory Corporate _Advisory_Noida