AWS Data Architect

Ahura Workforce Solutions; South San Francisco (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

Ahura Workforce Solutions is seeking an experienced AWS Solution Architect to lead the design and delivery of a unified analytics and data platform for pharmaceutical data. The role focuses on integrating Sales, Claims, Payer, CRM, and Master Data to power executive decision-making and field execution.

The candidate will architect end-to-end data pipelines, enforce governance, and collaborate with Brand teams and IT to deliver scalable data products with robust quality controls.

Qualifications

• 10+ years in Life Sciences / Pharmaceutical Data Architecture.
• Hands-on experience integrating IQVIA, LAAD, Veeva CRM, 852/867 EDI feeds, MMIT, Careset, and Payer/Claims datasets.
• Strong proficiency in AWS data services (S3, Glue, Redshift, Athena) and data modeling.
• Understanding of US pharma operations, formulary tracking, and market access.

Responsibilities

• Design end-to-end cloud data pipelines and semantic layers on AWS.
• Ingest and harmonize pharmaceutical datasets across multiple sources.
• Build KPI rule engines and automated data quality gates.
• Lead cross-functional delivery with Brand teams, analytics, and IT stakeholders.

Skills

Data architecture

Platform design

Dataset integration

KPI framework

Cross-functional leadership

Education

Bachelor's or Master's in IT/CS

Tools

AWS (S3/Glue/Redshift/Athena)

PySpark

SQL

Apache Iceberg

ETL/ELT frameworks

Job description

Location – Onsite - South SFO, 3 days a week.

Mandatory Requirements

• Pharmaceutical industry experience, specifically with companies like Abbvie and Genentech.
• Hands-on integration and modeling of IQVIA, LAAD, Veeva CRM, 852/867 EDI feeds, MMIT, Careset, and Payer/Claims datasets.

Position Overview The AWS Solution Architect will design, architect, and lead the technical execution of analytics and data platform capabilities. This role is responsible for unifying key pharmaceutical datasets—including Sales & Prescription data, Longitudinal Claims, Payer/Market Access, and CRM interactions—into a single governed source of truth to power executive decision-making and field execution.

Key Responsibilities

• Data Architecture & Platform Design: Architect end-to-end cloud data pipelines, semantic layers, and data marts on AWS (S3, Glue, Redshift, PySpark, Athena) to support data products and performance tracking. Design conformed dimensional models, star schemas, and reusable semantic layers for key metrics (NRx, TRx, Share of Voice, Persistent Duration). Ensure full alignment with enterprise platform standards, data governance, RBAC security, and data quality frameworks.
• Dataset Integration & Harmonization: Ingest, clean, and harmonize key pharmaceutical datasets across multiple channels, including Sales & Prescription Data (IQVIA, 852/867 EDI, SAP), Claims & Patient Data (LAAD, Careset), Payer & Market Access Data (MMIT), CRM & Field Interaction Data (Veeva CRM), and Master Data (HCP/HCO/Payer).
• KPI & Decision-Support Framework: Build phase-aware KPI rule engines tracking 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 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.

Required Qualifications

• Experience: 10+ years in Life Sciences / Pharmaceutical Data Architecture. Must have specific experience working with major pharmaceutical companies like Abbvie and Genentech.
• Dataset Expertise: Hands-on experience integrating and modeling IQVIA, LAAD, Veeva CRM, 852/867 EDI feeds, MMIT, Careset, and Payer/Claims datasets.
• Technical Skills: Strong proficiency in Cloud Data Platforms, specifically AWS (S3, Glue, Redshift, Athena, Step Functions, Lambda). Expertise in Data Processing & Engineering (PySpark, SQL, Apache Iceberg, ETL/ELT frameworks, REST APIs) and Data Modeling (Kimball dimensional modeling, Star Schema design, MDM).
• Domain Knowledge: In-depth understanding of US Pharma operations, formulary tracking, market access, and patient journey analytics.

Preferred Qualifications

• Frontend Knowledge: Experience with React is a strong plus.
• Ecosystem Experience: Prior experience with Genentech/Roche technology ecosystems (e.g., Polaris, OASIS).
• Analytics/BI: Familiarity with semantic layer engines (Cube.js) and BI platforms (Looker, Tableau, Qlik).

Education

• Bachelors or Masters in Information Technology, Computer Science or relevant field.