Data Product Engineer, Global Data and AI Enablement

About Pharma Essentia: 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 n us, and let’s transform lives, together. Pharma Essentia 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.

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.

• 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,…