Principal SAP Architect
Boeing
CloudIoT
Manager, Snowflake Architect, Engineer
Pfizer
full-time
Posted on:
Location Type: Hybrid
Location: Tampa • Florida • 🇺🇸 United States
Visit company websiteSalary
💰 $86,800 - $144,600 per year
Job Level
Mid-LevelSenior
Tech Stack
AWSAzureCloudGoogle Cloud PlatformPythonSQL
About the role
- 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
Requirements
- BA/BS preferably in computer science or related discipline with at least 4 years of experience, 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, 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, knowledge of query optimization techniques (e.g., clustering keys, materialized views, caching strategies)
- 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.
Benefits
- 401(k) plan with Pfizer Matching Contributions
- Additional Pfizer Retirement Savings Contribution
- Paid vacation
- Holiday and personal days
- Paid caregiver/parental and medical leave
- Health benefits including medical, prescription drug, dental, and vision coverage
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Snowflake Data CloudSQLPythonDynamic TablesSnowpipe StreamingSnowparkHybrid TablesData SharingReplicationOpenflow
Soft skills
collaborationcommunicationproblem-solvinganalytical skillsmentoringindependentenergetic personalityinfluencing best practicesinterface with technical individualsinterface with non-technical individuals
Similar jobs on JobTailor
Application Observability Architect, Engineer
Bank of America
AnsibleAWSCloudJenkinsLinuxPythonSDLCShell ScriptingTerraform
Principal Systems Design – Architecture Engineer
NTT DATA, Inc.
AWSAzureCloud
Application Observability Architect – Engineer
Bank of America
AnsibleAWSCloudJenkinsLinuxPythonSDLCShell ScriptingTerraform