ROLE SUMMARY
Responsible for technical ownership, strategic leadership, and enterprise enablement of the organization’s Snowflake data platform. This role serves as the primary subject-matter expert (SME) for Snowflake, guiding platform evolution, supporting regulated workloads, enabling application teams, and maximizing the value of Snowflake’s advanced analytics and AI capabilities across the enterprise. This role operates at the intersection of platform engineering, architecture, vendor partnership, and community leadership, with broad impact across Digital, Data, and AI initiatives.
ROLE RESPONSIBILITIES
Act as the enterprise Practice Lead and Principal Engineer for the Snowflake platform, providing technical direction and decision-making authority.
Assume leadership of the Snowflake environment following prior platform leadership transitions, ensuring continuity and stability.
Own platform-level decisions that impact enterprise-scale and regulated workloads, including GxP and SOX-aligned environments.
Provide deep expertise on Snowflake capabilities, including AI, Cortex, adaptive warehouses, multi-region deployments, and cost optimization patterns.
Advise downstream application and solution teams on Snowflake architecture patterns, migrations, and best practices.
Partner with architecture and platform teams to ensure Snowflake is tightly integrated into the broader enterprise ecosystem.
Drive innovation through proofs of concept and advanced platform features, including AI-driven agents, natural language interaction, and automation.
Lead or contribute to platform extensions that simplify usage, improve supportability, and enhance developer experience.
Guide platform readiness for new Snowflake releases by assessing scope, risk, and impact.
Serve as a key technical partner to Digital, business, architecture, and delivery teams across the organization.
Work directly with the Snowflake vendor and Resident Solution Architects on escalations, roadmap alignment, and feature adoption.
Lead enterprise communications around Snowflake features, changes, and deprecations to a large global user base.
Ensure Snowflake platform implementations meet enterprise compliance, security, and data protection standards, including regulated GxP workloads.
Partner with platform support teams to optimize monitoring, ticketing integration, and operational efficiency.
Act as a go-to expert and mentor for Snowflake engineers and platform team members.
Lead technical interviews and skill assessments for Snowflake-related roles.
Foster an active Snowflake community of practice through knowledge sharing, sessions, and best-practice dissemination.
BASIC QUALIFICATIONS
BA/BS preferably in in computer science or related discipline with at least 6 years of experience or MBA/MS with at least 5 years of experience or PhD/JD with 1 year of 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.
Deep hands-on expertise with Snowflake platform capabilities and enterprise-scale implementations, particularly Snowflake Cortex AI capabilities.
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.
PREFERRED QUALIFICATIONS
Deep hands-on expertise with Snowflake platform capabilities and enterprise-scale implementations, particularly Snowflake Cortex AI capabilities.
Proven ability to solve complex technical and architectural problems in large, regulated environments.
Strong stakeholder engagement skills, with experience influencing teams across Digital and business units.
Demonstrated leadership without direct line management, operating through technical authority and trust.
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).
Data Modeling: Expertise in designing efficient data models optimized for Snowflake's capabilities.
Experience with authentication and authorization systems like LDAP, AD, and AWS IAM
Application architecture and solutioning experience
Candidate demonstrates a breadth of diverse leadership experiences and capabilities including: the ability to influence and collaborate with peers, develop and coach others, oversee and guide the work of other colleagues to achieve meaningful outcomes and create business impact.
Other Job Details:
Last Date to Apply for Job: August 3, 2026
Work Location Assignment: Hybrid. Must be able to work from assigned Pfizer office 2-3 days per week
Relocation assistance may be available based on business needs and/or eligibility.
Candidates must be authorized to be employed in the U.S. by any employer.
U.S. work visa sponsorship (such as TN, O-1, H-1B, etc.) is not available for this role now or in the future.
Sunshine Act
Pfizer reports payments and other transfers of value to health care providers as required by federal and state transparency laws and implementing regulations. These laws and regulations require Pfizer to provide government agencies with information such as a health care provider’s name, address and the type of payments or other value received, generally for public disclosure. Subject to further legal review and statutory or regulatory clarification, which Pfizer intends to pursue, reimbursement of recruiting expenses for licensed physicians may constitute a reportable transfer of value under the federal transparency law commonly known as the Sunshine Act. Therefore, if you are a licensed physician who incurs recruiting expenses as a result of interviewing with Pfizer that we pay or reimburse, your name, address and the amount of payments made currently will be reported to the government. If you have questions regarding this matter, please do not hesitate to contact your Talent Acquisition representative.
EEO & Employment Eligibility
Pfizer is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status. Pfizer also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as work authorization and employment eligibility verification requirements of the Immigration and Nationality Act and IRCA. Pfizer is an E-Verify employer. This position requires permanent work authorization in the United States.
Pfizer endeavors to make www.pfizer.com/careers accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process and/or interviewing, please email [email protected]. This is to be used solely for accommodation requests with respect to the accessibility of our website, online application process and/or interviewing. Requests for any other reason will not be returned.
To learn more about acceptable and prohibited uses of AI during the recruitment process, please review our candidate AI-use guidelines available on Pfizer Careers.
Information & Business TechSkills Required
- BA/BS in Computer Science or related with ≥6 years experience, or MBA/MS with ≥5 years, or PhD/JD with ≥1 year
- Strong knowledge of the Snowflake Data Cloud and features (Dynamic Tables, Snowpipe Streaming, Snowpark/Container Services, Hybrid Tables, Data Sharing, Replication, Iceberg, Openflow)
- Strong SQL skills tailored to Snowflake (window functions, semi-structured data handling, UDFs, time travel, query optimization, clustering, materialized views, caching)
- Deep hands-on expertise with Snowflake platform capabilities and enterprise-scale implementations, particularly Snowflake Cortex AI
- Python skills and ability to work with and read code
- Knowledge of Snowflake access methods (OAuth, PAT, local accounts, ODBC, JDBC) and security features (roles, policies, masking) for access/security troubleshooting
- Authorized to be employed in the U.S. (permanent U.S. work authorization); U.S. work visa sponsorship is not available
- Ability to work hybrid from assigned Pfizer office 2-3 days per week
- Experience integrating Snowflake with ETL/ELT tools (dbt, Matillion), BI tools (Tableau, Power BI), and orchestration tools (Apache Airflow)
- Experience with authentication and authorization systems such as LDAP, Active Directory, and AWS IAM
- Proven ability to solve complex technical and architectural problems in large, regulated environments (e.g., GxP, SOX)
- Data modeling expertise optimized for Snowflake
- Application architecture and solutioning experience
- Strong stakeholder engagement and leadership without direct line management
What the Team is Saying
Pfizer Compensation & Benefits Highlights
-
Healthcare Strength — Multiple U.S. medical plan options include telehealth, comprehensive mental‑health support, fertility/family‑building benefits, transgender‑inclusive coverage, and certain Pfizer medications at no cost. A Wellbeing Wallet and wellness resources broaden the health and wellbeing offering.
-
Retirement Support — A 401(k) with company matching is paired with an additional Pfizer Retirement Savings Contribution, alongside company‑paid life and disability insurance. One‑on‑one financial planning support is provided through Fidelity.
-
Leave & Time Off Breadth — Paid time off spans vacation, holidays, and personal days, with additional caregiver and medical leave. U.S. parental leave commonly includes 12 weeks paid with options for additional unpaid bonding time and a return‑to‑work transition.
Pfizer Insights
What We Do
Our purpose ensures that patients remain at the center of all we do. We live our purpose by sourcing the best science in the world; partnering with others in the healthcare system to improve access to our medicines; using digital technologies to enhance our drug discovery and development, as well as patient outcomes; and leading the conversation to advocate for pro-innovation/pro-patient policies.
Why Work With Us
We are the inventors, the problem solvers, the big thinkers — those who surmount any hurdle to deliver breakthrough medicines to the people who are counting on them the most.
Gallery
Pfizer Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
