← Back to jobsJob ID col-cmv8bsvd901z0oz011h34hpgs

PharmaEssentiaPosted 30+ days ago

Data Product Engineer, Global Data and AI Enablement

Full-time
Hybrid
2+ years
$190K – $245K/yr
Posted 30+ days ago

PharmaEssentia is seeking a hands-on Data Product Engineer to build and manage integrated data products for internal customers. The role transforms raw pharmaceutical commercial data into curated, documented datasets, models, and rules-based alerts that support analytics, business operations, and AI applications.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design, build, test, deploy, and maintain data transformations, curated data tables, reusable models, semantic-layer components, and production-ready datasets in Snowflake
  • Build integrated data products combining claims, Veeva CRM, HCP/HCO hierarchies, Specialty Pharmacy/HUB, specialty distributor/3PL, payer/access, sales, and marketing-engagement data
  • Translate internal customer requirements and product specifications into scalable technical designs under the direction of the Manager, Data Product Engineering
  • Codify approved business rules and develop the supporting datasets, workflows, and rules-based alerts that surface relevant opportunities, exceptions, or actions to field and business teams through approved downstream channels
  • Develop reusable data models that reflect consistent definitions and can support multiple analytics, operational, and AI use cases
  • Implement automated testing, reconciliation, data-quality controls, monitoring, and alerting; investigate root causes and coordinate issue resolution with Data Foundations & Integration and external vendors
  • Use SQL and/or Python to transform complex datasets, automate recurring processes, implement business logic, optimize queries, and reduce manual data preparation
  • Apply version control, peer review, deployment controls, and automated delivery practices to improve the reliability and maintainability of production data products
  • Optimize data models and transformation workflows for performance, scalability, reliability, maintainability, and Snowflake cost efficiency
  • Support production monitoring, incident resolution, and ongoing enhancements to existing data products based on user feedback, changing business needs, and source-data changes
  • Maintain clear documentation for data sources, lineage, transformations, business rules, data models, quality controls, dependencies, and intended product use
  • Collaborate cross-functionally to provide trusted datasets and interfaces for predictive analytics, AI applications, and agent-based solutions

Qualifications

  • Bachelor's or Master's degree in computer science, data engineering, data science, information systems, engineering, or a related field, or equivalent practical experience
  • 2+ years of hands-on experience in data engineering, analytics engineering, data product engineering, or a closely related role, with demonstrated ownership of production data products
  • Strong SQL and hands-on Python skills for data transformation, business-rule implementation, automation, testing, troubleshooting, and performance optimization
  • Hands-on experience with Snowflake or a comparable cloud data warehouse and modern ELT patterns
  • Excellent communication and collaboration skills, with the ability to work effectively with technical teams, business stakeholders, and external data vendors
  • Strong ownership mindset, attention to detail, and commitment to building reliable, documented, and maintainable data products

Preferred

  • experience with dbt or a comparable transformation framework is strongly preferred
  • Pharmaceutical, biotechnology, or healthcare commercial-data experience strongly preferred, including claims, CRM, HCP/HCO, sales and distribution, Specialty Pharmacy/HUB, payer/access, or marketing data
  • Experience delivering data products to downstream BI, CRM, field-facing, workflow, or application environments is valuable
  • Experience designing dimensional, relational, or analytics-oriented data models and producing reusable, curated datasets from complex multi-source data
  • Experience translating business requirements into production data products, including rules-based workflows, operational datasets, alerts, or decision-support outputs

Required skills

SQLPythonSnowflakeELTdbtPharmaceutical Commercial DataClaims DataVeeva CRMHCP/HCO DataSpecialty Pharmacy/HUB DataPayer and Access DataData Modeling

Full job description

PharmaEssentia is seeking a hands-on Data Product Engineer to build and manage integrated data products for internal customers. The role transforms raw pharmaceutical commercial data into curated, documented datasets, models, and rules-based alerts that support analytics, business operations, and AI applications.

Responsibilities

  • Design, build, test, deploy, and maintain data transformations, curated data tables, reusable models, semantic-layer components, and production-ready datasets in Snowflake
  • Build integrated data products combining claims, Veeva CRM, HCP/HCO hierarchies, Specialty Pharmacy/HUB, specialty distributor/3PL, payer/access, sales, and marketing-engagement data
  • Translate internal customer requirements and product specifications into scalable technical designs under the direction of the Manager, Data Product Engineering
  • Codify approved business rules and develop the supporting datasets, workflows, and rules-based alerts that surface relevant opportunities, exceptions, or actions to field and business teams through approved downstream channels
  • Develop reusable data models that reflect consistent definitions and can support multiple analytics, operational, and AI use cases
  • Implement automated testing, reconciliation, data-quality controls, monitoring, and alerting; investigate root causes and coordinate issue resolution with Data Foundations & Integration and external vendors
  • Use SQL and/or Python to transform complex datasets, automate recurring processes, implement business logic, optimize queries, and reduce manual data preparation
  • Apply version control, peer review, deployment controls, and automated delivery practices to improve the reliability and maintainability of production data products
  • Optimize data models and transformation workflows for performance, scalability, reliability, maintainability, and Snowflake cost efficiency
  • Support production monitoring, incident resolution, and ongoing enhancements to existing data products based on user feedback, changing business needs, and source-data changes
  • Maintain clear documentation for data sources, lineage, transformations, business rules, data models, quality controls, dependencies, and intended product use
  • Collaborate cross-functionally to provide trusted datasets and interfaces for predictive analytics, AI applications, and agent-based solutions

