Maintaining the existing SingleServer of OBIEE 12c.
Conduct RequirementsGathering meetings on the specific analytics requirements withbusiness end users and various other stakeholders.
Build the metadata and analytics layer in Oracle OBIEE12c based on the materialized views provided by company, asillustrated by the architecture diagram in the nextpage.
Develop advanced analytics capabilities like forecasting,cluster, outlier etc. relevant to company use-cases.
Develop balanced scorecard using the Oracle Scorecard& Strategy Management component by building 2 scorecardswith not more than 5 objectives and necessary KPIs fitting companyrequirements and use-cases.
User Securityfeatures of OBIEE needs to be built and demonstrated as a part ofthe project.
Conduct workshop to demonstratethe various functionalities of the developed solution forDepartment of Economic Development team in Arabic or English oncompletion of build.
Hands-On Training / Workshop needs to be provided for the technical and business usersof the BI application to enable self-reliance both from a technicaland end user perspective.
Should provideProper Project Management during entire project.
Should support and enhance the existing OBIEE setup.Existing OBIEE implementations contains 150 reports and 5dashboards and department level security.
Allreports are developed using Oracle Jet and mChart APIs
All 5 dashboards are developedusing custom skin expected to maintain the current development aswell as enhance it at certain level.
Translatebusiness needs to technical specifications
Design, build and deploy OBI solutions
Create tools to store data
Conductunit testing and troubleshooting
Evaluate andimprove existing BI systems
Collaborate withteams to integrate systems
Develop and executedatabase queries and conduct analyses
Createvisualizations and reports for requested projects
Develop and update technical documentation
required skills & qualifications
Proven experience as a BI Developer
Industry experience is preferred
Background in data warehouse design (e.g. dimensionalmodeling) and data mining
In-depthunderstanding of database management systems, processing (OLAP) andETL(Extract, transform, load) framework
Goodexperience in BI technologies (Oracle BI)
Knowledge of SQL queries, SQL Server Reporting Services(SSRS) and SQL Server Integration Services (SSIS)
Proven abilities to take initiative and beinnovative
Analytical mind with aproblem-solving aptitude