Manager, Data Foundations & Integration

PharmaEssentia U.S.A.; Burlington (MA); Híbrido; USD 140.000 - 182.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Comprehensive medical coverage

Dental and vision coverage

Generous paid time-off

401(k) retirement plan with company…

Medical & Dependent Care Flexible Spen

Cell phone reimbursement

Employee Assistance Program

Free parking

Descripción de la vacante

PharmaEssentia USA is hiring a Manager, Data Foundations & Integration in Burlington, MA. Lead data ingestion, governance, and vendor-backed ETL pipelines into our data warehouse, ensuring high data quality for analytics, products, and AI applications.

You will own DCR and MDM processes, set data contracts, monitor pipeline reliability, and drive continuous improvements in a fast-moving, vendor-supported environment.

Formación

• Bachelor’s or Master’s degree in computer science, information systems, data management, engineering, or related field.
• 5+ years in data management, governance, data operations, or related role with enterprise scope.
• Experience leading DCR or data-change processes across multiple stakeholders.
• Strong knowledge of MDM concepts and operating practices.
• Experience directing external vendors for data operations and delivery.
• Experience with Snowflake or comparable cloud data warehouse.
• Fluency in SQL and data modeling; hands-on coding is not primary.
• Pharma/biotech commercial-data experience preferred.
• Excellent communication and stakeholder-management skills.

Responsabilidades

• Oversee end-to-end data-ingestion lifecycle, onboarding, delivery cadence, validation, and handoff.
• Direct external vendors building and operating ETL pipelines into the data warehouse.
• Translate business needs into ingestion requirements, data contracts, and acceptance criteria.
• Review vendor designs, mappings, and plans for alignment with standards.
• Manage vendor delivery, SLAs, costs, and risk; escalate when necessary.
• Monitor data freshness and pipeline reliability; coordinate incident response.
• Establish ownership and handoffs among source systems, providers, and downstream teams.
• Own Data Correction Request (DCR) processes from intake to closure.
• Lead Master Data Management (MDM) across domains with survivorship and hierarchies.
• Drive process improvements and automation; document controls and metrics.
• Maintain data-governance standards including ownership, lineage, and privacy.
• Oversee Snowflake environment governance: access, monitoring, cost, platform changes.
• Partner with Data Product Engineering to meet downstream analytics needs.
• Maintain documentation on data sources, lineage, vendor responsibilities, and risks.

Conocimientos

Data governance

Vendor management

MDM

Snowflake

SQL

Educación

CS/IS/data mgmt

Herramientas

ETL tools

Vendor management tools

Descripción del empleo

About PharmaEssentia:
It’s not often you get the chance to make a real impact on the lives of others, while expanding your own possibilities. You’ll find that rare opportunity at PharmaEssentia. Join us, and let’s transform lives, together.
PharmaEssentia Corporation is a rapidly growing biopharmaceutical innovator. We are leveraging deep expertise and proven scientific principles to deliver effective new biologics for challenging diseases in the areas of hematology and oncology, with one product approved and a diversifying pipeline. We believe in the potential to improve both health and quality of life for patients with limited options today through the combination of rigorous research and innovative thinking. Founded in 2003 by a team of Taiwanese-American executives and renowned scientists from U.S. biotechnology and pharmaceutical companies, today we are listed on the Taiwan Stock Exchange (TWSE: 6446) and are expanding our global presence with operations in the U.S., Japan, Singapore, South Korea, and China, along with a world‑class biologics production facility in Taichung.

Position Summary

The Global Data & AI Enablement team is seeking an experienced Manager, Data Foundations & Integration to lead data ingestion, integration, governance, and the day‑to‑day operation of the enterprise data foundation supporting commercial analytics, data products, and AI capabilities. Reporting to the Data Strategy & Operations Lead, this role will oversee the onboarding and reliable delivery of data from internal systems and external data providers into the company’s data warehouse environment.

External vendors will perform the hands‑on backend engineering required to build, deploy, and operate ETL pipelines. The Manager will provide internal oversight of these activities, including defining requirements and priorities, reviewing proposed solutions, setting quality and service expectations, monitoring vendor performance, and approving production delivery. The role will also own the operating models for Data Correction Requests (DCR), Master Data Management (MDM), data governance, and data warehouse platform operations.

This is an operating‑leadership role for someone who can provide informed direction to technical vendors while maintaining a strong focus on data quality, business requirements, operational reliability, and continuous improvement. The successful candidate will ensure that foundational data is reliable, governed, documented, and ready for use by downstream data products, analytics, and AI applications.

Key Responsibilities

