Previous Job
Oracle Business Intelligence Enterprise Edition (OBIEE) Developer
Ref No.: 16-01358
Location: Atlanta, Georgia
Client: GaDOT¿
Location: Atlanta,GA
Duration: 8+ Months
Submission Deadline: 10/12/2016

Job Description:
The Georgia Department of Transportation is seeking an Oracle Business Intelligence Enterprise Edition (OBIEE) Developer with solid experience and knowledge in implementing enterprise level RPD's, reports (BI Publisher, Answers/Dashboard), and analytics. Candidate must be able to develop RPD's, reports, and dashboards. Candidate will be expected to migrate legacy reporting business logic from SAP (BO/WI, Crystal Reports) and Microsoft (SSRS). 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 and Analytics Team is composed of 5 report developers and a team leader. The team is migrating Microsoft SSRS reports and SAP Business Objects (v. 4)/Crystal Reports to OBIEE (with Exalytics) BI Publisher and Answers/Dashboards.  Over 1000+ SAP reports are currently supported and will be assessed for retirement/replacement using OBIEE. Approximately 30 SSRS reports also will be converted. Development will be focused on providing ad hoc analysis to specific business authors and rolling out reports to business consumers. Current reports utilize the enterprise data warehouse (Oracle Exadata) and connections to SQL Server 2008/2012 and Oracle 11g/12c databases.
The team develops enterprise reports within IT applications (internal/external) and on the web. Reports serve all facets of the transportation enterprise from financials, programs/projects, human resources, to federally required reporting. The team coordinates with client, server, network, and database/data warehouse personnel to integrate supporting IT architecture. Moving forward, ad hoc analytics/dashboards, geospatial (Esri) integration, and Microsoft Office add-in integration will also be implemented.
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.
  1.  Assists in OBIEE administration, system maintenance, and upgrades
  2. Assists in the administration and implementation of BI system/system security
  3. Building geospatial reports/dashboards
  4. Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards
  5. Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams in collaborative design
  6. Configures Ad Hoc query and Reporting environments
  7. Deliver solid, scalable, robust BI reporting/analytic solutions
  8. Design, develop, and document OBIEE repository/metadata
  9. Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques
  10. Developing MS Office based content using Oracle Office tools
  11. Manage capacity and performance requirements
  12. Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP)
  13. Perform unit, system and integration testing
  14. Prepare estimates of time for design and development
  15. Provide design and development mentorship/cross-training with fellow team members
  16. Troubleshooting and resolving technical issues with minimal user disruption
  17. Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project
  18. Works with business users to gather reporting/analytics requirements
Required Skills:
  1. 2+ years of experience with OBIEE Answers, Dashboards, and  BI Publisher
  2. 2+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling
  3. 4 year Bachelor's degree with preferred concentration in IT, data science, or business
  4. 5+ years of experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development
  5. 5+ years of experience in writing PL/SQL, SQL*Plus, etc.
  6. 8+ years of IT development experience
  7. Ability to design reports in a logical, user friendly, and easy to understand format
  8. Ability to extrapolate business requirements, practices, and procedures
  9. Ability to meet deadlines and deliver high quality work products
  10. Ability to meet deadlines, results oriented
  11. Able to use complex expressions to calculate, group, filter, parameterize, optimize and format contents of reports/analytics
  12. Accountable for actions within OBIEE production environment
  13. Committed to ensuring data accuracy and quality within reports
  14. Complete working knowledge of OBIEE user, object and data security and caching capabilities.
  15. Demonstrated experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server databases
  16. Excellent communication skills
  17. Experience in data analysis, data profiling and validation
  18. Experience in producing test cases/scenarios
  19. Experience with Business Objects, Crystal Reports, and Reporting Services
  20. Experience with creating dashboards and performance metric based reporting
  21. Experience with deploying/upgrading BI systems
  22. High level of customer service
  23. Highly organized with the ability to multi-task
  24. Must be able to write technical documentation
  25. Must be skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities
  26. Understand how to use XML, and XSL for advanced report features and formatting
  27. •Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards
  28. •Strong knowledge of RDBMS – MS SQL Server 2008/2012, Oracle 11g/12c
Desired Skills:
  1. Experience customizing BI reports using JSP, ASP, SDK
  2. Experience in BI security and server administration
  3. Experience with Crystal Reports and sub-reports
  4. Experience with Microsoft SharePoint
  5. Experience with Microsoft SSRS
  6. Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), and Learning Management