Director, Data Integration Engineer

Pfizer; Collegeville (PA); Hybrid; USD 177,000 - 294,000; Full time

Benefits offered by this job

Bonus target 20%

401(k) plan with Pfizer matching

Comprehensive health benefits

Job summary

Pfizer in Collegeville now seeks a Senior Data Integration Engineer to design and operate data pipelines that connect Medical Affairs AI solutions with enterprise data sources. This hands-on role partners with architecture to implement RAG and vector database patterns, ensuring governed, production-grade data access for AI capabilities.

You'll own data integration standards, manage latency, and collaborate across product management and UX teams to surface trusted data while complying with

Qualifications

• Breadth of leadership and collaboration experience, capable of coaching others.
• Advanced proficiency in SQL and hands-on ETL/ELT experience.
• Experience with API design and integration patterns (REST/GraphQL).
• Experience with data governance and cataloging best practices.
• Experience supporting RAG pipelines, vector databases, or similar AI data access patterns.

Responsibilities

• Design and build data pipelines and integration patterns for core enterprise systems to Medical Affairs' AI platforms.
• Ensure data pipelines are reusable across solutions and meet latency thresholds.
• Collaborate with Solution Architecture to implement RAG, vector databases, and GraphRAG patterns.
• Maintain data governance, labeling, and monitoring for quality and drift.
• Ensure compliance with GDPR, HIPAA, and GxP data privacy standards.

Skills

Leadership & collaboration

Communication & stakeholder mgmt

Agile delivery & CI/CD

SQL proficiency

API design & integration

Data governance & cataloging

Education

Bachelor's degree in CS/Analytics or related

Advanced degree in a technical field

Tools

Snowflake

Graph databases

Veeva CRM

Salesforce Life Sciences

Job description

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.
• Bachelor's 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 $176,600.00 to $294,300.00.

In addition, this position is eligible for participation in Pfizer's 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 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. 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 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 have licensed physicians who incur 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 www.pfizer.com/careers accessible 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 [e-mail]. 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 on Pfizer Careers. Information & Business Tech Pfizer careers are like no other. In our culture of individual ownership, we believe in our ability to improve future healthcare, and potential to transform millions of lives. We're looking for new talent to join our global community, to unearth new innovative therapies that make the world a healthier place.