GDOT - Oracle Business Intelligence Enterprise Edition: (OBIEE Developer)

GDOT - Oracle Business Intelligence Enterprise Edition: (OBIEE Developer)

03 Dec 2024
Georgia, Atlanta, 30377 Atlanta USA

GDOT - Oracle Business Intelligence Enterprise Edition: (OBIEE Developer)

Vacancy expired!

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, SQLPlus, 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
Required/Desired Skills Skill Required /Desired Amount of Experience IT development experience Required 8 Years experience in writing PL/SQL, SQLPlus, etc. Required 5 Years experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development Required 5 Years experience with star-schema, snowflake, FACT, and dimensional data modeling Required 2 Years experience with OBIEE Answers, Dashboards, and BI Publisher Required 2 Years Questions No.

Job Details

  • ID
    JC23789839
  • State
  • City
  • Job type
    Contract
  • Salary
    N/A
  • Hiring Company
    RICEFW Technologies Inc
  • Date
    2021-12-02
  • Deadline
    2022-01-31
  • Category

Jocancy Online Job Portal by jobSearchi.