Data Architect
Pittsburgh, United States · Full-time
- Posted 1mo ago
- From Blackbuck Insights’s careers page
- Location
- Pittsburgh, United States
- Type
- Full-time
- Level
- Senior
- Experience
- 10+ years
- Department
- Data and Analytics
Opens the listing on careers.bbinsight.com
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
Job Description
BBI is a multinational IT consulting services provider in the new-generation digital technology ecosystem. We are an extension of our client teams, providing solutions in niche technologies. Our key differentiators are quality and speed-to-market.
The Healthcare Payer Data Architect will help establish a domain-oriented data architecture discipline across Member, Clinical, Provider, and Claims. Working with the client senior enterprise data architect, domain stakeholders, and data engineering teams, this role will assess the current architecture, define future-state designs, and develop practical transition roadmaps for a legacy, multi-tenant health platform spanning on-premises and cloud environments.
Job Duties Include:
- Partner with the senior enterprise data architect to establish architecture standards, reusable patterns, design reviews, and decision documentation.
- Work with payer business stakeholders to understand domain workflows and translate them into conceptual, logical, and physical models.
- Assess current-state interface, integration, security, infrastructure, and technology architecture; define future-state designs and phased transition roadmaps.
- Design source-to-target mappings, data contracts, and integration patterns using APIs, events, streaming, CDC, batch or file transfers, and federation.
- Evaluate legacy Oracle CDC flows through Informatica PowerCenter and Kafka and recommend redesigns.
- Assess fragmented implementations across mainframe sources, databases, FHIR, Hadoop, Denodo, ODS, Kafka, and Confluent.
- Design data products and consumption interfaces for APIs, portals, extracts, analytics, and AI or machine-learning use cases.
- Embed security, privacy, multi-tenancy, and fine-grained access into target designs.
- Partner with security, privacy, and compliance stakeholders to translate tenant-specific rules into enforceable controls.
- Assess downstream impacts of source-schema changes, including key changes, and define compatibility, versioning, and lineage practices.
- Define architecture requirements for resiliency, performance, monitoring, data quality, and operational support.
- Coordinate with data engineering on implementation designs, testing, reconciliation, and promotion through production rollout.
- Influence stakeholders, facilitate cross-domain decisions, and support change management.
Required Qualifications
- Bachelor's or graduate degree in computer science, information systems, or a related field.
- Substantial experience in enterprise data architecture and data modeling, including end-to-end delivery of complex data initiatives.
- Healthcare payer domain experience with depth in one or more of Member, Clinical, Provider, or Claims.
- Hands-on capability with medallion modeling, data services, streaming, and FHIR.
- Ability to set standards, design data models, define migration patterns, and mentor teams.
- Hands-on expertise in conceptual, logical, and physical modeling, reverse engineering, source-to-target mapping, metadata, and lineage.
- Strong SQL and database skills, with experience designing data warehouses or lakehouses and ETL/ELT processes.
- Ability to select and design appropriate API, event, streaming, CDC, batch/file, and federated integration patterns.
- Experience assessing legacy and cloud architectures and defining modernization and migration roadmaps.
- Experience designing secure multi-tenant data solutions and fine-grained access controls; understanding of healthcare privacy.
- Strong communication, stakeholder influence, analytical problem-solving, and change-management skills.
Preferred Qualifications
- Deep healthcare payer domain knowledge (835, 834, 837 transactions, provider directories, member 360, value-based care data).
- Experience with Oracle, Informatica PowerCenter, Kafka or Confluent, mainframe data sources, FHIR, Monte Carlo, Starburst, Atlan, dbt, Denodo, or ODS components.
- Experience modernizing healthcare payer platforms that serve multiple health plans or tenants.
- Experience defining domain-oriented architecture operating models, reusable standards, and data contracts.
- Experience designing data products and supporting analytics, AI or machine learning, portals, and API-based consumption.
- Product-management experience or the ability to prioritize architecture work by business value and adoption needs.
Skills they ask for
Pick one to see other roles that ask for it.
About Blackbuck Insights
Data and AI consultingBlackbuck Insights is a data and AI consulting firm covering data engineering, cloud, analytics and AI, with teams across the US, Canada and India.
See all 16 roles at Blackbuck InsightsMore roles at Blackbuck Insights
See all 16- AI/LLM EngineerBengaluruSoftware DevelopmentBengaluru, India3d
- Python DeveloperBengaluru · PrincipalSoftware Development · PrincipalBengaluru, India3d
- Software Engineer - FullStackBengaluruSoftware DevelopmentBengaluru, India3d
- Python AI DeveloperBengaluruSoftware DevelopmentBengaluru, India3d
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.