Datawarehouse Architect

  • Vacaville, CA
  • Contract

Job Description

Role:  Datawarehouse Architect

Location: Vacaville, CA

Duration: 6 Months+

Rate: $70/Hr All inclusive on Corp to Corp

 


Responsibilities:

• Translate client user requirements into technical architecture vision and implementation plan

• Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

• Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)

• Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)

• Oversight of tool evaluation and selection

• Hardware recommendations, sizing and configuration

• RDBMS installation, configuration and tuning

• Oversight and/or coordination of system testing phase

• Problem and issue resolution

• Mentoring and developing junior staff

• Participation in proposal development and client presentations 

Qualifications

Required Skills:

• A minimum of 5 years of experience architecting large scale data warehouses using Oracle

• A minimum of 5 years of relevant consulting experience preferred or 7 years of corporate IT

• Expert data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3 rd normal form as well as dimensional modeling (star, snowflake), experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts

• Expert with pro's and con's of multiple warehouse architectures

• Expert RDBMS knowledge of Oracle (release 9i and 10g) including very large databases

• Expert in load design strategies and optimization techniques

• Implementation experience with ETL concepts and tools such as: DataStage, Informatica, Oracle Warehouse Builder

• Implementation experience with one or more of the following BI/Enterprise Reporting tools: Business Objects, Oracle Discoverer, Cognos, Brio, and Microstrategy

• Possess strong communication and client management skills.

• Ability to effectively manage multiple projects simultaneously

• BS in Computer Science or equivalent experience in a relevant field 

Additional Information

All your information will be kept confidential according to EEO guidelines.