Platform Lead - Snowflake

We are seeking a skilled and proactive Platform Lead with strong Snowflake expertise and AWS cloud exposure to lead the implementation and operational excellence of a scalable, multitenant modern data platform for a leading US-based marketing agency serving nonprofit clients. This role requires hands-on experience in managing Snowflake environments, supporting data pipeline orchestration, enforcing platform-level standards, and ensuring observability, performance, and security across environments. You will collaborate with architects, engineers, and DevOps teams to operationalize the platform’s design and drive its long-term stability and scalability in a cloud-native ecosystem.

Job Specific Duties & Responsibilities:

• Lead the technical implementation and stability of the multitenant Snowflake data platform across dev, QA, and prod environments
• Design and manage schema isolation, role-based access control (RBAC), masking policies, and cost-optimized Snowflake architecture for multiple nonprofit tenants
• Implement and maintain CI/CD pipelines for dbt, Snowflake objects, and metadata-driven ingestion processes using GitHub Actions or similar tools
• Develop and maintain automation accelerators for data ingestion, schema validation, error handling, and onboarding new clients at scale
• Collaborate with architects and data engineers to ensure seamless integration with source CRMs, ByteSpree connectors, and downstream BI/reporting layers
• Monitor and optimize performance of Snowflake workloads (e.g., query tuning, warehouse sizing, caching strategy) to ensure reliability and scalability
• Establish and maintain observability and monitoring practices across data pipelines, ingestion jobs, and platform components (e.g., error tracking, data freshness, job status dashboards)
• Manage infrastructure-as-code (IaC), configuration templates, and version control practices across the data stack
• Ensure robust data validation, quality checks, and observability mechanisms are in place across all platform services
• Support incident response, pipeline failures, and technical escalations in production, coordinating across engineering and client teams
• Contribute to data governance compliance by implementing platform-level policies for PII, lineage tracking, and tenant-specific metadata tagging

Required Skills, Experience & Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related technical field
• 6+ years of experience in data engineering or platform delivery, including 3+ years of hands-on Snowflake experience in production environments
• Proven expertise in building and managing multi tenant data platforms, including schema isolation, RBAC, and masking policies
• Solid knowledge of CI/CD practices for data projects, with experience guiding pipeline implementations using tools like GitHub Actions
• Hands-on experience with dbt, SQL, and metadata-driven pipeline design for large-scale ingestion and transformation workloads
• Strong understanding of AWS cloud services relevant to data platforms (e.g., S3, IAM, Lambda, CloudWatch, Secrets Manager)
• Experience optimizing Snowflake performance, including warehouse sizing, caching, and cost control strategies
• Familiarity with setting up observability frameworks, monitoring tools, and data quality checks across complex pipeline ecosystems
• Proficient in infrastructure-as-code (IaC) concepts and managing configuration/versioning across environments
• Awareness of data governance principles, including lineage, PII handling, and tenant-specific metadata tagging