Snowflake Platform Architect: Scale, Secure & Optimize Data

TechDigital Group; Charlotte (NC); On-site; USD 140,000 - 190,000; Full time

Job summary

TechDigital Group is seeking a Snowflake Platform Lead to oversee configuring and optimizing Snowflake across the enterprise. You will ensure high performance, reliability, and security for data operations.

You will manage environments, implement RBAC/RLS/CLS, and coordinate with data engineers on ETL/ELT pipelines using Informatica, Talend, or DBT. Expect collaboration across teams and adherence to regulatory standards.

Qualifications

• Experience with Snowflake administration and data platforms.
• Strong SQL and data warehousing knowledge.
• Familiarity with CI/CD and infrastructure as code (Terraform).

Responsibilities

• Manage Snowflake accounts, warehouses, databases, schemas, roles, tasks, stages, streams, and pipes.
• Tune performance and control costs through warehouse sizing, clustering, and caching strategies.
• Implement RBAC, RLS, CLS, encryption, masking policies, and SSO/OAuth/MFA integration.

Skills

Snowflake Admin

SQL

Cloud Platforms

RBAC/RLS/CLS

DevOps

IaC

Scripting

Tools

Informatica

Talend

DBT

Azure Data Factory

Terraform

Azure DevOps

Python

Job description

Job Description
A Snowflake Platform Lead is responsible for managing, optimizing, and securing Snowflake's cloud data platform to ensure high performance, scalability, and reliability of data operations.

Core Responsibilities
Environment Management: Administer and configure Snowflake accounts, warehouses, databases, schemas, roles, tasks, stages, streams, and pipes to meet organizational needs

Performance & Cost Optimization: Monitor system performance, query execution, and workload management; tune warehouse sizes, clustering, partitioning, and caching strategies to improve efficiency and control costs

Security & Access Control: Implement and manage Role-Based Access Control (RBAC), Row-Level Security (RLS), Column-Level Security (CLS), encryption, masking policies, and integrate with SSO/OAuth/MFA for secure access

Data Integration & ETL: Support data ingestion pipelines using tools like Informatica, Talend, DBT, or Azure Data Factory; manage cloud storage integrations (AWS S3, Azure Blob, GCP) and ensure data quality

Backup & Disaster Recovery: Plan and manage backup strategies, failover, and data retention policies, leveraging Snowflake's built-in capabilities DataTerrain+1.

Automation & DevOps: Develop automation scripts (Python, Shell, PowerShell) and implement CI/CD pipelines using Terraform, Azure DevOps, or other IaC frameworks

Monitoring & Troubleshooting: Monitor system health, performance metrics, and usage; troubleshoot data load failures, query issues, and performance bottlenecks .

Governance & Compliance: Ensure compliance with data security standards (SOC2, HIPAA, GDPR), maintain audit logs, and implement data governance policies

Collaboration: Work closely with data engineers, analysts, and business teams; provide technical support and training on Snowflake features

Required Qualifications
Experience: Typically 3–10+ years of IT experience, with 3–5+ years in Snowflake administration DataTerrain+2.

Technical Skills: Strong understanding of Snowflake architecture, SQL, data warehousing, and cloud platforms (AWS, Azure, GCP) DataTerrain+2.
Familiarity with Cortex Code and other LLM based coding accelerators

Security: Expertise in RBAC, RLS, CLS, encryption, and compliance controls

Tools: Experience with ETL/ELT tools, CI/CD, IaC (Terraform), and scripting languages