Data Architect – PBM Data Modernization
Could this role work from Kenya?
Kenya eligibility needs confirmation
- Stated location
- United States
- Listing updated on our site
- 15 Nov 2026, 01:01 EAT
- Timezone range utc-10 to utc+14 overlaps EAT (UTC+3)
- Restriction detected: "us only"
- Location names another country; Kenya eligibility is not established.
These are automated wording checks, not confirmation from the employer. The update date records a site update, not a hiring check. Review location, working hours, experience, and current availability in the application portal. Employer identity remains hidden here.
Your application workflow
- 1. Check requirements
- 2. Tailor your CV below
- 3. Apply through the portal
- 4. Track your progress
AI Application Copilot
Prepare role-focused CV bullets and a cover letter to review
| Employer | Verified Direct Employer (Protected) |
|---|---|
| Location | United States |
| Remote type | Contractor |
| Posted | 2h ago |
| Application Status | Pro Membership & Free Pass Access |
About this role (Direct Employer Details Protected)
This is a remote position.
Data Architect – PBM Data Modernization
Location: Remote (US Only) Industry:Pharmacy Benefit Management (PBM)Platform:Google Cloud Platform
Role Overview
We're looking for a Data Architect to lead data modeling and source-to-target mapping for a Pharmacy Benefit Manager (PBM) modernization program on Google Cloud. The role covers migrating legacy claims and eligibility data, and the IBM Cognos reporting built on it, into a new BigQuery-based enterprise data warehouse. It also ensures the future-state platform meets state-specific Medicaid reporting requirements, starting with the MVP.
Key Responsibilities
- Define the semantic and logical data models for MVP and future-state reporting, covering pharmacy claims, member eligibility, prescriber, pharmacy network, formulary, rebates, and pricing domains.
- Own mapping execution end to end. Define source-to-target mappings, transformation rules, and business logic from legacy structures to the new warehouse.
- Inventory and analyze legacy IBM Cognos (Cognos Explorer / Cognos Analytics) reports, packages, and Framework Manager models. Reverse-engineer embedded business logic and calculations, and rationalize reports for redesign on the future-state platform.
- Set mapping standards, templates, naming conventions, and documentation practices. Direct the Data and Systems Analysts and review their work for quality and consistency.
- Lead gap analysis and drive each gap to a decision (build, defer, workaround, or descope) with business, compliance, and technical stakeholders.
- Translate state Medicaid reporting requirements (encounter data submissions, MCO/PBM transparency reports, spread pricing and pass-through disclosures, T-MSIS-aligned extracts) into data model and mapping specifications.
- Define data quality rules, reconciliation checkpoints, and lineage so legacy-to-target results, including Cognos report outputs, are traceable and audit-ready.
Requirements
Qualifications
- 10+ years in data architecture or data modeling, with at least 3 years in PBM, pharmacy, or health plan data.
- Hands-on experience with NCPDP claim standards, Medicaid and managed care reporting, and legacy migration programs.
- Strong skills in dimensional and semantic modeling, plus advanced SQL.
- Experience with IBM Cognos Analytics / Cognos Explorer, including Framework Manager packages, report specifications, and migrating Cognos reporting to a modern BI platform.
- Hands-on experience with Google Cloud data services:
- BigQuery for warehouse design, including partitioning, clustering, and authorized views
- Dataflow and Dataproc for transformation pipelines
- Cloud Composer (Airflow) for orchestration
–Cloud Storage for landing zones
- Dataform or dbt for SQL-based transformations
- Familiarity with Dataplex and Data Catalog for metadata, lineage, and data quality, and with Looker (LookML) for building the semantic layer.
- Proven experience leading analyst teams and running mapping governance.
- Working knowledge of HIPAA, CMS regulations, and state-level Medicaid compliance, along with GCP security controls (IAM, VPC Service Controls, CMEK).
- Location & Work Authorization: Must currently reside in the United States and hold valid US work authorization without sponsorship.
Nice to Have
- Exposure to Vertex AI or Gemini in BigQuery for AI-assisted mapping, profiling, and documentation.
- Google Cloud Professional Data Engineer or Professional Cloud Architect certification.
Originally posted on [Employer]
Unlock 0-Second Direct Apply
This role was published 2h ago. Global recruiters typically freeze applications after receiving the first 50 CVs. Pro members and Free Pass holders reveal the employer identity and get immediate 0-second direct apply access before positions fill.
Top of Recruiter Inbox
First 20 applicants receive 80% of recruiter interviews.
AI ATS Match Tailoring
Instant role-targeted bullets & cover letters.
Remote Contractor Toolkit
USD invoices, W-8BEN guide & CRM pipeline.
Instant M-Pesa STK push · 7-Day Money-Back Guarantee · Be in the first 20 applicants
Related Remote Jobs Open to Kenya
Explore similar international remote opportunities
Pediatric Nurse Advisor
Verified Direct Employer · Vetted
Overview To be part of our organization, every employee should understand and share in the YNHHS Vision, support our Mission, and live our Values. Th…
Charge Master Analyst - Revenue Integrity - FT Days
Verified Direct Employer · Vetted
Who We Are UCI Health is one of [Employer]’s largest academic health systems and the clinical enterprise of the [Employer]. Established on July 1, 197…
Global Account Manager
Verified Direct Employer · Vetted
Summary of Position The Global Account Manager will serve as the main liaison between the Client, [Employer] and its global network of agency partner…