Data Architect – PBM Data Modernization

New
K
KData Inc.Pharmacy benefit management
Remote (US Only)ContractSenior
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Experience
10+ years in data architecture or data modeling, with at least 3 years in PBM, pharmacy, or health plan data.
Required Skills
GCPData modelingBigQuery

Requirements

  • Have 10+ years of experience in data architecture or data modeling.
  • Have at least 3 years of experience in PBM, pharmacy, or health plan data.
  • Bring hands-on experience with NCPDP claim standards, Medicaid and managed care reporting, and legacy migration programs.
  • Have strong dimensional and semantic modeling skills and advanced SQL experience.
  • Have experience with IBM Cognos Analytics or Cognos Explorer, including Framework Manager packages and report specifications, and migrating Cognos reporting to a modern BI platform.
  • Have hands-on Google Cloud experience with BigQuery warehouse design, including partitioning, clustering, and authorized views.
  • Have experience with Dataflow, Dataproc, Cloud Composer (Airflow), Cloud Storage, and Dataform or dbt.
  • Be familiar with Dataplex, Data Catalog, metadata, lineage, data quality, and Looker (LookML).
  • Have experience leading analyst teams and running mapping governance.
  • Have working knowledge of HIPAA, CMS regulations, state-level Medicaid compliance, and GCP security controls including IAM, VPC Service Controls, and CMEK.

Responsibilities

  • Define semantic and logical data models for MVP and future-state reporting across pharmacy claims, member eligibility, prescriber, pharmacy network, formulary, rebates, and pricing.
  • Own source-to-target mappings, transformation rules, and business logic from legacy structures to the new warehouse.
  • Inventory and analyze IBM Cognos reports, packages, and Framework Manager models; reverse-engineer embedded business logic and calculations.
  • Rationalize legacy reports for redesign on the future-state platform.
  • Set mapping standards, templates, naming conventions, and documentation practices, and review Data and Systems Analysts’ work.
  • Lead gap analysis and drive decisions with business, compliance, and technical stakeholders.
  • Translate state Medicaid reporting requirements into data model and mapping specifications.
  • Define data quality rules, reconciliation checkpoints, and lineage for traceable, audit-ready legacy-to-target results.
  • Work with data engineers on GCP ingestion and transformation design, using Vertex AI and Gemini to accelerate mapping, profiling, and documentation.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now