Market Access Data Architect

Job Description

• Coordinate and implement Specialty Pharmacy and Market Access data integration solutions in partnership with Commercial Data Lake teams.
• Develop ETL/ELT pipelines using PySpark and Python to ingest, transform, aggregate, and orchestrate data for end-user consumption.
• Build competency across Market Access and Patient Services datasets, including:
  • EDI sales and chargeback data
  • Copay and affordability data
  • Medical and prescription claims
  • Care model and patient services data
• Apply best practices for data quality monitoring, validation, and reporting.
• Leverage big data tools and architectures (e.g., Spark, Hive, Impala, cloud data platforms) to answer critical business questions.
• Architect, design, and build Neo4j-based knowledge graph structures supporting Market Access and Patient Services use cases.
• Ingest, model, and connect complex pharma datasets including patients, coverage, contracts, benefits, services, and gross-to-net (GTN) components.
• Design and optimize graph schemas, nodes, relationships, metadata layers, indexing strategies, and query performance.
• Ensure graph data is accurate, traceable, and aligned with enterprise data governance and compliance standards.

• Design and integrate LLM-powered chatbot and assistant workflows on top of the knowledge graph.
• Implement prompt engineering, retrieval-augmented generation (RAG), and domain-specific grounding using graph and document sources.
• Ensure AI components follow enterprise standards for explainability, auditability, and compliance.
• Collaborate with enterprise AI teams to align with approved frameworks, guardrails, and tooling.

• Build backend services that interface with the knowledge graph, LLM systems, and field-facing applications.
• Implement robust metadata, logging, and monitoring frameworks to support auditability and regulated environments.
• Utilize cloud-native services (e.g., object storage, No
  
  SQL stores, serverless compute, APIs) where appropriate.

• Deliver at high velocity in an agile, iterative environment with visible daily progress.
• Participate in standups, technical design reviews, and sprint planning.
• Own work end-to-end: design, implementation, testing, and validation.
• Proactively identify data gaps, design risks, and integration issues before they become blockers.
• Establish and maintain strong working relationships across technical teams and external partners, managing expectations and communication effectively.

• Expert-level experience with:
  • Data architecture and data modeling
  • Graph modeling and Neo4j
  • Python and Py Spark
  • AI/LLMs and chatbot architectures
  • Cloud platforms (AWS preferred)
• Strong hands‑on experience integrating complex enterprise datasets.
• Proven ability to work independently with minimal direction.
• Experience delivering MVPs or prototypes under tight timelines.
• Experience working in highly regulated environments (data privacy, audit, compliance).

• Prior experience with Market Access, Patient Services, or Specialty Pharmacy data.
• Experience contributing to enterprise LLM pilots or production AI solutions.
• Familiarity with AWS services such as Dynamo
  
  DB, Lambda, S3, API Gateway.
• Experience designing AI-driven insights layers on top of enterprise data platforms.

This is a Contract position based out of Chicago, IL.

The pay range for this position is $90.00 - $90.00/hr eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include:
Medical, dental & vision;
Critical Illness;
Accident, and Hospital; 401(k) Retirement Plan – Pre‑tax and Roth post‑tax contributions available;
Life Insurance (Voluntary Life & AD&D for the employee and dependents);
Short and long‑term disability;
Health Spending Account (HSA);
Transportation benefits;
Employee Assistance Program;
Time Off/Leave (PTO, Vacation or Sick Leave).

This is a hybrid position in Chicago, IL.

This position is anticipated to close on Mar 5, 2026.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.