Oracle Data Architect

Knowledge, Skills, and Abilities

Minimum of seven (7) years’ experience performing activities directly related to a Data Warehouse implementation, database design and database administration (DBA). Experience includes implementing or maintaining Oracle data warehouse and business intelligence tools such as the following examples:

· Oracle Analytics Cloud (OAC)

· Oracle Analytical Server (OAS)

· Oracle Cloud Infrastructure (OCI)

· Oracle Business Intelligence (OBI)

· Oracle Business Intelligence Application (OBIA)

· Oracle Business Intelligence Enterprise Edition (OBIEE)

· Oracle Data Integrator (ODI)

· Oracle Autonomous Data Warehouse (ADW)

Minimum of seven (7) years’ experience performing activities directly related to data modeling (logical and semantic) and metadata management Experience with data warehouse fundamentals such as SQL, OLAP (Online Analytical Processing), star and snowflake schemas, ETL (Extract, Transform, Load) processes, Informatica, Tidal, and Business Intelligence Application Configuration Manager (BIACM).

Experience implementing and using business intelligence tools, including data visualization, analytical thinking, attention to detail, problem solving and strong communication.

Ability to analyze database tables, materialized views, data sets, reports, and so forth to identify gaps and to determine the appropriate action to be taken to resolve or disposition the identified gaps.

Bachelor’s or master’s degree in computer science, Information Systems, or other related field. Or equivalent work experience.

Preferred Experience and

Knowledge, Skills, and Abilities

Experience working with the State or with other governments similar in size in terms of annual budget and full-time equivalent (FTE) employee count.

Experience in the use of Microsoft Office suite, SharePoint, Visio and MS Project.

Experience implementing PeopleSoft in local and state government

Knowledge of PeopleTools 8.59 and fluid page development.

Experience using PeopleSoft Financials, Human Capital Management (HCM).

Experience using Oracle Business Intelligence Reporting Solutions and ADW.

Certifications such as Oracle Certified Expert, Oracle Certified Implementation Specialist, Oracle Certified Professional (OCP), Certified Data Management Professional (CDMP), data modeling certifications or other related professional certifications.