Snowflake Architect

Ampcus Inc; Cincinnati (OH); Hybrid; USD 117,000 - 220,000; Full time

Job summary

Ampcus Inc is seeking a Snowflake Architect to join a globally distributed team. The role focuses on designing and operating a robust Snowflake data platform with emphasis on performance, security, and cost control.

The candidate will work in a hybrid setup across Cincinnati, OH and Atlanta, GA, on a 6-month contract. Responsibilities include implementing Snowflake standards, automating deployments, managing accounts/roles, and enabling cross-cloud data sharing while optimizing queries and

Qualifications

• Technical expertise in Snowflake architecture, security and optimization.
• Experience with Snowflake external functions and governance practices.
• Hands-on administration of Snowflake on AWS and cloud data platforms.
• Experience with AWS CLI and networking concepts.
• Knowledge of security controls for cloud data (encryption, key management).
• Familiarity with monitoring, logging, and alerting in data environments.

Responsibilities

• Design, optimize, document, and implement Snowflake platform operations including cost monitoring and security auditing.
• Implement and support automation for Snowflake production deployments.
• Enforce Snowflake standards for DB security at infrastructure and application levels.
• Administer Snowflake accounts, databases, and access roles.
• Enable data sharing/replication across clouds and regions for internal/external clients.
• Create capacity and utilization plans; optimize queries for performance.
• Identify bottlenecks and propose solutions; implement log analysis and alerts.
• Work as Snowflake admin on AWS: configuration, data migration, security.

Skills

Snowflake

AWS

Python

DevOps

Automation

Security

Tools

AWS CLI

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title

Snowflake Architect

Location(s)

Cincinnati, OH./ Atlanta, GA. (Hybrid)

Duration

6 Months Contract (Possibility of extension)

Job Summary

Work in a globally distributed team to provide a robust enterprise data platform in Snowflake, ensuring optimal performance, security, and efficiency.

Key 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.

Required Qualifications

• 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.

Added bonus if you have

• AWS certification.


• Snowflake Certifications.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.