CyberCoders Oracle BI Solution Architect in Irvine, California

Oracle BI Solution Architect Oracle BI Solution Architect - Skills Required - SDLC Methodologies, Oracle R12 business Suite, PL/SQL, ETL, Oracle data integrator (ODI), Informatica PowerCenter, OBIEE/Essbase, BI toolsets

If you are a Oracle BI Solution Architect with experience, please read on!

What You Will Be Doing

-Conducts business process analyses, needs assessments, and preliminary cost/benefits analyses in an effort to align information technology solutions with business initiatives.

-Works with business users to define and analyze problems and align the most appropriate technical, application or configuration solutions.

-Solicits, develops, documents and manages requirements and provides detailed design and business processes to support the requirements throughout the project life cycle up to and through change control.

-Considers the business implications of the application of technology to the current and future business environment.

-Reviews system test plans and system tests applications to ensure successful test cycles.

-Creates, reviews and delivers end-user documentation (user guide, process flow charts, and training materials) and training for accuracy.

-Works with the user to select or create appropriate scenarios to test all results to determine whether system changes met project specifications; uses scenarios to assist the end user in acceptance testing.

-In upgrades, monitors production performance enhancements and system integrity with end-users.

-Develops detailed implementation and upgrade project plans in conjunction with other account team associates.

-Ensures that documentation is updated when change requests are approved for the project.

-Provides expert input on processes, procedures, or new approaches.

-Leads large scale or complex business systems and application upgrades/ enhancement development and installations.

-Evaluates user requirements for one or more specialized reporting solution need and translates those needs into defined user assessment plans or specifications -used in determining end-user business or technical needs.

-Technical expert in more than one reporting technology.

-Serves as a functional/technical resource and mentors the business organization

-Defines cost and time estimates for implementation/ development projects.

-Develops project plans, user acceptance test plans and communication plans for knowledge transfer to end-user.

-Creates business process and data flow charts for customer and technical review.

-Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors.

-Serves as the subject matter expert and consulting resource for data management and reporting.

-Works on applications and business problems that are highly complex and diverse in scope and may include and project size, multiple applications, multiple I/T segments, contractors, global rollout, new technologies, new architectures.

What You Need for this Position

-Expert Knowledge of system development methodology, project management, analytical/problem solving skills and relevant development and technology skills.

  • Advanced knowledge of and ability to put into practice commonly used SDLC methodologies (Waterfall, Agile, etc.).

Advanced technical knowledge of the OBIEE Oracle reporting platform 11g or above including Essbase/Smart View, Data Visualization, Analysis and Reporting.

  • Advanced technical knowledge of PL SQL, transactional SQL, and SQL Developer or like tool to develop views, queries and stored procedures to support transactional reporting.

  • Advanced technical knowledge of scripting tools and approaches, scheduling approaches to develop automated scripts to load databases and cubes.

  • Advanced knowledge of at least one ETL Orchestration tool such as Oracle Data Integrator (ODI), Informatica PowerCenter, Talend Enterprise Data Integration Services, ODI preferred.

  • Advanced knowledge in the administration, maintenance, provisioning and metadata creation of OBIEE/Essbase or like BI toolsets; Cognos experience a plus to support the migration.Language and Communication Skills: Must possess excellent facilitation and communication skills, and able to adapt to the level and nature of their audience.

-Working knowledge of the supported business functions and processes, including: Financial Accounting, General Accounting, Sales and Distribution, Procurement and Cost Accounting for proper reporting.

  • Working knowledge of the basics of the Oracle R12 business Suite data model to ensure effective and optimal design, deployment and support of Oracle based reporting solutions.

  • Undergraduate degree and 10+ years relevant experience or Graduate degree and 8+ years relevant experience.

So, if you are a Oracle BI Solution Architect with experience, please apply today!

Applicants must be authorized to work in the U.S.

CyberCoders, Inc is proud to be an Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other characteristic protected by law.

Your Right to Work – In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

Oracle BI Solution Architect CA-Irvine BP3-1459799