Senior, IT Specialist

This position serves as an OBIEE 12c/OAS/Power BI, IT Specialist, and support the staff for the Office of Mental Health. This position also supports R&D efforts development of new OBIEE 12c/OAS executive dashboards, analytics and BI Publisher.

— Day-to-Day Tasks —

1. Analyze and develop OBIEE 12c/OAS technical solutions. Complete requirements analysis, capture and document the customer’s business and technical needs

2. Research and recommend technology to improve the current OBIEE systems

3. Contribute to the design and implementation of the metadata and/or reporting components of the solution (building and/or modifying OBIEE 12c/OAS Repositories) including testing and deployment of the components

4. Building a business and presentation layer within OBIEE 12c/OAS to meet the business requirements of the project.

5. Create reports and graph dashboards using OBIEE 12c/OAS, incorporating into Oracle Web Center as necessary, to meet the business requirements of the project.

6. Develop Reports in BI Publisher and integrate with OBIEE Dashboard.

7. Develop Power BI reports and publish to Workspace.
8. Configure and administer WebLogic Server.
9. Perform unit testing on all code changes.

60 Months Experience in OBIEE 12c/OAS catalog development, MUDE repository development. 60 Months Experience with Oracle 10/11G/19 databases, Oracle Data Warehouse Data Marts and Complex SQL Query coding. 48 Months Experience with configuring OBIEE Weblogic Server 48 Months Experience in BI Publisher integrated development with OBIEE Dashboard. 24 Months Development experience in Power BI reports and paginated reports. 60 Months Experience with System & Data Analysis, Application Design & Dimensional and Data Modeling with Design, and Documentation 60 Months Experience Implementing application roles from a database table and applying the user roles in dashboard. 60 Months Experience working with PL/SQL, SQL Query Performance tuning.