Business Intelligence Specialist Oracle

Must Have:

• Multiple years of experience in configuring developing and roll out of Oracle Analytics Cloud features in a large implementation.
• Experience leading Change Management developing and delivering end user engagement deliverables (training courses user guides material) and working with end users to ensure ease of adoption training and transitioning end users to analytics.
• Extensive experience with OAC and features to lead / recommend solutions for multiple stakeholders.

Description

• Multiple years of experience in configuring developing and roll out of Oracle Analytics Cloud features in a large implementation. Experience leading Change Management developing and delivering end user engagement deliverables (training courses user guides material) and working with end users to ensure ease of adoption training and transitioning end users to analytics.

Responsibilities

• Validate business requirements and update functional and technical design documents Implementation of Oracle Analytics Cloud build custom ETL scripts and optimize BI solution for end user functionality.
• Prepare impact assessment documentations and recommended approach for engaging and training end users in adoption of Oracle BI functionality Integration Prepare Implementation plan and effort estimates
• Work with other team members to execute recommended/approved approach
• Complete design documents and assist in testing solution
• Complete knowledge transfer to OPS team
• Update semantic layer modify or build new reports and dashboards and underlying data structures and related components Build test and migrate reports and related objects
• Provide knowledge training to OPS resources that will maintain the solution post go-live
• Complete work and achieve milestones within the assigned deadlines
• Notify the Ministry Client/OPS Organization project manager in writing of any issues or other material concerns related to the Assignment Deliverables as soon as he/she becomes aware of them Submit
• Deliverables for the Ministry Client/OPS Organization approval as they are completed
• Comply with the Ontario Government and the Ministry Client/OPS Organization security procedures and practices
• Comply with the Ontario Government and the Ministry Client/OPS Organization architecture/technology standards and best practices
• Comply with the Ontario Government and the Ministry Client/OPS Organization Conflict of Interest and Confidentiality Guidelines
• Provide knowledge and skill transfer to a designated Ministry Client/OPS Organization staff; and Comply with the Ontario Government I&IT Directive Operational Policy on the I&IT Project Gateway Process and other applicable Guidelines Standards and Procedures

Experience and Skill Set Requirements

Desirable / Required Skills - 60%

• Experience with conducting workshops and requirements-gathering sessions with clients on planning budgeting and forecasting initiatives
• Experience with OBIEE OAS OAC ODI SQL APEX and related object design build and implementation
• Experience in building BI and Analytics applications optimized for high-performance high-volume reporting and analytics functions on premise and cloud
• Experience with data integration data cleansing and integration with OBIEE Skilled in Software Development Life cycle and can apply in understanding building and maintaining custom solutions In-depth experience in providing and documenting impact assessment for application changes upgrades and patches
• Experience in eliciting documenting and validating business requirements
• Experience in Software Testing Quality Assurance and Documentation
• Experience in building custom extensions and retrofit of code
• Experience in technical guidance on Oracle E-Business Suite custom development
• Demonstrated experience with Data reconciliation Experience in training transition and change management activities
• Excellent communications skills both written and verbal: clear concise and jargon-free Ability to communicate concepts and details to clients development

General Skills - 40%

• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values duplicate meanings and invalid data)
• Experience with developing feedback processes to fix corrupt data in the source systems
• Experience with developing data extraction transformation and load programs (daily and initial load) functionality on a wide range of data repositories (relational and multi- dimensional data stores)
• Experience with developing implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Experience with developing automation extraction cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc) Proven troubleshooting and analytical experience
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
• Experience in the use of development tools and business re-engineering software
• Experience in developing enterprise architecture deliverables (e.g. business logical and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
• A team player with a track record for meeting deadlines