Sr Associate, Data Engineer

Role Summary

Pfizer has established a chief digital office which will lead the transformation of Pfizer into a digital powerhouse that will generate patient superior patient experiences that will result in better health outcomes.

The Enterprise Data and Analytics team, which is part of AI & Data Organization within the Chief Digital Office is responsible for the development and management of all data and analytic tools and platforms across the enterprise – from manufacturing to global product development and for all Pfizer countries. One of the team’s top priorities is the development of an enterprise data lake which will serve as the engine for the company’s digital transformation. 

Pfizer is seeking a Data Engineer to help realize Pfizer Digital strategy on the cloud by designing and delivering data products. Data Engineer will design, architect and build upon our PGS (Pfizer Global Supply) Data Lake to develop value added data products that span the areas of Supply Chain Execution, Planning, Manufacturing, Quality, Logistics etc.

The Supply Chain Data Engineer will be hands on and have abilities to work with a group of talented engineers and partners with Digital Partner(s), Enterprise Architecture, and Business Unit stakeholders to develop and sustain the PGS data strategy and target data architecture. Data engineers also partner with solution development teams to ensure use case delivery goals while adhering to data architecture principles, guidelines, and standards

Role Responsibilities

Reporting to the Data Management Sr Manager, the Sr Associate Data Engineer will be responsible for data modeling and engineering with advanced data platforms team to drive digital outcomes.

• Conceive, design, and implement Cloud Data Lake, Data Warehouse, Data Marts, and Data APIs 

• Develop complex data products that are beneficial for PGS and allow for reusability across enterprise.

• Ability to work with a team of contractors that will deliver technical enhancements

• Design automated solutions for building, testing, monitoring, and deploying ETL data pipelines in a continuous integration environment

• Develop internal APIs and data solutions to power applications and promote connectivity

• Expand Pfizer’s portfolio of capabilities through coherent APIs for internal users and third parties.

• Develop new systems and tools to enable the teams to consume and understand data more intuitively

• Coordinate with backend engineering team to analyze data in order to improve the quality and consistency of our data

• Perform root cause analysis and resolve production and data issues

• Create test plans, test scripts and perform data validation

• Fine Tune SQL queries, programs, reports and ETL pipelines

• Help innovate by building POC’s and Pilot’s identifying new approaches improving efficiency and simplicity

• Build and maintain data dictionary and process documentation

• Ability to innovate and present solutions to leadership, management, architects and developers.

• Provide hands-on technical and thought leadership across development, product management, operations, and engineering management through effective communication. Actively develop mentoring relationships within or across teams to help others further their careers

Professional Experience and Educational Requirements

• Applicant must have a bachelor’s degree with three years of relevant experience; OR Master’s degree with one year of relevant experience; OR Associate's degree with six years of relevant experience; OR eight years of relevant experience with a high school diploma or equivalent

• 3+ years of experience as a Data Engineer / 3+ years of experience as a Data Architect (OR) 3+ years of experience Data warehousing, data modeling, and data transformation (OR) 3+ years of experience designing complex and inter - dependent data models for analytic use cases.3 or more years of experience with one or more general purpose programming languages, including but not limited to:

• Experience in Python, SQL, Java, Scala, Pyspark, C, C++, C#, Swift/Objective, or JavaScript

• Experienced with data preparation and ETL: Airflow, DBT, Fivetran, Kafka, Informatica, Talend, Alteryx, etc

• Experience with Software engineering best-practices, including but not limited to version control (Git, TFS, Subversion, etc.), CI/CD (Jenkins, Maven, Gradle, etc.), automated unit testing, Dev Ops.

• Understanding of Cloud platforms like snowflake, data bricks, S3, Redshift, Big query etc.

• Architected end-to-end data pipelines with a cloud or on prem stack

• Prior experience as a data modeler is a must

• Knowledge of Cloud computing, machine learning, text analysis, NLP & Web development experience is a plus

• Knowledge of Ontologies and Graph Databases (Neo4j, Titan, etc.) and query syntax is a plus

• Prior experience working for Biotech / Pharma companies is a plus

Professional and Leadership Characteristics

• Strategic Thinker: Understands the overall context, business implications and is able to think through a problem both conceptually and logically for better solutions

• Creative: Able to bring forth new ideas to improve our existing practices and takes calculated risks to innovate new capabilities within Pfizer Digital Business Analytics, with a focus on data products and analytics solutions

• Analytical Thinker: Understands how to synthesize facts and information from varied data sources, both new and pre-existing, into discernable insights and perspectives; takes a problem-solving approach by connecting analytical thinking with an understanding of business drivers and how BA can provide value to the organization

• Adaptable: Demonstrates flexibility in the face of shifting targets, thrives in new situations

• Pioneering: Pushes self and others to think about new innovation and digital frontiers and ways to conquer them

• Ambiguity Tolerant: Successfully navigates ambiguity to keep the organization on target and deliver against established timelines

• Strong Data and Information Manager: Understands and uses analytical skills/tools to produce data in a clean, organized way to drive objective insights 

• Exceptional Communicator: Can understand, translate, and distill the complex, technical findings of the team into commentary that facilitates effective decision making by senior leaders; can readily align interpersonal style with the individual needs of customers

• Highly Collaborative: Manages projects with and through others; shares responsibility and credit; develops self and others through teamwork; comfortable providing guidance and sharing expertise with others to help them develop their skills and perform at their best; helps others take appropriate risks; communicates frequently with team members earning respect and trust of the team  

• Proactive Self-Starter: Takes an active role in one’s own professional development; stays abreast of analytical trends, and cutting-edge applications of data

• Creative: Able to bring forth new ideas to improve our existing practices and takes calculated risks to innovate new capabilities within Business Analytics, with a focus on data products and analytics solutions

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: October 28th 2024

This role is not remote

The annual base salary for this position ranges from $74,900.00 to $124,800.00.* In addition, this position is eligible for participation in Pfizer’s Global Performance Plan with a bonus target of 7.5% of the base salary. 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 $67,400.00 to $112,300.00.

Relocation assistance may be available based on business needs and/or eligibility.

Information & Business Tech

#LI-PFE