Experience Inc. Jobs

Job Information

Computer Consultants International, Inc Data Warehouse Architect (Job ID: 604194) in Raleigh, North Carolina

Data Warehouse Architect (Job ID: 604194)

  • 200 W Jones St, Raleigh, NC 27603, USA

  • Full-time

Company Description

Computer Consultants International, Inc. (CCI) is an IT Consulting Firm with more than 18 years experience providing effective, expert-level services in industries such as Construction, Technology, Finance, Healthcare, and Government. CCI focuses on building long-term relationships while completing projects from design to delivery. People are CCI's key component for success. Recruiting utmost-quality individuals for our clients, CCI fields a workforce of individuals who are selected not only because of their technical qualifications but also for their achievements as substantial, contributing human beings. In government work and in the commercial market, high standards of ethics and accountability are critical. Therefore our people are chosen for their integrity and ability to maintain relationships, as well as expertise in their field. To learn more about CCI, visit us online at www.cci-worldwide.com.

Job Description

The 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.

Qualifications

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

All work must be completed on site.

Candidate must be able to attend an interview in person after an initial phone interview. Do you accept this requirement?

Additional Information

For immediate consideration, please send your resume to hire(at)cci-worldwide.com with "604194-NC" Subject Line

Job Location

DirectEmployers