Data Product Engineer: Global Data & AI Enablement

PharmaEssentia U.S.A.; Burlington (MA); Hybrid; USD 116,000 - 150,000; Full time

Benefits offered by this job

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

Job summary

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.

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.

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.

Skills

SQL

Python

Snowflake

dbt

Data products

ELT patterns

Communication

Ownership mindset

Education

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

Tools

Snowflake

dbt

Job description

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.