Snowflake Architect

Dept overview: Support snowflake initiatives

Role: Snowflake architect. Familiar with snowflake and AWS. Comes from AWS and processes them in Snowflake. Will Jaynae? Will help with new initiatives too

Top skills:  

Strong communication skills, Technical depth in AWS & Snowflake , Coding skills in Python and SQL

Strong certified resource. Is a plus Not snowflake engineer. Knows snowflake behind the scene.

AWS certification and Snowflake certification is a plus almost required

3+ years Snowflake Architect level experience ( Production Grade ): ie previous titles like Data Analytics Architect or Principle Engineer

- 5+ AWS Cloud Experience ( Production Grade). Not Azure or GCP

- 3+ Implementations in snowflake and understand the advanced capabilities like ML Model deployment etc Snowflake Optimization experience ( Auto clustering , Warehouse, Query plan ) etc.

- SQL performance tuning

- Exp with AWS well architected framework 

Education/Experience:

Bachelor’s degree in computer science or Electrical engineering or related field is required 10 years or more of software development experience or at least 8 years of experience with master’s degree in computer science or related field. 

Position’s Contributions to Work Group: 

Actual job title would be an Snowflake/AWS Integration Architect  As an architect / Engineer you will lead all stages of software development including refining product vision, gathering requirements, project planning, software system design, coding, testing, release, deployment and support. Will be optimizing and simplifying existing structures. Leading the team in adapting best practices to increase efficiency.

Typical task breakdown:

-          1. Review the snowflake integration design - using this design to continue to build multiple use cases 2. Manage the CI/CD of snowflake Changes 3. Admin the snowflake environment ( Pipe, Warehouse, user ...) 4. Automate the data quality activities in snowflake ( Task , workflow) 5. Integrate AWS - Snowflake - PowerBI - UI Apps This position will hybrid onsite in Chicago - 2-3 days a week in office. Client will provide a laptop.

 Interaction with team:

-           Team consists of 5 people in US and 20 people in India.

Work environment: 

Hybrid role in Chicago/Peoria office ( 3x days onsite) 

Technical Skills

(Required)

-           3+ years Snowflake Architect level experience ( Production Grade ): ie previous titles like Data Analytics Architect or Principle Engineer

-          5+ AWS Cloud Experience ( Production Grade)

-          3+ Implementations in snowflake and understand the advanced capabilities like ML Model deployment etc Snowflake Optimization experience ( Auto clustering , Warehouse, Query plan ) etc.

-          SQL performance tuning

-          Exp with AWS well architected framework

Soft Skills

(Required)

-           Demonstrated leadership on medium to large-scale projects impacting strategic priorities.

-          Ability to cope with shifting priorities, demands and timelines through analytical and problem-solving skills.

-          Ability to effectively prioritize, delegate responsibilities and execute tasks in a high-pressure environment.

Ability to work under pressure and within time constraints Passion for technology and an eagerness to contribute to a team-oriented environment