Data & Analytics Engineer – Commercial Pharma

This is a fully remote position, open to applicants in India.

📋 Description

• Design data models encompassing field, brand, patient, access, and omnichannel aspects.

• Integrate data from Rx/sales, claims, specialty pharmacy, hub, CRM, and digital sources.

• Develop ETL/ELT pipelines along with reusable curated datasets.

• Address mapping for HCP, product, payer, geography, and territory.

• Execute data quality checks and source-to-target validation processes.

• Construct data marts, semantic layers, and standardized KPI logic.

⛳️ Requirements

• 5 to 8+ years of experience in analytics or data engineering.

• A minimum of 3 years with commercial data in the pharma or biotech industry is preferred.

• Familiarity with sales and field effectiveness metrics.

• Experience in patient and market access analytics.

• Proficiency in fact and dimension design.

• Knowledge of star and conformed dimensions.

• Experience with analytical marts and semantic layers.

• Skills in HCP/HCO affiliation and NPI matching.

• Advanced SQL capabilities on large commercial datasets.

• Proficient in Python for processing, validation, and automation tasks.

• Solid experience in ETL/ELT development; familiarity with dbt or similar tools.

• Knowledge of Snowflake, Databricks, or comparable platforms.

• Experience with IQVIA Xponent and PlanTrak Rx data.

• Understanding of specialty pharmacy and patient hub data feeds.

• Experience with CRM systems (Veeva/Salesforce) activity.

🏝️ Benefits

• Comprehensive health and wellness programs.

• Opportunities for professional development and growth.

• Flexible work arrangements and supportive work environment.