Preferred

  • experience with dbt or a comparable transformation framework is strongly preferred
  • Pharmaceutical, biotechnology, or healthcare commercial-data experience strongly preferred, including claims, CRM, HCP/HCO, sales and distribution, Specialty Pharmacy/HUB, payer/access, or marketing data
  • Experience delivering data products to downstream BI, CRM, field-facing, workflow, or application environments is valuable
  • Experience designing dimensional, relational, or analytics-oriented data models and producing reusable, curated datasets from complex multi-source data
  • Experience translating business requirements into production data products, including rules-based workflows, operational datasets, alerts, or decision-support outputs
  • dbt
  • Data transformation frameworks
  • Pharmaceutical data
  • Biotechnology data
  • Healthcare commercial data
  • Claims data
  • CRM data
  • HCP/HCO data
  • Sales
  • distribution data
  • Specialty Pharmacy/HUB data
  • Payer
  • access data
  • Marketing data
  • Downstream BI delivery
  • CRM delivery
  • Field-facing data products
  • Workflow environments
  • Application environments
  • Data product delivery
  • Dimensional data modeling
  • Relational data modeling
  • Analytics data modeling
  • Reusable curated datasets
  • Multi-source data integration
  • Business requirements translation
  • Rules-based workflows
  • Operational datasets
  • Decision-support outputs

Benefits

  • Hybrid work model requiring on-site presence three days per week
  • 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
  • Short-term and long-term incentives

Company

  • Biopharmaceutical company developing therapies for blood cancers and disorders
  • Burlington, Massachusetts, USA
  • https://us.pharmaessentia.com/
  • Founded in 2003
  • 501-1000 employees

Qualifications

  • Bachelor's or Master's degree in computer science, data engineering, data science, information systems, engineering, or a related field, or equivalent practical experience
  • 2+ years of hands-on experience in data engineering, analytics engineering, data product engineering, or a closely related role, with demonstrated ownership of production data products
  • Strong SQL and hands-on Python skills for data transformation, business-rule implementation, automation, testing, troubleshooting, and performance optimization
  • Hands-on experience with Snowflake or a comparable cloud data warehouse and modern ELT patterns
  • Excellent communication and collaboration skills, with the ability to work effectively with technical teams, business stakeholders, and external data vendors
  • Strong ownership mindset, attention to detail, and commitment to building reliable, documented, and maintainable data products
  • Experience with dbt or a comparable transformation framework is strongly preferred
  • Pharmaceutical, biotechnology, or healthcare commercial-data experience strongly preferred, including claims, CRM, HCP/HCO, sales and distribution, Specialty Pharmacy/HUB, payer/access, or marketing data
  • Experience delivering data products to downstream BI, CRM, field-facing, workflow, or application environments is valuable
  • Experience designing dimensional, relational, or analytics-oriented data models and producing reusable, curated datasets from complex multi-source data
  • Experience translating business requirements into production data products, including rules-based workflows, operational datasets, alerts, or decision-support outputs
  • 2+ years of hands-on experience in data engineering, analytics engineering, data product engineering, or a closely related role, with demonstrated ownership of production data products.

Required skills

  • SQL, Python, Snowflake, ELT, dbt, Pharmaceutical Commercial Data, Claims Data, Veeva CRM, HCP/HCO Data, Specialty Pharmacy/HUB Data, Payer and Access Data, Data Modeling

Experience

  • 2+ years

Job details

Employment type

Full-time

Seniority level

2+ years

Date posted

Oct 13, 2026

Work mode

Hybrid

Job source

Ethic Leaf recruiter

Company

PharmaEssentia

Information Technology & AI

Biopharmaceutical company developing therapies for blood cancers and disorders

  • Burlington, Massachusetts, USA
  • Information Technology & AI
  • 501-1000 employees
  • Founded 2003
  • us.pharmaessentia.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Burlington

Tech Consulting

1d ago

New

Jr Data Engineer

Full-timeOn-siteBurlington, VTCompetitive

Tech Consulting is hiring a Jr Data Engineer for client-facing projects with Fortune 500 companies. The role provides practical data engineering experience across projects and exposure to tools, cloud platforms, and data environments, with mentorship and…

Why similarSame roleData ModelingBurlington

Dice

1d ago

New

Senior Data Engineer with AI

TemporaryHybridDallas, TXCompetitive

The hiring employer is not identified in the posting. The role builds and maintains scalable data infrastructure across ingestion, transformation, orchestration, and delivery, while using AI-assisted development tools and collaborating with backend, BI, and…

Why similarSame rolePythonSQL

Block

1d ago

New

Senior Data Engineer, Product

Full-timeOn-siteBay, CA$198K – $297K/yr

Block builds technology and financial products that increase access to the global economy through brands including Cash App, Square, Afterpay, and TIDAL.

Why similarSame rolePythonSQL

Get new Data Engineer jobs in Burlington by email

Create job alert

Data Product Engineer, Global Data and AI Enablement

PharmaEssentia · $190K – $245K/yr

Apply via Ethic Leaf