Snowflake Architect

Ampcus Inc.•Cincinnati, OH

1d•Hybrid

About The Position

Ampcus Inc. is seeking a highly motivated Snowflake Architect to join their talented team. This role involves working in a globally distributed team to provide a robust enterprise data platform in Snowflake, ensuring optimal performance, security, and efficiency. The position is a 6-month contract with the possibility of extension, located in Cincinnati, OH or Atlanta, GA, with a hybrid work model.

Requirements

Technical expertise in all aspects of Snowflake.
Experience in 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.
Hands-on experience in administration of relational Databases, Data Warehouse and Data marts.
Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools.
Experience with Agile and DevOps concepts.
Strong development skills in Python or other scripting language.

Nice To Haves

AWS certification.
Snowflake Certifications.

Responsibilities

Design, optimize, document, and implement operational aspects in supporting the Snowflake cloud data 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 for administering 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.
Work as admin on Snowflake on AWS i.e., Configuration, Data migration and security.