Data Architect

About this Position:

Job Title: Data Architect

Required Skills:

• Minimum five (5) years of current experience providing services in architecting, designing, and implementing warehouse solutions for applications and Business Intelligence (BI) solutions for large scale/complex environments including SFS, SiteManager, and Oracle Primavera Portfolio Management (OPPM).

Preferred Skills:

• Preferred experience designing and implementing large scale and complex data warehouses for BI solutions.

• Preferred experience designing and implementing data warehouse structures using Star and SnowFlake data warehouse methodologies.

• Preferred experience in the design of ETL processes and ETL strategy.

• Preferred experience writing SQL, PL/SQL, stored procedures, functions, packages, and triggers.

• Preferred experience with Oracle databases to deliver large-scale warehousing solutions that are multi-terabyte in size.

• Preferred experience leading project teams through the design and development processes of warehouses.

• Preferred experience with Oracle Business Intelligence Enterprise Edition (OBIEE) tools, IBM COGNOS or Business Objects.

• Preferred experience with Statewide Financial System business processes and transactions files related to bulkload, budget management and procurement contract processing.