Snowflake Developer

  • Charlotte, NC
  • Posted 1 day ago | Updated 1 day ago

Overview

On Site
$40,000 - $180,000
Contract - W2
Contract - 12 Month(s)

Skills

Snowflake
Oracle
SQL Server
Teradata
Control M
dimensional modeling
star schema
snowflake schema
ETL processes
Erwin
Power Designer
EDW

Job Details

Role: Snowflake Developer

Duration: 12 Months

location: Charlotte, NC - Onsite

Visa's: USC

**Note: Please share the resume who are interested to work on W2, not on C2C. **

Job Description:

  • 5-10 years of experience in data warehousing. Understanding of data models and co-ordinate 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 requirements
  • 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, Power Designer, 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.

About Vizplum