Data & Analytics Engineer – Commercial Pharma

SRM Technologies; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

SRM Technologies is seeking a senior data analytics/data engineering professional in the United States to design data models across field, brand, patient and omnichannel data. You will integrate Rx/sales, claims, specialty pharmacy, hub, CRM and digital data to build robust ETL/ELT pipelines and curated datasets.

The role requires extensive pharma commercial data experience, strong SQL and Python skills, and the ability to implement data quality checks, create semantic layers and KPI logic for

Qualifications

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

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.

Skills

Experience in analytics

Pharma data analytics

Sales analytics

Patient analytics

Data modeling

Star schema

Semantic layers

HCP/NPI matching

SQL

Python

ETL/ELT

dbt

Snowflake/Databricks

IQVIA data

Specialty data

CRM data

Tools

SQL tooling

Job description

• 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