Job Details

ID #15539905
State Ohio
City Cincinnati
Job type Permanent
Salary USD TBD TBD
Source Pinnacle Group
Showed 2021-06-17
Date 2021-06-16
Deadline 2021-08-15
Category Architect/engineer/CAD
Create resume

Snowflake Architect

Ohio, Cincinnati, 45201 Cincinnati USA

Vacancy expired!

Title: Snowflake Solution Architect

Location: 100% remote but must be willing to work on the EST time zone

Experience & Certifications:
  • Minimum 5+ years of related experience in Snowflake
  • Experience using AWS services
  • Extensive hands-on experience with SQL
  • Snowflake Advanced certification - Architect - Desired (Nice to have)
  • Experience managing Snowflake implementation in a Enterprise environment
  • Experience securing sensitive data PII/PCI data in snowflake
  • Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
  • Knowledge of security controls for the Public cloud ( encryption of data in motion/rest and key management )
  • Hands-on experience in administering Snowflake in AWS . (standardization and automation of user onboarding and data onboarding in Snowflake.)
  • Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts

Job Summary:
  • Experienced Snowflake solution architect [SA], who will plan, design , develop and implement cloud data platform that follows industry best practices.
  • SA will be integral part of team that is responsible for technical deployments for Snowflake working with internal and external customers.
  • SA will have broad range of skills and experience ranging from security, performance analysis, ETL/ELT to build snowflake solution for specific use cases.
  • SA should have technical skills to be able to build and execute proposed solutions.

What you will be doing
  • Work in a globally distributed team to provide robust enterprise data platform in Snowflake
  • Design, optimize, document and implement the operational aspects in supporting the snowflake cloud platform. Including cost monitoring and optimizations, User security auditing
  • Implement/support automation for production deployment in Snowflake
  • Implement Snowflake standards and methodologies for DB security - both infrastructure and app level
  • Implement/support automation Snowflake - Accounts/Databases and access roles
  • Implement data sharing /replication - cross cloud/cross region for internal/external clients
  • Create Snowflake utilization and capacity plan
  • Propose and implement DB / Snowflake query performance optimizations.
  • Identify system bottlenecks and recommend solutions
  • Implement Snowflake user /query log analysis and alerts
  • Implement data encryption/decryption/masking policies to protect PII/PCI data

What you bring:
  • Technical expertise in all aspects of Snowflake
  • Experience implementing Snowflake external functions
  • Experience securing sensitive data PII/PCI data in snowflake
  • Hands-on experience in administering Snowflake in AWS .
  • Experience with AWS CLI and Networking
  • Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
  • Experience with architecting and maintaining high availability production systems
  • Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts
  • Knowledge of security controls for the Public cloud ( encryption of data in motion/rest and key management )
  • Demonstrated proficiency of index design, query plan optimization and analysis required
  • Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools
  • Experience with Agile and DevOps concepts
  • Development skills in Python or other scripting language
  • Knowledge of navigating Linux OS
  • Strong communication and written skills
  • Flexibility and willingness to jump in and get done what needs to be done to make snowflake and our users successful
  • Experience working collaboratively with broad range of people across different lines of business
  • Culture of continuous education to keep up to date on ever-evolving Snowflake product enhancement to be an authoritative resource for Snowflake

Experience & Certifications:
  • Minimum 5+ years of related experience in Snowflake
  • Experience using AWS services
  • Extensive hands-on experience with SQL
  • Snowflake Advanced certification - Architect - Desired
#LI-JK1

Vacancy expired!

Subscribe Report job