Manager, Snowflake Architect and Engineer

ROLE SUMMARY

Technology impacts everything we do. Pfizer’s digital and ‘data first’ strategy focuses on implementing impactful and innovative technology solutions across all functions from research to manufacturing. Whether you are digitizing drug discovery and development, identifying solutions, or making our work easier and faster, you will be making a difference to countless lives.

ROLE RESPONSIBILITIES

The Platform Delivery and Operations team, which is part of the Artificial Intelligence, Data and Advanced Analytics (AIDA) organization, provides a comprehensive suite of integrated platform technologies that are core components of Pfizer’s data and analytics ecosystem.
The AIDA platforms are used by teams across Pfizer to harness the potential of big data, machine learning, and interactive analytics – from scientific/clinical to commercial 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 which use Snowflake

• 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

QUALIFICATIONS

• Maintain Platform Standards including naming standards, role based access standards and warehouse usage

• Enhance usage monitoring with dashboards and monitoring tools and use this information to help our Snowflake users optimize their warehouse usage and SQL queries

• Help new Snowflake applications or existing applications migrating to Snowflake with solution architecture that is best for a Snowflake implementation

• Become well versed with unique Snowflake features such as Dynamic tables, Snowpipe Streaming, Snowpark, Hybrid tables, Data Sharing, Replication, Iceberg so they can be shown and suggested to be part of application architectures.

• Activate and maintain Snowflake features in our different accounts.

• Snowflake Release Management.  Understand what is part of a new release to see if it may affect our environment.

• Help to build extensions to our Snowflake environment which make it more supportable and usable.

• Collaborate with vendors and internal engineering teams on evaluating new technologies, supportability.

• Directly engage and communicate with key business and technical stakeholders.

• 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 

• Collaborate with engineering and support teams on platform lifecycle management 

• Support change governance and continuous improvement efforts

Qualifications Must-Have

• Bachelor's degree with 5 years of relevant experience OR Master's degree with 3 years of relevant experience OR associate's degree with 8 years of relevant experience OR PHD with 0 years of relevant experience OR 10 years of relevant experience with a high school diploma or equivalent

• Experience with engineering or technical role experience, ideally involving a complex and rapidly evolving software/product

• Comfort working with and reading code.

• Experience working with at least one type of relational database and SQL.

• Some experience with cloud platforms such as AWS, Azure, and GCP.

• Some experience with python.

• Excellent problem solving and analytical skills with an aptitude for learning new technologies.

• Strong communication skills and the ability to interface with both technical and non-technical individuals as needed.

• Hands-on experience and proficiency with DevOps and information tools – e.g., JIRA, Confluence, SharePoint, Yammer, etc.

• Excellent verbal and written communication skills

Nice-to-Have

• Expertise with Snowflake Data Cloud

• Some experience with authentication and authorization systems like LDAP, AD, and IAM

• Some knowledge of theuse of Github

• Some knowledge of SQL tuning

• Some Application architecture and solutioning experience

NON-STANDARD WORK SCHEDULE, TRAVEL OR ENVIRONMENT REQUIREMENTS

Occasional travel

Work Location Assignment: Must be able to work in assigned Pfizer office 2-3 days per week, or as needed by the business

Last day to apply: November 26 th 2024

This role is not remote

The annual base salary for this position ranges from $93,500.00 to $155,900.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 does not apply to Tampa, FL or any location outside of the United States.

* The annual base salary for this position in Tampa, FL ranges from $84,200.00 to $140,400.00.

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.

Information & Business Tech

#LI-PFE