Data Product Engineer, Global Data and AI Enablement

PharmaEssentia U.S.A.; Burlington (MA); Híbrido; USD 116.000 - 150.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

Flexible Spending Account

Up to $150 monthly cell phone reimbur​

Employee Assistance Program

Free parking

Descripción de la vacante

PharmaEssentia USA is seeking a hands-on Data Product Engineer to transform vendor-delivered data into curated, reusable tables in Snowflake for analytics and AI use cases. You will integrate multiple data sources, codify business rules, and deliver reliable data products with alerts.

The role partners with cross-functional teams to design, deploy, monitor, and enhance production data products, reducing manual data prep and enabling faster, trusted decision-making.

Formación

• 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; experience with dbt or a comparable transformation framework is strongly preferred.
• 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.

Responsabilidades

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

Conocimientos

SQL

Python

Snowflake

dbt

Data products

ELT patterns

Communication

Ownership mindset

Educación

Bachelor’s or Master’s degree in computer science, data engineering, data science, information systems, engineering, or a related field

Herramientas

Snowflake

dbt

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 a hands-on Data Product Engineer to build and manage integrated data products tailored to the needs of internal customers. Reporting to the Manager, Data Product Engineering, this role will transform vendor-delivered raw data in data warehouse into curated, reusable, and well-documented data tables that support commercial analytics, business operations, and AI applications. The Data Product Engineer will integrate pharmaceutical commercial data sources, codify business rules, and develop reliable data products and rules-based alerts that deliver timely, actionable information to field and business teams.

This is a builder role for someone who enjoys translating business needs into durable technical solutions and owning data products throughout their lifecycle. The successful candidate will partner with cross-functional teams to design, deploy, monitor, and enhance production data products. The role will reduce repeated manual data work, improve the consistency and speed of internal decision-making, and create trusted data assets that can be reused across analytics and AI use cases.

Key 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; experience with dbt or a comparable transformation framework is strongly preferred.
• 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 Qualifications

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

What Success Looks Like

• Internal customers can access trusted, integrated, and reusable data products instead of relying on repeated manual preparation or one-off datasets.
• Raw source data is consistently transformed into curated, documented, and production-ready tables that reflect approved business definitions and rules.
• Rules-based alerts deliver timely, relevant, and actionable signals to field and business teams, with outputs refined through monitoring and user feedback.
• Data products are reliable, tested, monitored, and maintainable, with production issues identified quickly and resolved before they materially affect business users.
• Cross-functionally teams can reuse common data models rather than rebuilding them for each new request or use case.
• New business requirements can be translated into production data products more quickly without sacrificing data quality, scalability, or engineering standards.

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 $116,000 to $150,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

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/