Jobs → Data & Analytics → Data Architect

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

Similar projects

Data Architect – AWS
Venkat K · AWS Data Engineering, Apache Airflow, PySpark
Data Engineer
Shivani Gupta · Snowflake ETL/ELT, Informatica CDGC, Infrastructure as Code (IaC)
Data Engineer
Mohd Uvesh · Snowflake, Informatica CDGC, Terraform
Early · 0 applied1 of 5,514 projects

Apply with AI cover letter

AI writes a personalized application in 19 seconds. Just upload your resume.

No credit card · First application free
© 2026 Freelanly · Terms · Privacy