Back to Job Search

Data Warehousing Specialist

  • Location: Chandler, AZ, 85225
  • Job Type:Contract

Posted 27 days ago

Title: Data Warehousing Specialist 
Location: Chandler, AZ
Type: 6-month Contract 


Overview:
The Data Warehousing Specialist (DWS) designs, implements, and supports data warehousing initiatives. He or she is a senior level resource that is responsible for aspects of the Data Warehousing arena that include architecture, analysis, design, and implementation of Business Intelligence, Data Warehousing, and Data Mart initiatives. The DWS could contribute by defining system and application architecture, providing vision, anticipating problems, and solving problems. He or she could also code, develop, and design.  Often, the DWS will consult with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization. This is an on-premise position, must be willing and able to work onsite.

Roles and Responsibilities:
•Setting or enforcing standards and overall architecture for data warehouse systems.
•Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team.
•Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies.
•Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.
•    You lead design efforts or played a major role in setting up a data warehouse.
•    You are familiar with best practices
•    You are comfortable communicating both technical and non-technical details to all levels.
•    You are able to train others how to support a data warehouse.
•    Organized and detail oriented
•    Strong work effort
•    Communication is top notch both , writing, speaking and presentation

Skills and Technologies:
Could include various technologies and roles including Data Warehouses and Data Marts, Star Schema (Fact / Dimension), Slow Changing Dimension (SCD) change techniques (Type 0 - 4),  
Understanding how to design and load this design using SSIS for ETL SQL Server, Oracle and other BI systems, SSRS/SSAS, and possibly others.