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