Manager, Snowflake Architect and Engineer

ROLE SUMMARY
Pfizer's commitment to creating breakthroughs that change patients' lives is deeply embedded in our culture as a science-driven and patient-focused company. Central to this commitment is our use of digital technologies, AI, data, and analytics, which drive innovation across our organization.
The Platform Delivery and Operations team, which is part of the Artificial Intelligence, Data, and Advanced Analytics organization, provides a comprehensive suite of integrated platform technologies that are core components of Pfizer's data and analytics ecosystem.
These platforms are used by teams across Pfizer to harness the potential of big data, machine learning, interactive analytics, and AI - from scientific/clinical to commercial to operations across all Pfizer geographies.
One of these key platform technologies is the Snowflake Data Cloud. Snowflake is a Software as a Service cloud data warehousing platform. Snowflake supports the data for Pfizer applications in Commercial, Manufacturing, HR, Finance, Master Data Management, Real World Data and many others. The platform leverages the infrastructure and functionality of the cloud provider to create a very scalable, flexible, and cost-effective platform for Pfizer solutions.
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 associate's 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 Snowflake's capabilities.
• Experience with authentication and authorization systems like LDAP, AD, and AWS IAM
• Knowledge of the use of GitHub
• Application architecture and solutioning experience

Other Job Details:

• Last Date to Apply for Job: November 6, 2025
• Additional Location Information: Open to Thessaloniki, Greece or Mumbai, India or Chennai, India as well.
• Work Location Assignment: Hybrid. Must be able to work from assigned Pfizer office 2-3 days per week, or as needed by the business

The annual base salary for this position ranges from $86 800,00 to $144 600,00. In addition, this position is eligible for participation in Pfizer's Global Performance Plan with a bonus target of 12,5% of the base salary and eligibility to participate in our share based long term incentive program. We offer comprehensive and generous benefits and programs to help our colleagues lead healthy lives and to support each of life's moments. Benefits offered include a 401(k) plan with Pfizer Matching Contributions and an additional Pfizer Retirement Savings Contribution, paid vacation, holiday and personal days, paid caregiver/parental and medical leave, and health benefits to include medical, prescription drug, dental and vision coverage. Learn more at Pfizer Candidate Site - U.S. Benefits | (uscandidates.mypfizerbenefits.com). Pfizer compensation structures and benefit packages are aligned based on the location of hire. The United States salary range provided applies to the Tampa, FL location only. The salary range provided does not apply to any other United States location or locations outside of the United States.
Relocation assistance may be available based on business needs and/or eligibility.
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.
Information & Business Tech