Job Description :
OBIEE Architect for State of Georgia
Location: Atlanta, GA
Duration: 12 Months.

The Georgia Department of Transportation (GDOT) is seeking an Oracle Business Intelligence Enterprise Edition (OBIEE) Architect with solid experience and knowledge in implementing OBIEE within the enterprise. GDOT currently has OBIEE 12c installed and configured and planning to upgrade to recently release Oracle Analytics Server (OAS) 5.5.


- Conducts technical review of requirements and develops enterprise strategy, architecture, and technical
- design for successful implementation by GDOT developers.
- Provides team leadership, facilitates communication, eliminates bottlenecks, engages other IT resources
- Provides team task assignments, oversight, and is responsible work team work products
- Responsible for developing schedules and managing report migration effort
- Responsible for translating requirements into technical design/development
- Responsible for resolving support issues, coordinating system patches, upgrades, maintenance, and other
- support activities as needed
- Responsible for tracking and responding to SR submitted to Oracle
- Documents systems architecture, support procedures, benchmarks performance, and improves system
- operation
- Designs/builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards
- Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP)
- Develops, implements, and analyzes data cubes, ETL, data loading, dimensions, calculating data and
- aggregation techniques
- Design, develop, and documents OBIEE repository/metadata
- Configures Ad Hoc query and Reporting environments
- Designing geospatial reports/dashboards
- Developing MS Office based content using Oracle tools
- Assists in OBIEE administration, system maintenance, migration, patching and upgrades
- Troubleshooting and resolving technical issues with minimal user disruption
- Working in a team environment to develop reports and/or dashboards while working as a team member on an
- assigned project
- Works with business users to gather reporting/analytics requirements
- Perform unit, system and integration testing
- Manage capacity and performance requirements
- Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams
- in collaborative design
- Provide design and development mentorship/cross-training with fellow team members
- Deliver solid, scalable, robust BI reporting/analytic solutions
- Assists in the administration and implementation of BI system security
- Prepare estimates of time for design and development

Required Skills:

12+ years of OBIEE (11g & 12c) installation, configuration, upgradation, migration, administration,
troubleshooting, deploying patches and performance tuning under Linux environment.
10+ years of experience in writing PL/SQL, SQL*Plus, etc.
10+ years of experience implementing large scale Siebel/Oracle OBIEE reporting solutions
10+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling
10+ years of solid experience with OBIEE Answers, Dashboards, and BI Publisher
4 year Bachelor’s degree with preferred concentration in IT, data science, or business from a university within
the United States
5 + years of experience in writing custom Java/Javascript code or XML, and XSL for advanced report
features to customize OBIEE functionality
Demonstrated experience in designing, building, implementing, and deploying data universes/data models
against Oracle and SQL Server databases
Experience with establishing the reporting framework and supporting the self-service reporting capability
Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics,
and dashboards
Experience with developing and establishing development/implementation standards
Experience with leading, guiding, and mentoring a team of report developers delivering in a rapid deployment
Ability to extrapolate business requirements, practices, and procedures into design specifications
Ability to design reports in a logical, user friendly, and easy to understand format
Hands-on experience with MS SQL Server 2008/2012, Oracle 11g/12c and Oracle Exadata
Hands-on experience with deploying/upgrading OBIEE
Hands-on experience in configuring OBIEE data security
Ability to meet deadlines and deliver high quality work product
Highly organized with the ability to multi-task
High level of customer service
Excellent communication skills
Committed to ensuring data accuracy and quality within reports
Accountable for actions within OBIEE 12c production environments (DEV, TEST & PROD)
OBIEE Certification

Desired Skills:

Experience in Oracle Analytics, BI security and server administration
Experience with Microsoft SharePoint
Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), Kronos WFTK and Oracle Learning Management System (ELMS)

Client : State of Georgia