In this role, you will act as a platform architect and engineer to create and maintain a user friendly, dependable, and optimized environment for application developers and users.
You will work with:
- Application developers helping them build and optimize their applications using Snowflake s capabilities and solution patterns
- Snowflake architects and support engineers who will help you enhance our implementation of the platform
- Resources from other software vendors (ETL, Reporting, Cataloging) who connect to Snowflake
- Application users
ROLE RESPONSIBILITIES
-
Advise teams on the use of unique Snowflake features as part of their application architecture.
-
Help new Snowflake applications, or existing applications migrating to Snowflake, with the most effective solution patterns recommended for a Snowflake implementation.
-
Partner with the Snowflake Platform team to support Snowflake Release Management by analyzing scope of new releases and assessing potential impact on environment.
-
Help in building extensions to the Snowflake environment to make it easier to use and support.
-
Mentor junior engineers to influence best practices.
-
Enhance usage monitoring with dashboards and monitoring tools and use this information to help Snowflake users optimize their warehouse usage and SQL queries.
-
Collaborate with vendors and internal engineering teams on evaluating new technologies and their supportability.
-
Collaborate with engineering and support teams on platform standards, lifecycle management, change governance, and continuous improvement efforts.
-
Collaborate with enterprise architecture to drive platform adoption and shape data strategy at Pfizer.
-
Directly engage and communicate with technical stakeholders on solution development and optimization.
-
Document knowledge in the form of incident notes, technical articles, and contributions to knowledge bases within specific areas of expertise.
-
Maintain key informational content, drive platform adoption, and champion a strong user community.
BASIC QUALIFICATIONS
-
BA/BS preferably in in computer science or related discipline with at least 4 years of experience or MBA/MS with at least 2 years of experience or PhD/JD with any years of experience or associates degree with at least 8 years of experience or high School Diploma (or Equivalent) with at least 10 years of relevant experience.
-
Strong knowledge of the Snowflake Data Cloud including features such as Dynamic Tables, Snowpipe Streaming, Snowpark/Container Services, Hybrid Tables, Data Sharing, Replication, Iceberg, Openflow, etc
-
Strong SQL skills tailored to Snowflake, including window functions, semi-structured data handling (e. g. , JSON, XML), UDFs, and time travel, and knowledge of query optimization techniques, e. g. , clustering keys, materialized views, and caching strategies to improve performance.
-
Python skills and mastery of working with and reading code.
-
Knowledge of Snowflake access methods (OAuth. , PAT, local accounts, ODBC, JDBC) and security features (roles, policies, masking) for access/security troubleshooting.
-
Experience with Snowflake monitoring tools/views.
-
Hands-on experience with utilizing DevOps, CI/CD tools
-
Experience with Cloud Platforms: AWS, Azure, GCP.
-
Excellent collaboration skills and the ability to interface with technical and non-technical individuals as needed.
-
Excellent oral and written communication skills and proficiency in using information tools, e. g. , MS O365 applications, JIRA, Confluence.
-
Self-starter, independent, energetic personality with excellent problem solving and analytical skills and an aptitude for learning new technologies.
PREFERRED QUALIFICATIONS
-
Knowledge of integrating Snowflake with external tools and platforms, such as ETL/ELT tools (e. g. , dbt, Matillion), BI tools (e. g. , Tableau, Power BI), and data orchestration tools (e. g. , Apache Airflow).
-
Knowledge of Snowflake AI capabilities: Cortex LLMs
-
Data Modeling: Expertise in designing efficient data models optimized for Snowflakes capabilities.
-
Experience with authentication and authorization systems like LDAP, AD, and AWS IAM
-
Knowledge of the use of GitHub
-
Application architecture and solutioning experience
