Note: The job is a remote job and is open to candidates in USA. Pyramid Consulting is recruiting for a confidential healthcare client. The Senior Data Architect will define end-to-end data architecture for a healthcare underwriting and quoting initiative, including data models, integration strategies, governance, and implementation-ready documentation.

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

Skills

• 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

Benefits

• Traveler benefits as per agency package. (Benefits vary by vendor and assignment.)
• Remote work (U.S.).

Company Overview

Company H1B Sponsorship