Pharma Data & Analytics Engineer — Commercial Insights

Jobgether; United States; On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Full-time role

Snowflake & Databricks exposure

Diverse healthcare data sources

Job summary

Jobgether partners with a pharma-focused company to seek a Data & Analytics Engineer in the United States. You will build reliable data foundations to support commercial pharmaceutical analytics and integrate data across sales, field activity, patients, market access, and omnichannel engagement.

Design scalable data models, develop ETL/ELT pipelines, and create curated datasets for analytics and reporting. You will enable standardized KPIs and actionable insights across the organization while

Qualifications

• 5–8 years of analytics or data engineering experience.
• 3 years working with commercial pharmaceutical or biotechnology data preferred.
• Strong understanding of commercial pharma analytics including sales, field effectiveness, patient analytics, and market access.
• Advanced SQL skills with large, complex datasets.
• Strong Python skills for data processing, validation, automation, and workflow development.
• Experience developing ETL/ELT pipelines using dbt or similar tools.
• Hands-on experience with Snowflake, Databricks, or comparable platforms.
• Expertise in dimensional data modeling, including star schemas and semantic layers.
• Experience with HCP/HCO affiliation, NPI matching, and data mapping.
• Familiarity with IQVIA Xponent and PlanTrak Rx datasets.
• CRM data knowledge with Veeva or Salesforce.

Responsibilities

• Design scalable data models covering field, brand, patient, market access, and omnichannel analytics.
• Integrate and transform data from prescription and sales, claims, specialty pharmacy, patient hub, CRM, and digital sources.
• Develop ETL/ELT pipelines and curated datasets for downstream analytics and reporting.
• Build analytical marts, semantic layers, and standardized KPI definitions for reporting.
• Design fact and dimension models, including star schemas and conformed dimensions for large-scale analytics.
• Resolve and maintain mappings across HCPs, HCOs, products, payers, geographies, and territories.
• Perform HCP/HCO affiliation and NPI matching to improve data quality.
• Implement data quality controls, source-to-target validation, and automated checks.
• Use SQL and Python to process, validate, transform, and automate workflows for large datasets.
• Collaborate with analytics, commercial, and business stakeholders to deliver reliable data solutions.

Skills

SQL

Python

ETL/ELT

Data modeling

Stakeholder collaboration

Problem solving

Independent work

Tools

dbt

Snowflake

Databricks

Salesforce

Veeva

Job description

Jobgether partners with a pharma-focused company to seek a Data & Analytics Engineer in the United States. You will build reliable data foundations to support commercial pharmaceutical analytics and integrate data across sales, field activity, patients, market access, and omnichannel engagement.

Design scalable data models, develop ETL/ELT pipelines, and create curated datasets for analytics and reporting. You will enable standardized KPIs and actionable insights across the organization while