Data Warehouse Architect 5

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - start date

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
Data Marts
Collaboration
Data Profiling
Data Analysis
Impact Analysis
Data Structure
Scalability
Data Quality
Computer Science
Information Systems
Data Modeling
Data Warehouse
Database
ERwin
Dimensional Modeling
Extract
Transform
Load
Data Governance
Meta-data Management
SQL
Database Performance Tuning
Analytical Skill
Communication
Documentation
Cloud Computing
Amazon Web Services
Microsoft Azure
Google Cloud Platform
Google Cloud
Teradata
Business Intelligence
Reporting
Tableau
Microsoft Power BI
Business Objects
Agile
DevOps
Oracle Linux

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Roles/Responsibilities:

  • Design, develop, and maintain logical and physical data models for Teradata-based data warehouses and data marts.
  • Use Erwin Data Modeler to create, update, and maintain data models, metadata, and data dictionaries.
  • Analyze business requirements and translate them into effective database designs.
  • Define and implement data modeling standards, best practices, and naming conventions.
  • Collaborate with data architects and ETL teams to ensure consistency between data models and ETL processes.
  • Perform data profiling, data analysis, and impact analysis on data model changes.
  • Optimize data structures for performance, scalability, and maintainability in the Teradata environment.
  • Support data governance and metadata management initiatives.
  • Participate in code reviews, design sessions, and data quality assessments.
  • Provide documentation and support for production and development teams.

Mandatory Skills:

  1. Bachelor's degree in Computer Science, Information Systems, or related field.
  2. 5+ years of experience in data modeling for large-scale data warehouse environments.
  3. Strong experience with Teradata databases and architecture.
  4. Expertise in Erwin Model Mart.
  5. Strong understanding of normalized and dimensional modeling techniques.
  6. Experience with ETL design concepts, data governance, and metadata management.
  7. Solid understanding of SQL and database performance tuning.
  8. Excellent analytical, communication, and documentation skills.

Desirable Skills:

  1. Experience in cloud data platforms (AWS, Azure, Google Cloud Platform) and integration with Teradata.
  2. Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.).
  3. Exposure to Agile / DevOps methodologies
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech