Minimum Requirements:
· 10+ years of experience in designing and building Business Intelligence platforms
· 10+ years of experience architecting large scale data warehouses using Oracle
· Expert data modeling skills (conceptual, logical and physical model design)
· Product knowledge in Oracle Fusion Analytics (BI Apps) with full implementation and on-going support experience
· Substantial experience in SQL and or PL/SQL
· Strong Object / Relational mapping experience and ETL principles/knowledge
· Analyze current data structures and suggest improvements and optimizations to eliminate inefficiencies
· Experience in designing, building and maintaining BI infrastructure to support business analysis
· Ability to drive architecture of new BI dashboards and reporting requests
· Experienced in managing version/change control and testing strategies and processes
· Experience in Database Administration with Oracle or SQL Server
· Experience with Informatica, ODI or similar ETL tools
· Experience with ERP systems like Oracle EBS or SAP
· Experience with Business Intelligence tools like OBIEE, Hyperion BRIO, Essbase
· Strong communications skills both written and verbal
· Ability to effectively manage multiple projects simultaneously
· Experience working in a global, team oriented, collaborative environment
Description:
Position will be responsible for providing high proficiency in technology scoping, development, risk mitigation (both from a technology and business perspective).
· Participate in the development of product strategy and road map for Client’s Oracle Business Intelligence solutions integrating a number of systems: Oracle Fusion/BI Applications (HR, Order Management & Supply Chain, Procure & Spend, Financial and Service Analytics modules); Oracle PLM Analytics (all modules), Hyperion Planning and Hyperion DRM.
· Work closely with Enterprise Architect to provide expertise in data architecture, which may include elements such as metadata management, business semantics, data modeling and metadata workflow management data schemas.
· Contribute to design and implementation of end-to-end data warehouse and reporting solutions while maintaining an optimal balance for custom build, custom extension and pre-built features of the COTS systems.
· Guide the business intelligence team with best practices for BI and enforce the standards.
· Work with the infrastructure, production operations and DBA team to design and provide highly scalable, performing and highly available business intelligence platform.
· Support Project Managers, Business Analysts, and Developers throughout full project lifecycle
Deep background in RDBMS design and/or architecture.
· Maintain the data model and migration processes during development
· Participate in and support the design and development phases of projects
· Analyze and interpret customer's requirements
· Flag risks and provide feedback to project managers and team leads