Healthcare Data Architect / Enterprise Data Architect – Azure & Databricks

Pyramid Consulting, Inc; United States; Remote; USD 103,000 - 110,000; Full time

Benefits offered by this job

Agency travel benefits

Job summary

Pyramid Consulting, Inc. seeks a Healthcare Data Architect / Enterprise Data Architect to design end-to-end data architecture using Microsoft Azure and Databricks for a new healthcare underwriting and quoting initiative.

This contract role requires 15+ years of experience in data architecture and healthcare domain expertise. You will model data, implement ingestion and governance, enable Power BI reporting, and collaborate with executives and engineering teams.

Qualifications

• 15+ years in data architecture / enterprise data solutions.
• Healthcare data architecture experience and domain knowledge.
• Strong modeling (conceptual, logical, physical, dimensional).
• Azure, Azure Databricks and data lake technologies expertise.
• Power BI data modeling, analytics, and reporting experience.
• Translate business requirements into architecture and specs.
• Excellent executive communication and cross-functional collaboration.
• Experience with healthcare payers, underwriting, or pricing.
• Familiarity with healthcare data privacy, governance, and regulatory rules.
• Experience using AI tools to accelerate architecture work.

Responsibilities

• Design end-to-end data architecture for a new healthcare underwriting/quoting initiative.
• Develop conceptual, logical, and physical data models for multiple systems.
• Create a unified data model for three new systems with differing structures.
• Define ingestion, integration, transformation, and movement strategies.
• Architect the data layer for product selection, underwriting, and quotes.
• Support real-time processing and analytical reporting requirements.
• Design dimensional models to support Power BI reporting and BI workflows.
• Define data catalog, metadata, lineage, and governance requirements.
• Leverage Azure, Databricks, and data lake tech to build scalable architecture.
• Explore automation with Power Automate and AI productivity tools where helpful.
• Collaborate with executives, stakeholders, architects, data specialists, and engineers.

Skills

Data architecture

Enterprise data modeling

Dimensional modeling

Healthcare domain knowledge

Executive communication

Stakeholder management

Solution design

Independent work

Tools

Azure

Azure Databricks

Data Lake technologies

Power BI

Power Automate

AI productivity tools

Job description

Immediate need for a talented \"Healthcare Data Architect / Enterprise Data Architect – Azure & Databricks\". This is a 06+months contract opportunity with long-term potential and is located in U.S(Remote). Please review the job description below and contact me ASAP if you are interested.

Job ID: 26-33058

Pay Range: $75/hr - $80/hour. Traveler benefits as per agency package. (Benefits vary by vendor and assignment.)

Key Responsibilities:

• Design and define the end-to-end data architecture for a new healthcare underwriting and quoting initiative.
• Develop conceptual, logical, and physical data models to support multiple interconnected business systems.
• Design a unified data model that accommodates three new systems with different data structures and operational requirements.
• Define data ingestion, integration, transformation, validation, and movement strategies across internal applications and external data sources.
• Architect the data layer supporting product selection, underwriting, external data retrieval, and quote generation.
• Establish data structures and integration patterns that support real-time transactional processing and analytical reporting.
• Design dimensional models and data structures to support Power BI reporting, analytics, and business intelligence.
• Define data catalog, metadata management, data lineage, and data governance requirements.
• Leverage Microsoft Azure, Databricks, and data lake technologies to establish a scalable and maintainable architecture.
• Evaluate opportunities to streamline workflows through Power Automate and other business process automation capabilities.
• Use AI productivity tools, including ChatGPT/GPT, Claude, and Microsoft Copilot, where appropriate to accelerate architecture design, documentation, and analysis.
• Collaborate with executives, business stakeholders, existing architects, data specialists, and engineering teams.
• Translate business objectives into architecture specifications, technical documentation, implementation plans, and delivery milestones.
• Identify architectural gaps, integration dependencies, data quality challenges, and technical risks.
• Deliver an implementation-ready data model and supporting architecture documentation for engineering handoff.

Key Requirements and Technology Experience:

• 15+ years of experience in data architecture, enterprise data solutions, solution architecture, or related technical disciplines.
• Direct experience designing and delivering data architecture solutions in the healthcare industry.
• Strong expertise in enterprise data modeling, including conceptual, logical, physical, and dimensional modeling.
• Experience with Microsoft Azure, Azure Databricks, and data lake technologies.
• Proven experience integrating multiple systems with different data structures and schemas.
• Experience designing data ingestion, transformation, integration, and data movement strategies.
• Understanding of architectures supporting real-time transactional processing and reporting workloads.
• Experience with Power BI data modeling, analytics, and reporting architecture.
• Familiarity with Power Automate and business workflow automation.
• Experience with data cataloging, metadata management, data governance, and data lineage.
• Strong business analysis and solution design capabilities, including the ability to translate business requirements into technical architecture.
• Excellent executive communication, stakeholder management, and cross-functional collaboration skills.
• Ability to work independently, establish architecture direction, and deliver technical blueprints with minimal supervision.
• Experience with healthcare payer organizations, health insurance, managed care, or related healthcare business operations.
• Direct experience with healthcare underwriting, quoting, pricing, or product configuration processes.
• Experience consolidating internal enterprise data with third-party or external data sources.
• Experience designing data architecture for newly introduced applications or enterprise transformation programs.
• Familiarity with healthcare data privacy, security, governance, and regulatory requirements.
• Experience using generative AI tools such as ChatGPT, Claude, and Microsoft Copilot to support technical work.
• Experience preparing architecture roadmaps, technical design specifications, and engineering handoff packages.

Our client is a leading Healthcare Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.