Job Title = Snowflake Architect / Snowflake Integration Architect / Snowflake – Aws Integration Architect
Location = Day 1 On Site Hybrid Position at Chicago, IL OR Peoria IL [ 2 To 3 Days in a week in the office ]
Job Code = 38372
Duration = 12 Months Contract Position on C2C/W2
Visas = Green Card, US Citizen, H1B, H1B1, H2B, H4EAD, L1A, L1B, L2 EAD, GC EAD, E3, E3D, TN1, TN2, TN1EAD , TN2 EAD, OPT EAD, CPT EAD, TPS, Asylum Visa.
Experience Required = 10+ Years
Client = Direct Client
Technologies Required = Mandatory = 1) 3+ years Snowflake Architect level experience 2) 5+ AWS Cloud Experience 3) 3+ Implementations in snowflake and understand the advanced capabilities like ML Model deployment 4) Snowflake Optimization experience ( Auto clustering , Warehouse, Query plan ) 5) SQL 6) AWS Certification
Job Description =
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)
Education & Experience Required:
· 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. REQUIRED: Snowflake certification
· REQUIRED: AWS Certification SA (Solutions Architect) or Data and Analytics specialty Critical
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
Disqualifiers/Red Flags:
· If the candidate does not have AWS experience and it is not demonstrated in the resume how they utilized AWS, they will DQ.
· Candidates’ current location must be on resume, if not it will be DQ not exceptions.
· If candidate is not currently in Chicago/Peoria area, DO NOT submit them, they will be DQ.
· If candidate is open to relocating on their own dime, please list that on the resume ( these candidates will not be shortlisted initially for WD review)