Data Warehouse Architect
Raleigh, NC
12 Months
 
Job Description:
This position identifies opportunities to increase efficiency and effectiveness, trends in data uses, and single sources (sources of record) of data. Responsible for designing, modeling, developing and supporting complex logical database designs, models, and definitions using market leading Database Management and Information Handling Systems. Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment. 
Required/Desired Skills:
Required - 10yrs - Microsoft SQL Server 2008
Required - 3yrs - Microsoft SQL Server 2016 (on premise or Azure cloud based)
Required - 2yrs - NoSQL Databases (MongoDB, MS Azure Cosmos)
Required - 5yrs - Entity Relationship Diagrams (ERD)
Required - 5yrs - Data Flow Diagrams
Required - 5yrs - Star Schema
Desired - 2yrs - PostgreSQL, AWS Redshift
Desired - 5yrs - Sybase DB
Desired - 2yrs - Data Vault 2.0
Desired - 2yrs - Scripting Language such as Python
Desired - 2yrs - Visio
Desired - 2yrs - Agile Scrum Methodology
 
 
Regards, 
Ravi
 
Key Business Solutions, Inc.
 
|| Office: 916 646 2080 Ext 218 || Fax: 916 646 2081
 
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.