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