Job Description :
Title: Data Warehouse Specialist
Location: Raleigh, NC
Duration: 12 Months
Job Description:
The North Carolina Community College System (NCCCS) is seeking a Data Warehouse Architect to assess business needs and design and develop a new data warehouse solution.
The NC Community College System (NCCCS) Data Warehouse Architect is responsible for analyzing enterprise business needs and designing and developing complex logical databases, logical data models, relational data definitions, and data warehouses in support of Enterprise (NCCCS) information system needs. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations. Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models.
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.
Skill
Required / Desired
Amount
of Experience
Microsoft SQL Server 2008
Required
10
Years
Microsoft SQL Server 2016 (on premise or Azure cloud based)
Required
3
Years
NoSQL Databases (MongoDB, MS Azure Cosmos)
Required
2
Years
PostgreSQL, AWS Redshift
Desired
2
Years
Sybase DB
Desired
5
Years
Entity Relationship Diagrams (ERD)
Required
5
Years
Data Flow Diagrams
Required
5
Years
Star Schema
Required
5
Years
Data Vault 2.0
Desired
2
Years
Scripting Language such as Python
Desired
2
Years
Visio
Desired
2
Years
Agile Scrum Methodology
Desired
2
Years
if interest Please provide me below information:
· Full Name:
· Email ID:
· Contact:
· Address:
· Availability:
· Passport No :
· Last 4 digit SSNO:
· Availability for Interview:
· Visa Status:
· Visa Expiry date (MM/DD/YYYY):
· Relocation:
· Rate:
· LinkedIn ID :
Professional Reference :1
· Full Name :
· Company Name :
· Title :
· Telephone :
· Email id :
Professional Reference :2
· Full Name :
· Company Name :
· Title :
· Telephone :
· Email id :