Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

OBIEE Architect (224 views)

NW Atlanta, GA
October 27, 2020

***** Direct Client Requirement*****                     

Title                        OBIEE Architect

Location                 :  NW Atlanta, GA

Rate                       : DOE /If your experience and skills match call us immediately for submission

Duration                : 5 Months

Interview Type     : Skype only

Work Status         : Successful applicants must be legally authorized to work in the U.S.

Job Type               : C2C,C2H, W2

Experience          : 12+ YEARS

Prefer W2           : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Job Description:

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.

– Candidate will be responsible for developing a strategic roadmap, project plan, technical design/architecture,  and implementation guidance to successfully meet data modeling needs of business areas for GDOT  business operations. Candidate will work directly with GDOT Data Architect and Enterprise Data Warehouse to design/develop the OBIEE repository under the leadership of the Team Lead.

– Candidate must have experience with 12c environments installation, configuration, upgrades, patching, Security and trouble shooting.

– Strong experience in OBIEE 12c Configuration and Administration.

  Must be able to assist with automating repetitive processes and help identify potential areas for improvement.

– Experience/Knowledge with Oracle Analytics Server (OAS) platform on Linux would be preferred. Experience  troubleshooting WebLogic and OBIEE performance issues.

– Candidate must be able to lead the implementation of a best-practices design to develop data/ETL  procedures for data modeling and end user ad hoc data analysis.

– Candidate must bring practical working knowledge of OBIEE to navigate Oracle Support and define solutions  to overcome product constraints.

– Candidate must be capable of guiding developers and troubleshooting issues with data modeling, RPD’s,  reports, and answers/dashboards.

– Candidate will be expected to develop GDOT knowledge base and systems documentation to be stored within

  Microsoft SharePoint:

– Candidate must demonstrate ability to be detail oriented, but productive and effective. Candidate must be capable and committed to delivering results on-time/on-schedule. Candidate requires excellent leadership, teamwork, and communication skills.

– The Enterprise Reporting and Analytics Team is composed of 5 report developers. 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, OBIA  (financials, project, Human Resources, etc.), 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.

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)

Required / Desired Skills

OBIEE (11g & 12c) installation, configuration, upgrades, migration, administration, troubleshooting.

Required 12 Years

OBIEE (11g & 12c) deploying patches and performance tuning under Linux environment.

Required 10 Years

Experience in writing PL/SQL, SQL*Plus, etc.

Required 10 Years

Experience implementing large scale Siebel/Oracle OBIEE reporting solutions

Required 10 Years

Experience with star-schema, snowflake, FACT, and dimensional data modeling

Required 10 Years

Experience with OBIEE Answers, Dashboards, and BI Publisher

Required 10 Years

Bachelor’s degree with preferred concentration in IT, data science, or business from a university within the United States

Required 4 Years

Demonstrated experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server database

Required 10 Years

Experience with establishing the reporting framework and supporting the self-service reporting capability

Required 8 Years

Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards

Required 10 Years

Experience with developing and establishing development/implementation standards

Required 10 Years

Hands-on experience with MS SQL Server 2008/2012, Oracle 11g/12c and Oracle Exadata

Required 10 Years

Hands-on experience in configuring OBIEE data security

Required 10 Years

Experience in Oracle Analytics, BI security and server administration

Highly desired 8 Years

Experience with Microsoft SharePoint

Desired 6 Years

Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), Kronos WFTK and Oracle Learning Management

Required 7 Years

Experience in writing custom Java/Javascript code or XML, and XSL for advanced report features to customize OBIEE functionality

Required 5 Years

******Referral Bonus Available: Refer your friends or colleagues, get referral bonus******

Thanks
Rakesh/Siva
Rakesh@Sohanit.com/siva@sohanit.com
PH:402-241-9551/402-241-9606
Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true
Twitter: https://twitter.com/SohanITInc1

Position Keywords: system maintenance , oracle learning , obiee , database , data warehousing , etl , oracle , snowflake , systems documentation , primavera , data modeling , bi publisher , server administration , xml , pl/sql , oracle analytics , bi security , sql server , javascript , weblogic , enterprise data warehouse , sql*plus , data architect , java , linux , oracle learning management

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 5 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2446

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox