Position: OBIEE Architect

Location: Atlanta, GA

Duration: 10 months

Responsibilities:

- 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
environment
- 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)