AWS Solutions Architect

Role – AWS Solutions ArchitectLocation – Onsite - South SFO, 3 days a week.Mandatory RequirementsStrong AWS Architecture experience.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 ResponsibilitiesData 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 QualificationsExperience: 10+ years in Life Sciences / Pharmaceutical Data Architecture. Must have specific experience working with major pharmaceutical companies.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 QualificationsFrontend Knowledge: Experience with React is a strong plus.Ecosystem Experience: Prior experience with ecosystems (e.g., Polaris, OASIS).Analytics/BI: Familiarity with semantic layer engines (Cube.js) and BI platforms (Looker, Tableau, Qlik).EducationBachelors or Masters in Information Technology, Computer Science or relevant field.Work EnvironmentThis job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers.Physical DemandsThis position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.Other DutiesPlease note this is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.EEOSaama provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.