Snowflake Platform Architect & Automation Lead

Staffing Spot, Inc.; Charlotte (NC); On-site; USD 120,000 - 190,000; Full time

Job summary

Staffing Spot, Inc. seeks a Senior Snowflake Platform Engineer to design, implement, and optimize enterprise Snowflake environments for development, QA, and production. You will manage accounts, warehouses, schemas, and security, while enforcing RBAC and data governance across AWS, Azure, or GCP.

The role emphasizes performance tuning, cost optimization, and automation using Terraform, Python, SQL, and Snowflake APIs, with strong collaboration across data teams and a focus on resiliency and DR.

Qualifications

• 7+ years of experience in data engineering, data platforms, cloud engineering, or related roles.
• 4+ years of hands-on experience with Snowflake platform engineering or administration.
• Strong expertise in Snowflake architecture, security, performance tuning, and cost optimization.
• Strong SQL and database development experience.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Experience with Snowflake features including Snowpipe, Streams, Tasks, Dynamic Tables, Time Travel, Zero-Copy Cloning, Secure Data Sharing, and Resource Monitors.
• Strong understanding of Snowflake RBAC, access controls, data governance, and security.
• Experience with Python and/or scripting for automation.
• Experience with Terraform or other Infrastructure-as-Code technologies.
• Hands-on experience with CI/CD tools such as Jenkins, GitHub Actions, GitLab CI, or Azure DevOps.
• Experience with Git and modern DevOps practices.
• Strong troubleshooting, analytical, and problem-solving skills.
• Excellent communication and collaboration skills.

Responsibilities

• Design, implement, and manage enterprise Snowflake environments across development, QA, and production.
• Architect scalable and highly available Snowflake solutions aligned with business and technical requirements.
• Manage Snowflake accounts, warehouses, databases, schemas, roles, users, resource monitors, and security policies.
• Implement Snowflake security best practices, including RBAC, data masking, row access policies, encryption, and secure data sharing.
• Monitor and optimize Snowflake performance, query execution, warehouse utilization, and overall platform costs.
• Develop and maintain automated deployment processes using CI/CD and Infrastructure as Code.
• Implement Snowflake administration and automation using tools such as Terraform, Python, SQL, and Snowflake APIs.
• Manage integrations between Snowflake and cloud services such as AWS, Azure, or GCP.
• Support data ingestion and integration patterns using Snowpipe, Snowpipe Streaming, external stages, APIs, and ETL/ELT tools.
• Establish platform monitoring, alerting, logging, governance, and operational best practices.
• Troubleshoot complex Snowflake performance, connectivity, security, and data platform issues.
• Develop standards and reusable frameworks for Snowflake development and platform operations.
• Collaborate with data engineering teams to optimize data models, pipelines, and workloads.
• Participate in capacity planning, disaster recovery, business continuity, and platform resiliency initiatives.
• Provide technical leadership and mentorship to junior and mid-level engineers.
• Stay current with Snowflake features, cloud technologies, data engineering practices, and platform engineering trends.

Job description

Staffing Spot, Inc. seeks a Senior Snowflake Platform Engineer to design, implement, and optimize enterprise Snowflake environments for development, QA, and production. You will manage accounts, warehouses, schemas, and security, while enforcing RBAC and data governance across AWS, Azure, or GCP.

The role emphasizes performance tuning, cost optimization, and automation using Terraform, Python, SQL, and Snowflake APIs, with strong collaboration across data teams and a focus on resiliency and DR.