Data Architect
Madhusudhan Reddy ChallaUnited StatesSENIORPosted 2h ago
Data ArchitectureData ModelingPBMPharmacyHealth Plan dataPharmacy ClaimsMember EligibilityNCPDPMedicaid reportingSQLDimensional ModelingSemantic ModelingSource-to-Target MappingIBM Cognos AnalyticsCognos ExplorerFramework ManagerCognos reportingData warehousesGoogle Cloud PlatformBigQueryDataflowDataprocCloud ComposerCloud StorageDataformdbtDataplexData CatalogLookerLookMLMedicaid reportingCMS regulationsHIPAAVertex AIGeminiAI-assisted data mappingAI-assisted data profilingAI-assisted data documentationT-MSISMCO/PBM transparency reportingSpread pricingPass-through disclosures
About the Role
We are looking for a Data Architect to lead PBM data modernization efforts. This role focuses on transforming legacy systems to modern data architectures using Google Cloud Platform.
Key Responsibilities
• Lead PBM data modernization from legacy platforms to BigQuery
• Define enterprise data models and source-to-target mapping
• Drive pharmacy claims and eligibility data migration
• Reverse-engineer legacy Cognos reports and business logic
• Establish data quality, reconciliation, lineage, and governance standards
• Translate Medicaid reporting requirements into scalable data architecture
Requirements
• 10+ years of experience in Data Architecture and Data Modeling
• Strong knowledge of Pharmacy Claims, Member Eligibility, NCPDP standards, and Medicaid reporting
• Advanced SQL, Dimensional Modeling, Semantic Modeling, and Source-to-Target Mapping
• Experience with IBM Cognos Analytics, Cognos Explorer, and Framework Manager
• Experience modernizing legacy Cognos reporting platforms and migrating to modern data warehouses
• Strong GCP experience, especially BigQuery, Dataflow, Dataproc, Cloud Composer, and Cloud Storage
• Experience with Dataform / dbt, Dataplex, Data Catalog, and Looker / LookML
• Knowledge of Medicaid reporting, CMS regulations, HIPAA, and healthcare data compliance
• Experience leading data analysts and managing mapping governance