Oracle Fusion Analytics Warehouse (FAW) and BI Analytics
- IT & E Business Consulting Services Inc
398 Days Ago
60-65 per Hourly
NA
Remote
8-15 Years
Required Skills: Oracle Autonomous Data Warehouse (ADW), Data Modelling, Oracle SQL Developer, Data warehouse
Job Description
Position: Oracle Fusion Analytics Warehouse (FAW) and BI Analytics using Oracle Analytics Cloud (OAC) and Autonomous Data Warehouse (ADW).
Location: 100% Remote with some Travel required
FYI: Candidate will immediately be assigned to below two different projects.
- Fusion Analytics
- Warehouse (FAW) Lead
Job Description:
- A FAW Lead is expected to engage in activities in support of day-to-day project implementation activities.
- The FAW Lead is an experienced consultant who will drive the technical solution design and implementation for Oracle Analytics Warehouse (FAW.
Role & Responsibilities:
- As part of the implementation team, prepare for, facilitate and gain client agreement on integration architecture strategy and data integration strategy.
- Design and implement data models to support clients analytical reporting requirements, reports and dashboards.
- Setup application per client needs to manage their data models and data pipelines.
- Enable FAW to support external data integration with other platforms.
- Perform hands-on delivery of workshops, configuration, and other project tasks as necessary.
- Assist with provisioning FAW, verify FAW pre-requisites, configure and activate pipeline data loads.
- Perform data validation and QA in preparation for UAT.
- Leverage best practices, methodologies, and tools.
- Assist with project timelines for the FAW workstreams, ensuring that all milestones and deadlines are met.
- Identify, manage, and communicate issues and risks, escalating as required to Senior Management.
- Understand client needs and proactively make suggestions that will improve customer satisfaction.
Qualifications and Education Requirements:
- Hands-on and demonstrable experience and knowledge of implementing Fusion Analytics Warehouse (FAW) and BI Analytics using Oracle Analytics Cloud (OAC) and Autonomous Data Warehouse (ADW).
- Experience in Oracle Autonomous Data Warehouse (ADW), Data Modelling, Oracle SQL Developer, Data warehouse concepts and implementation, analytics and advanced analytics concepts and implementation.
- Development experience of custom Data Warehouse projects using ETL tool as ODI/ODI Marketplace on OCI infrastructure.
- Functional understanding of Oracle Applications (HCM, ERP and SCM modules) data models and public view object (PVO) analysis and designing star schema modeling in Data Warehouse.
- Prior Oracle data warehouse experience, ideally with integration to/from Oracle Applications/third-party applications.
- Prior ODI/OBIA experience would be added plus.
- Excellent SQL query and debugging skills.
- Experience working within a consultancy/systems integrator a bonus.
- Ability to service multiple clients and prioritize needs.
- Committed team player who is willing to share, learn and support fellow team members.
- Ability to be proactive and take initiative.
Preferred Skills:
- People skills; effective team player with strong communication (verbal & written) and listening skills.
- Customer-first mindset. Skilled at anticipating customers' needs and the ability to build relationships that enable collaboration among all stakeholders.
- Drive for results; ability to turn a customer from good to great.
- Strong time and resource management skills along with organizational skills; ability to prioritize and quickly respond to customer requests.
- Excellent written and verbal communication skills - is articulate and can communicate succinctly to multiple levels; must be comfortable presenting to large and diverse audiences.
