Snowflake Architect

This range is provided by eTeam. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$75.00/hr - $80.00/hr

Direct message the job poster from eTeam

Job Title:
Snowflake Architect

Location:
Charlotte, NC

Duration: 05+ months

Pay Range: $(75.00 - 80.00)/hr on W2 all-inclusive without benefits

Job Description:

• 5-10 years of experience in data warehousing.
• Understanding of data models and co-coordinate with Client to capture requirements.
• Experience in snowflake and control M.
• 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 modelling: 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 modelling, 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 modelling Tools: Experience with data modelling tools like Erwin, Power Designer, or other industry-standard modelling 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

• Seniority level
  
  Mid-Senior level

• Employment type
  
  Contract

• Job function
  
  Information Technology
• Industries
  
  IT Services and IT Consulting

Referrals increase your chances of interviewing at eTeam by 2x

Apply BELOW