Manager/Sr. Manager, Data Foundations & Integration

PharmaEssentia Corporation; Burlington (MA); Ibrido; USD 140.000 - 182.000; Tempo pieno

Vantaggi offerti da questo lavoro

Comprehensive medical coverage

Dental and vision coverage

Generous paid time-off

401(k) retirement plan with company-mq

Flexible Spending Account

Cell phone reimbursement

Employee Assistance Program

Free parking

Descrizione del lavoro

PharmaEssentia Corporation is seeking an experienced Manager, Data Foundations & Integration in Burlington, MA, to lead data ingestion, integration, governance, and day-to-day operation of the enterprise data foundation supporting analytics and AI capabilities.

You will oversee onboarding from internal systems and external providers into the data warehouse, coordinating with vendors and internal teams to ensure reliability, security, and quality of data assets.

Competenze

• Experience leading data ingestion initiatives across complex data ecosystems.
• Strong understanding of data governance, lineage, and quality controls.
• Proven ability to translate business needs into data requirements and technical specs.
• Experience managing external vendors and ensuring delivery against SLAs.

Mansioni

• Oversee end-to-end data-ingestion lifecycle from source to data warehouse.
• Direct vendors responsible for ETL pipeline design, build, and operation.
• Define data contracts, quality controls, and acceptance criteria for ingestion.
• Establish ownership and handoffs among data owners, providers, and downstream teams.
• Lead MDM processes, including identity resolution, survivorship rules, and reference data workflows.
• Improve ingestion, DCR, and MDM processes with preventive controls and automation.

Conoscenze

Data ingestion

Data governance

ETL pipelines

Vendor management

MDM

Strumenti

Snowflake

Descrizione del lavoro

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.

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.

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 elevate 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-conscientious 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.

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

• 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/