Senior Snowflake Platform Engineer

Staffing Spot, Inc.; Columbus (OH); Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Staffing Spot, Inc. seeks an experienced Data Engineer specializing in Snowflake to design, implement, and manage enterprise Snowflake environments across development, QA, and production.

You will architect scalable, highly available Snowflake solutions, align with business and technical requirements, and enforce RBAC, data masking, encryption, and secure data sharing to protect sensitive data. Responsibilities include monitoring performance, optimizing warehouses, and controlling costs;

Formación

• 7+ years in data engineering or cloud data platforms.
• 4+ years Snowflake platform engineering or administration.
• Strong knowledge of Snowflake security, performance tuning, and cost optimization.
• Proficient SQL and database development; hands-on automation skills.

Responsabilidades

• Design and manage enterprise Snowflake environments across development, QA and production.
• Architect scalable, highly available Snowflake solutions with RBAC and data sharing.
• Monitor performance, optimize warehouses, and control platform costs.
• Develop automated deployment processes using CI/CD and Infrastructure as Code.
• Implement Snowflake administration using Terraform, Python, SQL, and Snowflake APIs.
• Collaborate with data teams to optimize data models and pipelines.
• Provide mentorship to junior and mid-level engineers.

Conocimientos

Snowflake architecture

SQL development

Data engineering

Automation & CI/CD

Python scripting

Security & RBAC

Cloud platforms

Team mentorship

Herramientas

Terraform

Snowflake APIs

CI/CD tools

Python

Descripción del empleo

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

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

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

Skills: data,security,aws,snowflake,automation,ci,cloud,data engineering,azure,access