Snowflake Architect

Overview

On Site
Contract - W2
Contract - to hire

Skills

Translate
Business Requirements
Excellent Communication Skills
Best Practices
SQL
Database Modeling
Oracle
Database Management
MS SQL Server
Data Integration
ETL
Data Quality
Performance Optimization
Data Governance
Data Warehousing
Data Modeling
Data Architecture
Erwin
Data Warehouse
Data Migration
DBMS
Database Management System
Data Cleansing
Teradata
Snowflake Schema
Star Schema
Powerdesigner
Dimensional Data
EDW
Modeling Software

Job Details

Position: Snowflake Architect

Work location: Charlotte, NC - onsite.

Duration: 3 Months contract to hire

JOB DESCRIPTION

  • 5-10 years of experience in data warehousing. Understanding of data models and co-cordiante with Client to capture requirements.
  • Experience in snowflake and control M
  • Data Architecture Design: Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies to effectively store and access data from various sources as per the requirments.
  • Business Requirements Gathering: Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements.
  • Data Integration and ETL Development: Oversee the design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format, and load it into the EDW.
  • Data Modeling: Create dimensional data models to optimize querying and reporting on the data within the EDW.
  • Performance Optimization: Monitor and optimize the performance of the EDW to ensure efficient data access and query response times.
  • Data Governance: Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations.
  • Overall Technical Leader: Provide technical guidance on data warehouse technologies, tools, and best practices to the relevant stakeholders.
  • Collaboration with Stakeholders: Work closely with business users, data analysts, and application developers to understand their data needs and deliver data-driven insights.

Required Skills and Experience:

  • Data Warehousing Expertise: Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modeling, star schema, snowflake schema, and ETL processes.
  • Database Management Systems (DBMS): Proficient in SQL's and Databases like Snowflake, Oracle, SQL Server, or Teradata , Control M
  • Data Modeling Tools: Experience with data modeling tools like Erwin, PowerDesigner, or other industry-standard modeling software.
  • Data Integration Tools: Familiarity with data integration tools for ETL development and data cleansing.
  • Communication Skills: Excellent communication skills to effectively collaborate with stakeholders from various departments.

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.