Director, Data Integration Engineer
New York City, NY - USA
Job Summary
ROLE SUMMARY
This role owns data integration engineering for the Medical Affairs AI Acceleration portfolio. It ensures all solutions are integrated successfully to source data. Working as an individual-contributor technical expert within the Engineering organization this role is directly accountable for the data pipelines and integration patterns that connect Medical Affairs AI solutions to existing enterprise data sources and analytic platforms. It ensures each new AI capability has reliable well-governed access to the data it needs without duplicating or re-architecting the underlying data platforms.
This is a hands-on engineering role that develops integration software to be leveraged in any Medical Affairs AI solution.
The role partners closely with Solution Architecture to implement the data integration standards and RAG/vector-database patterns defined at the architecture level and serves as the go-to data engineering expert for Product Management and UX/Experience Design partners seeking to understand what data is available where it lives and how reliably it can be surfaced.
The Director Data Integration Engineer owns the design build and operation of the data pipelines and integration layer that connect Medical Affairs AI-enabled products and platforms to existing data sources. Reporting to the Senior Director Engineering this role translates solution architecture and product requirements into reliable governed production-grade data pipelines that are leveraged in solutions the team is delivering for Medical Affairs. This is a technical hands-on role responsible for designing the integration and data-access patterns for each AI solution and building testing and operating them. This role partners closely with Build Engineers Solution Architecture and Product Management to ensure data readiness keeps pace with AI delivery.
ROLE RESPONSIBILITIES
Data Integration Architecture & Pipeline Engineering
Design and build data pipelines and integration patterns connecting core enterprise systems to Medical Affairs AI and analytics platforms and data sources.
Build and maintain targeted data pipelines that extract transform and serve the specific data each AI solution needs prioritizing reuse across solutions.
Establish and follow data pipeline coding standards for solution-level integration work aligning with the data models and cataloging practices maintained by the centralized data organization.
Monitor and manage data pipeline latency ensuring each AI solution receives data within the timeliness thresholds its use case requires.
AI & Data Enablement
Partner with Solution Architecture to implement data integration patterns supporting RAG pipelines vector databases GraphRAG (graph-structured retrieval context for LLMs) and other AI/ML data access patterns.
Ensure data feeding Agentic AI and LLM-based systems is well-governed accurately labeled and monitored for quality and drift.
Apply automation techniques (AI/ML low-code/no-code tooling where appropriate) to accelerate data delivery.
Support context-aware and context-driven AI models by ensuring underlying data structures capture the necessary business context.
Data Governance Quality & Compliance
Collaborate and partner with the centralized Commercial AI Data Strategy team to align on data profiling sourcing and investigation.
Apply data governance and data cataloging best practices maintaining data dictionaries lineage documentation and playbooks.
Ensure data integration practice complies with Pfizer data privacy and regulatory standards (GDPR HIPAA GxP as applicable).
Own identification and classification of personal information (PI/PII) flowing through integration pipelines and apply masking tokenization or de-identification before sensitive data is stored in a vector database or made accessible to AI/ML systems.
Cross-Functional Partnership & Delivery
Partner with the Senior Director Engineering and Build Engineers to ensure data pipelines are delivered in step with product and platform build cycles.
Partner with Solution Architecture to ensure data integration design aligns with enterprise architectural standards and reuse patterns.
Continuous Improvement
Drive best practices and world-class data engineering capability staying current with modern data platform technology (e.g. Snowflake graph databases) and AI-enabled data tooling.
Establish a culture of high performance transparency and continuous improvement within the data integration discipline.
BASIC QUALIFICATIONS
Candidate demonstrates a breadth of diverse leadership experiences and capabilities including: the ability to influence and collaborate with peers develop and coach others oversee and guide the work of other colleagues to achieve meaningful outcomes and create business impact.
Bachelors degree in Computer Science Data Analytics or related field.
8 years of hands-on data engineering or application integration experience including building data pipelines and APIs that connect applications to existing data platforms.
Advanced proficiency in SQL and hands-on experience building ETL/ELT pipelines.
Experience consuming and integrating with modern data platform technologies (e.g. Snowflake or equivalent) including querying API-based access and working within an existing data governance framework.
Experience with API design and integration patterns (REST/GraphQL event-driven or streaming integration) for connecting applications to backend data sources.
Experience with data analytics automation and business process automation using AI ML low-code or no-code tools.
Experience supporting RAG pipelines vector databases or other AI/ML data access patterns.
Solid understanding of Agile delivery and CI/CD practice.
Experience identifying and protecting personal information (PI/PII) in data pipelines including applying data masking tokenization or de-identification techniques before sensitive data reaches AI-accessible stores such as vector databases.
Good knowledge of data governance and data cataloging best practices.
Experience partnering with engineering architecture and business stakeholders in a matrixed delivery model.
Excellent communication and stakeholder management skills.
Familiarity with data privacy standards and pharma industry compliance practices (GDPR HIPAA GxP).
Direct experience integrating with Veeva CRM Salesforce Life Sciences/Marketing Cloud or other Medical Affairs systems via API.
Familiarity with GraphRAG patterns using graph-structured data to organize retrieval context for LLMs as a complement to standard vector-based RAG.
PREFERRED QUALIFICATIONS
Experience in pharmaceutical life sciences or another regulated industry; Medical Affairs or commercial life sciences data experience a significant plus.
Experience with API gateway/middleware technologies and event-streaming platforms for real-time application integration.
Advanced degree in a technical field.
Non-Standard Work Schedule Travel or Environment Requirements
Must be able to travel to Pfizer offices vendor offices and other team meeting locations when required.
Project work can sometimes be demanding and require work during off-hours to coordinate with global stakeholders or respond to data or production incidents.
OTHER JOB DETAILS:
Last Date to Apply for Job:September 24 2026
Locations: NYHQ or PA-Collegeville
NOT Eligible for Relocation Package
Position is hybrid and will require to work 2 to 3 days per week site
#LI-PFE
The annual base salary for this position ranges from $176600.00 to $294300.00. In addition this position is eligible for participation in Pfizers Global Performance Plan with a bonus target of 20.0% 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 lifes 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 (). 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. This role is posted in multiple locations. If you are applying for the role in an secondary job posting location where pay transparency regulations apply your Talent Advisor will share the local pay information with you during the first interview.Relocation assistance may be available based on business needs and/or eligibility.
Candidates must be authorized to be employed in the U.S. by any employer.
U.S. work visa sponsorship (such as TN O-1 H-1B etc.) is not available for this role now or in the future.
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 providers 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 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. 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.
To learn more about acceptable and prohibited uses of AI during the recruitment process please review our candidate AI-use guidelines available onPfizer Careers.
Information & Business TechRequired Experience:
Director
About Company
Erfahren Sie mehr über uns als forschendes und produzierendes Pharmaunternehmen: Von unserem Beitrag zum medizinischen Fortschritt bis zur nachhaltigen Produktion.