Snowflake Platform Ownership Architects, builds, and owns OpenLoop's production Snowflake environment end-to-end — including multi-environment setups (dev/staging/prod), ingestion pipelines from AWS S3, scheduling, RBAC frameworks, and data masking policies. Ensures platform health through query performance optimization, warehouse cost management, and proactive monitoring as the environment scales.
Data Governance & Compliance Designs and implements data governance architectures that satisfy HIPAA and security review requirements, including dynamic data masking policies, row-level security, and role-based access control. Translates regulatory constraints into durable, auditable Snowflake governance controls.
Semantic & Dynamic View Layer Establishes a robust semantic and dynamic view layer that enables governed, self-serve data access across engineering, BI, analytics, and data science teams. Ensures downstream consumers can trust and access the data they need with consistency.
AWS-to-Snowflake Ingestion Engineering Designs and maintains scalable ingestion systems using S3-to-Snowflake integration patterns with AWS services (EventBridge, SQS, SNS, Lambda, Athena, Glue). Builds resilient pipelines with retry logic, rate-limit management, and idempotent processing for external API enrichment workflows.
Technical Strategy & Standards Defines data architecture standards and best practices where none currently exist. Acts as the go-to Snowflake authority for Data Engineers, Analytics Engineers, and cross-functional stakeholders. Drives architectural decisions that balance consistency, performance, cost efficiency, and security.
Cross-Functional Collaboration Partners closely with Engineering, Product, Security, Compliance, and SRE teams to ensure the data platform meets business requirements while maintaining strict security and performance standards. Communicates technical trade-offs and architecture decisions clearly to both technical and non-technical stakeholders.