Director, Data Integration Engineer

ROLE SUMMARYThis 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 RESPONSIBILITIESData Integration Architecture & Pipeline EngineeringDesign 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 EnablementPartner 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 & ComplianceCollaborate 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 & DeliveryPartner 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 ImprovementDrive 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 QUALIFICATIONSCandidate 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 QUALIFICATIONSExperience 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 RequirementsMust 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, 2026Locations: NYHQ or PA-CollegevilleNOT Eligible for Relocation Package Position is hybrid and will require to work 2 to 3 days per week site #LI-PFEThe 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 ActPfizer 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 EligibilityPfizer 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 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 View email address on click.appcast.io. 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 TechSummaryLocation: United States - New York - New York City; United States - Pennsylvania - CollegevilleType: Full time