- Design, build, and optimize enterprise-scale Snowflake environments, including database architecture, schema design, data modeling, and performance tuning across large and complex datasets.
- Serve as the internal and client-facing Snowflake subject matter expert — defining standards, best practices, and governance frameworks for Snowflake implementation and ongoing operations.
- Lead the design and delivery of end-to-end data pipelines into and out of Snowflake, including ingestion, transformation, and consumption layers, leveraging Snowflake-native capabilities (Streams, Tasks, Dynamic Tables, Snowpipe) wherever appropriate.
- Architect and implement Snowflake data sharing, data marketplace, and cross-cloud/cross-region replication strategies for client environments.
- Define and enforce Snowflake security architecture including role-based access control (RBAC), column-level and row-level security, data masking policies, and network policies.
- Lead Snowflake performance optimization activities including clustering keys, materialized views, query profiling, warehouse sizing, and cost governance.
- Drive adoption of Snowflake best practices across client delivery teams, including query optimization, warehousing strategy, and data lifecycle management.
- Translate business and technical requirements into Snowflake-first solution designs, defining required work packages, resourcing, and delivery approach.
- Define and socialize technical approaches for Snowflake-based implementations including data migration strategies, SDLC standards, and integration patterns — influencing client teams toward best practice.
- Lead and mentor a team of data engineers, providing technical direction and code/design review within a Snowflake-centric delivery model.
- Present solution designs, architecture options, and delivery recommendations to business and technology stakeholders at all levels.
- Contribute to Alpha's internal Snowflake IP, accelerators, and proposition development.
- Participate in project team meetings and communicate effectively across internal and client peers, architects, analysts, project managers, and technology teams.
AWSPythonSQL+6 more