Sr Associate, Data Engineer - Pfizer
New York City, NY
About the Job
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.
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
