Oracle Business Intelligence Enterprise Edition

Title/Role: Oracle Business Intelligence Enterprise Edition: (OBIEE Developer) (669224)

Start Date: 12/20/2021

End Date: 06/30/2022

Worksite Address: 600 W Peachtree Street NW.  Atlanta GA 30308

Agency Interview Type: Either Web Cam or In Person

The Georgia Department of Transportation is seeking an Oracle Business Intelligence Enterprise Edition (OBIEE/OAS) Developer with solid experience and knowledge in implementing enterprise level reporting solutions using OBIEE/OAS -In Premise.

The Georgia Department of Transportation is seeking an Oracle Business Intelligence Enterprise Edition (OBIEE/OAS) Developer with solid experience and knowledge in implementing enterprise level reporting solutions using OBIEE/OAS (Oracle Analytics Server – In-Premise). Candidate must be able to develop RPD’s, reports (Answer, BI Publisher & Data Visualization, and dashboards. Candidate must demonstrate ability to be productive and effective in report conversion. Candidate must be capable and committed to delivering results on-time/on-schedule.

The Enterprise Reporting & Analytics Team is composed of 5 report developers, 1 architect and a Team leader. Current reports utilize the latest versions of enterprise data warehouse (Oracle Exadata), Oracle databases and SQL Server.

The team develops enterprise level reports for the GDOT users (internal & External) within IT applications department. Reports serve all facets of the transportation enterprise from financials, programs/projects, human resources, to federally required reporting. The team coordinates with business users, Windows & Unix Server, network, and database/data warehouse teams for the report development.

The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one-year increments. Several successful developers have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.

Responsibilities:

•  Builds OBIEE/OAS reports (Answer, BI Publisher and Data Visualization) and Dashboards

•  Models, configure and optimizes the RPD based on Data Warehouse (OLAP) and databases (OLTP) sources.

•  Building geospatial reports in OBIEE/OAS environments using Answer and Data Visualization

•  Develop Data model (using SQL Query & Subject Area) and reports in BI Publisher using RTF template and/or Online Editor

•  Assists in day-to-day OBIEE administration, deployment, system maintenance, and upgrades

•  Assist in Troubleshooting and resolving technical issues with minimal user disruption

•  Perform unit, system and integration testing

•  Work with business users to gather reporting/analytics requirements

Required Skills:

•  8+ years of IT development experience in Oracle BI environment

•  5+ years of experience as an Oracle BI developer using OBIEE/OAS with deep expertise in RPD design/development, Reports (Answer, BI Publisher & OAS Data Visualization) and Dashboards

•  Experience in Oracle BI (OBIEE/OAS) security and server administration

•  5+ years of strong working knowledge of leading RDBMS e.g., MS SQL Server 2016/2019, Oracle 12c/19c and Oracle Exadata X7-2

•  5+ years of experience in writing PL/SQL, SQL*Plus, etc.

•  5+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling

•  Demonstrated experience in designing, building, implementing, and deploying enterprise level reports, analytics, dashboards, RPD and data models against Oracle, SQL Server and other leading databases (hosted in-premise & Cloud)

•  Demonstrated experience in creating advanced and complex level calculations in OBIEE/OAS

•  Demonstrated experience in complex RPD, Data Model, Reports (Answer, BI Publisher – Data Model, RTF Template, Online Editor)

•  Demonstrated experience in creating advanced visualization using OBIEE, BI Publisher and OAS Data Visualization

•  Complete working knowledge of OBIEE/OAS security (users, objects and data level) and caching capabilities.

•  Experience with deploying/upgrading BI systems

•  Basic understanding of Oracle WebLogic server.

•  Must be skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities

•  Understand how to use XML, and XSL for advanced report features and formatting

•  Experience with creating performance metric-based reporting and dashboards

•  Ability to extrapolate business requirements, practices, and procedures

•  Ability to meet deadlines and deliver high quality work products

•  Experience in producing test cases/scenarios

•  Experience in data analysis, data profiling and validation

•  Must be able to write technical documentation

•  Highly organized with the ability to multi-task

•  High level of customer service

•  Excellent communication skills

•  Ability to meet deadlines, results oriented

•  Committed to ensuring data accuracy and quality within reports

•  Accountable for actions within OBIEE production environment

Desired Skills:

•  Experience with Microsoft SharePoint

•  Experience with Power BI and other leading Visualization Tools

•  Experience customizing BI reports using XML, HTML, JSP, ASP, SDK

•  Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), Learning Management and Microsoft Project

Tool & Technologies:

•  Oracle Business Intelligence Enterprise Edition (OBIEE) 12c / Oracle Analytics Server (OAS)

•  Linux 7.x

•  Microsoft Windows 10

•  Microsoft Office Suites (Outlook, Teams, Access, Excel, Words etc.)

Education:

•  4 years Bachelor’s degree with preferred concentration in IT, data science, or business

,

Harika Metla

Technical Recruiter

phone

Email: