Data Architect (Pharma Commercial)

New York Technology Partners; South San Francisco (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

New York Technology Partners seeks a Pharma Commercial Data Architect to design and lead the data platform for pharmaceutical product launches. You will unify Sales, Claims, Payer, CRM, and Market Access data into a governed source of truth to power launch dashboards and executive decisions.

The role requires 10+ years in life sciences data architecture and hands-on experience with IQVIA/LAAD, Veeva CRM, Payer/Claims feeds, and cloud platforms like AWS or Snowflake.

Qualifications

• 10+ years in Life Sciences / Pharmaceutical Data Architecture and Commercial Analytics
• Experience leading data architecture for commercial product launches
• Hands-on integration and modeling of IQVIA, LAAD, Veeva CRM, and Payer/Claims datasets

Responsibilities

• Architect end-to-end cloud data pipelines, semantic layers, and data marts on AWS/Snowflake
• Design conformed dimensional models and star schemas for launch metrics
• Ensure compliance with data governance, RBAC and data quality frameworks
• Lead cross-functional delivery with Brand Teams, Analytics, Data Engineering and IT

Skills

Life Sciences/Data Architecture

Commercial Analytics

Data modeling/Dimensional modeling

ETL/ELT

Education

Bachelor's or Master's in IT/CS

Tools

IQVIA

LAAD

Veeva CRM

Edi feeds 852/867

MMIT

Careset

Payer/Claims datasets

Job description

• Job Title: Pharma Commercial Data Architect
• Experience Level: 10+ years in Life Sciences / Pharmaceutical Data Architecture and Commercial Analytics

Role Overview

The Pharma Commercial Data Architect will design, architect, and lead the technical execution of commercial analytics and data platform capabilities for product launches. This role is responsible for unifying key commercial launch datasets including Sales & Prescription data, Longitudinal Claims, Payer/Market Access, and Sales Force/CRM interactions—into a single governed source of truth to power brand launch cockpits, executive decision-making, and field force execution.

Required Qualifications

• 10+ years in Life Sciences / Pharmaceutical Data Architecture and Commercial Analytics
• Specific experience leading data architecture for commercial product launches
• Hands-on experience integrating and modeling IQVIA, LAAD, Veeva CRM, 852/867 EDI feeds, MMIT, Careset, and Payer/Claims datasets
• Experience with cloud data platforms: AWS (S3, Glue, Redshift, Athena, Step Functions, Lambda) and/or Snowflake
• Experience with PySpark, SQL, Apache Iceberg, ETL/ELT frameworks, and REST APIs
• Experience with dimensional modeling (Kimball), Star Schema design, Master Data Management (MDM) , and conformed dimension strategy
• In-depth understanding of US Pharma commercial operations, sales force effectiveness (SFE), formulary tracking, market access, and patient journey analytics

Technical Core & Responsibilities

• Architect end-to-end cloud data pipelines, semantic layers, and data marts on AWS (S3, Glue, Redshift, PySpark, Athena)
• Design conformed dimensional models, star schemas, and reusable semantic layers for brand launch metrics (NRx, TRx, Share of Voice, Persistent Duration)
• Ensure full alignment with enterprise platform standards, data governance, RBAC security, and data quality frameworks

Commercial Dataset Integration & Harmonization

• Ingest, clean, and harmonize key pharmaceutical launch datasets across multiple channels:
• Claims & Patient Data: LAAD (Longitudinal Prescription & Claims), medical and pharmacy claims, Careset data
• Payer & Market Access Data: MMIT, formulary coverage, prior authorization (PA) tracking, Gross-to-Net (GTN) analytics
• CRM & Field Interaction Data: Veeva CRM, call activity, HCP engagement metrics, digital marketing/omnichannel feeds
• Master Data: Customer Master (HCP/HCO/Payer) and Product Master MDM integrations

Launch KPI & Decision-Support Framework

• Build phase-aware KPI rule engines tracking launch progression across key operational pillars: Market Readiness, HCP Engagement, Patient Adoption, Access & Formulary, and Persistence & Adherence
• Establish automated data quality validation gates and circuit breakers to ensure source feed integrity before deployment

Cross-Functional Delivery Leadership

• Partner with Commercial Brand Teams, Strategic Analytics, Data Engineering, and IT stakeholders to translate business requirements into technical blueprints
• Guide technical delivery pods across data engineering, semantic modeling, and micro-frontend/BI integration

Preferred Qualifications

• Prior experience with Genentech/Roche commercial technology ecosystems (e.g., Polaris, OASIS)
• Familiarity with semantic layer engines (Cube.js) and BI platforms (Looker, Tableau, Qlik)

Education

• Bachelor's or Master's in Information Technology, Computer Science, or relevant field

Note

• 10+ years experience required
• Pharmaceutical commercial data architecture experience required
• IQVIA, LAAD, Veeva CRM, and Payer/Claims dataset experience required