Snowflake Architect

Company: Emonics, LLC
Location: Louisville
Posted on: March 20, 2023

Job Description:

-Title: Snowflake Architect
Location: Louisville, KY
Job Type: Fulltime

Technical/Functional Skills:

• Snowflake Development
  
• Cloud Migration
  
• ETL and Data Management
  
  Experience Required
  
  

• 
  
• Must have total 12+ yrs. in IT and 3+ years' experience working as a snowflake Data Architect
  
• Must have experience at least two end to end implementation of Snowflake cloud data warehouse
  
• Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
  
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
  
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
  
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
  
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
  
• Experience with data security and data access controls and design
  
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
  
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
  
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
  
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
  
• Certified Snowflake cloud data warehouse Architect (Desirable).
  
• Must have experience of Agile development methodologies
  
• Strong written communication skills. Is effective and persuasive in both written and oral communication
  
  Roles & Responsibilities
  
  
  • 
    
  • Responsible for creating E2E solution architecture for building an enterprise data warehouse on Snowflake
    
  • Responsible for assisting in the establishment of an IT Architecture, and the adoption of an architecture and standards methodology
    
  • Responsible for implementing analytics and business intelligence solutions on Snowflake
    
  • Manages activities that take place during solution ideation, solution design, and solution implementation
    
  • Responsible for assisting creating E2E Data architecture
    
  • Communicates the architecture to the stakeholders and collaborates and coordinates with existing domain architects in the adoption of IT standards and procedures
    
  • Responsible for building data lake & data warehouse by ingesting data from multiple disparate data sources
    
  • Provides analysis of security protection technologies
    

Keywords: Emonics, LLC, Louisville , Snowflake Architect, Professions , Louisville, Kentucky