Oracle Fusion Analytics Warehouse Consultant

Role: Fusion Analytics Warehouse (FAW) Consultant Experience: 3 - 8 years Locations: Remote Employment Type: Contract As an FAW Associate, you will work with technical and project teams to deliver cutting-edge reporting solutions on Oracle cloud platforms (preferred HCM) Job Description: • Development and maintenance of Oracle Fusion Analytics Warehouse: building data models, reports and dashboards, end user training and support, manage data model, data pipelines, security and perform any customizations. • Lead and own all technical aspects of FAW - HCM implementations and/or customizations including data migrations, data quality, systems integrations, 3rd-party applications, and custom development. • Partnering with Fusion HCM team to build HCM Analytics and provide support on aspects such as data model changes and security configuration. • Managing users, groups, application roles and data access in FAW environment, customizing as per business needs. • Participation in each phase of FAW HCM modules (e.g., requirements gathering, planning-analysis-design, architect-build-deploy, support). • Provide technical leadership, setting best practices (e.g., integration and application development, deployment, testing, iterative refinement). • Define, communicate, and manage a change management (release) process to develop and implement new application/code and updates to existing application/code. • Enable FAW augmentation to support external data integration with other data platforms. • Collaborate with data engineers and ETL developers to design, implement, and optimize data integration processes for loading data from various source systems into the Oracle Fusion Analytics data warehouse. • Design and implement data models and schemas to support analytical reporting requirements. • Implement and enforce security policies, access controls, and data privacy regulations within the Oracle Fusion Analytics data warehouse environment. Monitor user access and permissions to ensure compliance with organizational policies. • Monitor and optimize the performance of the Oracle FAW, including database queries, data pipelines, and system resources. Identify and address performance bottlenecks and optimization opportunities. • Document FAW configurations, processes, and best practices. Provide training and support to end-users and technical teams on FAW administration and usage.