OBIEE Admin, Analyst - Harrisburg, PA, United States - Innova Solutions

Description

Seeking an OBIEE Administrator/Analyst to "turn on" and implement new Oracle functionalities
Needs to have knowledge of implementing Oracle server capabilities and to hook up to API integrations
BI reporting preferred
Security clearance required to start
This job will star out onsite in Alexandra VA and they will get more flexible once acclimated

At least 10 years of relevant experience such as working with the DoD Future Years Defense Program (FYDP) data and with Program Review.

Ten years being a solution provider/software developer.

Proven and in-depth experience with Oracle Application Express (APEX) 5.2 or greater Application Administration/Development supporting minimum (5) large scale complex APEX applications supporting secure role-based multi-user data collection, reporting, and document generation functions.

In-depth knowledge of PL/SQL, SQL, Java, JavaScript, Web Services, AJAX, XML, XSLT, JSON, HTML, and CSS and other programming languages.

Design and manipulation skills to modify web content dynamically using JQuery, Ajax, JavaScript, CSS, and HTML
Proven experience developing secure (OAUTH2 authentication) RESTful services using Oracle RESTful Data Services (ORDs) and Java Servlets.
Strong design, development, implementation technical expertise with web based analytical front ends and workflows.

Excellent knowledge in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, indexes, triggers, cursors, materialized views, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

Provide support with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment.

Hands on experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds and Bulk Collect.

Experience using Oracle built-in database packages (DBMS_SCHEDULER) and mail.
Experience using FTP and SFTP services in APEX applications.
Experience designing and developing SAP Crystal Reports.
Interim DoD Secret clearance.

At least five (5) years of information systems management experience.

Skills:

Oracle Application Express (APEX), APEX Plugins, HTML, Visual Basic, Java, JSP, Java Script, Java Servlet, PL/SQL, CVS, Eclipse, Apache, WebLogic, IIS, Oracle, SQL Server, OBIEE/Oracle Analytics, Oracle Data Visualization, D3, MS Access, SQL, Agile Software Development, Software Development Life Cycle, SAP Crystal Reports or greater, Identity Management, WordML, Word, Excel, PowerPoint, OLE automation, LDAP, SFTF, FTP, JSON, XML, XSLT, Toad, ASPOSE For Java.

At least five (5) years of experience in architecting Business Intelligence (BI) or Web Application system solutions
At least five (5) years of software development or COTS solution deployment experience.
At least five (5) years of experience with DoD PPBE process, data structures (DoD program, OUSD(C) Comptroller budget, and acquisition) with BI solutions and related products and systems

Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

Website:
is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment.

Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates.

If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at or
. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.