• Oversee the end-to-end data‑ingestion lifecycle, including source assessment, onboarding, prioritization, requirements definition, data mapping, delivery cadence, validation, production approval, and operational handoff.
• Direct external vendors responsible for designing, building, testing, deploying, and operating ETL pipelines that bring internal and third‑party data into data warehouse.
• Translate business and downstream data needs into clear ingestion requirements, technical specifications, data contracts, quality controls, and acceptance criteria for vendor execution.
• Review vendor‑proposed pipeline designs, source‑to‑target mappings, transformation logic, test results, and implementation plans to ensure alignment with internal architecture, security, quality, and maintainability standards.
• Manage vendor delivery against approved scope, timelines, service levels, cost expectations, and quality standards; resolve delivery issues and elevat material risks when necessary.
• Monitor data freshness, completeness, accuracy, and pipeline reliability, and coordinate incident response, root‑cause analysis, remediation, and stakeholder communication when issues arise.
• Establish clear ownership, controls, and handoffs among source‑system owners, external data providers, ingestion vendors, and downstream data‑product teams.
• Own the Data Correction Request process, including intake, triage, impact assessment, prioritization, approvals, vendor direction, validation, communication, and closure.
• Lead MDM processes across key business domains, including identity resolution, matching and survivorship rules, reference data, HCP/HCO hierarchies, exception management, and data‑stewardship workflows.
• Serve as the accountable internal decision‑maker for vendor‑executed ingestion, DCR, and MDM activities, providing clear guidance on business rules, priorities, implementation decisions, and expected outcomes.
• Improve ingestion, DCR, and MDM processes by addressing recurring issues, simplifying workflows, strengthening preventive controls, standardizing documentation, and introducing appropriate automation and performance metrics.
• Establish and maintain data‑governance standards covering data ownership, stewardship, business definitions, data quality, lineage, access, retention, and privacy‑conscious data handling.
• Oversee the operational governance of the Snowflake environment, including access management, monitoring, performance, cost and usage oversight, and coordination of platform changes with IT, Security, and external vendors.
• Partner with the Manager, Data Product Engineering to ensure that ingested, foundational, and master data meet the requirements of downstream analytics, integrated data products, business rules, and AI applications.
• Maintain documentation and reporting covering data sources, ingestion processes, lineage, vendor responsibilities, service levels, data‑quality trends, pipeline reliability, platform health, and material operational risks.

Qualifications

• Bachelor’s or Master’s degree in computer science, information systems, data management, engineering, business analytics, or a related field, or equivalent practical experience.
• 5+ years of experience in data management, data governance, data operations, data‑platform management, or a closely related role, including ownership of complex enterprise data processes.
• Demonstrated experience leading DCR, data‑issue management, or comparable controlled data‑change processes involving multiple business and technical stakeholders.
• Strong knowledge of MDM concepts and operating practices, including identity resolution, matching and survivorship, reference data, hierarchy management, exception handling, and data stewardship.
• Experience directing external vendors that perform data operations or technical delivery, including setting requirements, making implementation decisions, managing service levels, reviewing deliverables, and resolving escalations.
• Experience designing or improving data‑governance and data‑quality processes, including ownership models, business definitions, controls, lineage, access management, and issue remediation.
• Experience overseeing Snowflake or a comparable cloud data warehouse, with an understanding of platform access, security, monitoring, performance, reliability, and cost management.
• Sufficient technical fluency in SQL, data models, integration patterns, and warehouse architecture to assess issues, validate vendor recommendations, and make informed decisions; hands‑on engineering is not the primary focus of the role.
• Pharmaceutical, biotechnology, or healthcare commercial‑data experience strongly preferred, including familiarity with HCP/HCO, CRM, claims, sales and distribution, Specialty Pharmacy/HUB, payer/access, or related data.
• Demonstrated success improving operational processes through clearer decision rights, standardized workflows, measurable service levels, root‑cause analysis, and appropriate automation.
• Excellent communication and stakeholder‑management skills, with the ability to translate business requirements into clear direction for technical teams and external vendors.
• Strong judgment, ownership, attention to detail, and comfort making decisions in a fast‑moving, vendor‑supported environment.

What Success Looks Like

• Critical commercial data feeds are reliable, monitored, documented, and available on the cadence required by the business.
• DCR and MDM activities operate through clear decision rights, documented processes, predictable service levels, and timely resolution of business‑critical issues.
• External vendors consistently meet agreed delivery, quality, documentation, and service expectations, with performance issues identified and addressed promptly.
• Recurring data corrections and master‑data issues decrease as root causes are resolved and preventive controls, standardized rules, and process improvements are implemented.
• Critical master and reference data are accurate, governed, traceable, and dependable for downstream analytics, data products, business operations, and AI applications.
• Data warehouse environment is reliable, appropriately controlled, monitored, and cost‑conscious, with platform changes coordinated without unnecessary disruption to downstream users.
• Business and technical stakeholders understand data ownership, escalation paths, and governance responsibilities, enabling faster and more consistent decisions.

Location and Work Arrangement

This position is based in Burlington, Massachusetts, and follows a hybrid work model requiring on‑site presence three days per week.

The expected base salary range for this position is $140,000 - $182,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education and geographical location. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible for short‑term and long‑term incentives.

Benefits of working with our team

PharmaEssentia USA strives every day to improve the lives of patients as well as our employees. As a valued member of PharmaEssentia USA, you will enjoy the following benefits:

• Comprehensive medical coverage
• Dental and vision coverage
• Generous paid time‑off
• 401(k) retirement plan with competitive company match
• Medical & Dependent Care Flexible Spending Account
• Up to $150 monthly cell phone reimbursement
• Employee Assistance Program
• Free parking

EEO Statement

At PharmaEssentia USA, we are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, pregnancy (including childbirth and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law. PharmaEssentia USA believes that diversity and inclusion among our team are critical to our success as a global company, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool.

PharmaEssentia does not accept unsolicited agency resumes. Staffing agencies should not send resumes to our HR team or to any PharmaEssentia employees. PharmaEssentia is not responsible for any fees related to unsolicited resumes from staffing agencies.

At PharmaEssentia, our goal is to treat as many people with cancer as possible. That means challenging the status quo with better science that leads to better lives. By joining our team, you will not only expand your own possibilities, but you will contribute to expanding options for people with cancer.

https://us.pharmaessentia.com/careers/