Data & Analytics Engineer – Commercial Pharma
Information Technology & Services · 1,001-5,000 employees
About the role
Design and implement data models and ETL/ELT pipelines to integrate complex commercial pharmaceutical datasets. Develop curated datasets, semantic layers, and standardized KPI logic to support field, brand, and patient analytics.
What they look for
Requirements
Requires 5 to 8+ years of experience in data engineering or analytics, with a strong preference for commercial pharma or biotech industry background. Proficiency in SQL, Python, and modern data platforms like Snowflake or Databricks is essential.
Full description
This is a remote position.
KEY RESPONSIBILITIES
- Design data models across field, brand, patient, access and omnichannel • Integrate Rx/sales, claims, specialty pharmacy, hub, CRM and digital data • Develop ETL/ELT pipelines and reusable curated datasets.
Resolve HCP, product, payer, geography and territory mapping • Implement data quality and source-to-target validation checks • Create marts, semantic layers and standardized KPI logic.
QUALIFICATIONS & TECHNICAL EXPERTISE
Commercial Pharma Experience
- 5 to 8+ years in analytics or data engineering • 3+ years with pharma or biotech commercial data preferred • Sales and field effectiveness • Patient and market access analytics
Data Modeling Expertise • Fact and dimension design • Star and conformed dimensions • Analytical marts and semantic layers • HCP/HCO affiliation and NPI matching
Engineering & Platforms • Advanced SQL on large commercial datasets • Python for processing, validation and automation • Strong ETL/ELT development; dbt or similar • Snowflake, Databricks or comparable platforms
Commercial Data Expertise
- IQVIA Xponent and PlanTrak Rx • Specialty pharmacy and patient hub feeds • CRM (Veeva/Salesforce) activity
