Technical Architect - Data Platform

Experienced Technical Architect (Hands-on) responsible for defining and building the end-to-end architecture of a specialty insurance claims data platform on Microsoft Fabric. Owns the solution design, technology decisions, and implementation of a production-grade Lakehouse and Medallion Architecture, leading data ingestion, transformation, governance, and analytics while actively contributing to development and delivery.

• 15 years of IT experience, including 10 years in Data Architecture, Data Engineering, and Analytics
• 3+ years of hands-on Microsoft Fabric experience (Mandatory) covering Lakehouse, OneLake, Data Pipelines, Delta Tables, SQL Database/Warehouse, and Medallion Architecture
• 8+ years of Azure Data Platform and Cloud Architecture experience, including integration, governance, security, scalability, and performance optimization
• 8+ years of hands-on Microsoft Fabric experience including Pipelines, Lakehouse, OneLake, Delta Tables, SQL Database/Warehouse, and Medallion Architecture (Bronze/Silver/Gold)
• 10+ years of Azure Cloud Architecture experience, including data integration, governance, security, scalability, and performance optimization
• 8+ years of hands-on SQL and Python development experience; Data Quality, Data Governance, Reconciliation, and Intake Control frameworks
• 10+ years of experience designing enterprise data platforms and layered architectures (Raw, Standardized, Curated)
• 5+ years of experience designing historical data retention and auditability solutions, including record versioning, change tracking, SCD Type 2, and full history preservation
• 5+ years of experience in Master Data Management (MDM), record matching, deduplication, entity resolution, and survivorship rules.
• 3+ years of experience with Azure AI Document Intelligence (Form Recognizer) or equivalent document extraction solutions
• 5+ years of experience designing HIPAA/PHI-compliant healthcare data platforms, including privacy, retention, residency, and access controls.
• Strong client-facing architecture leadership experience, serving as the primary technical authority and driving architecture, design, and implementation decisions
• Secondary Skills / Good to have – Experience working with insurance claims, healthcare payer, or health-plan data platforms; Experience with Snowflake data platform architecture and implementation; Microsoft Fabric Analytics Engineer, Azure Solutions Architect, or related Microsoft certifications

The customer processes 50,000+ claims annually across 250+ Third-Party Administrators using a fragmented, manual intake stack. The platform you architect will eliminate that friction, automate eligibility workflows, and become the data foundation on which all future AI/ML, BI, and operational capabilities are built. Phase 1 establishes a production-proven foundation on five priority TPAs — the architecture you get right here sets the pattern for the full TPA network in subsequent phases.

• Architect and design the overall data platform on Microsoft Fabric: how raw files land, how they are standardised, and how the finished data is published for the customer's teams to use
• Understand the customer’s business needs and translate to a technical architecture design
• Design scalable and configurable data ingestion, transformation, and onboarding frameworks capable of supporting multiple TPA file formats, schema evolution, drift detection, and rapid provider onboarding
• Define and implement historical data management, auditability, and replayability strategies, ensuring complete record versioning and preservation of historical business data
• Design how the system recognises the same claimant across different files, years and spellings, using a set of matching rules with human review for the uncertain cases
• Design how the system will incorporate both OLAP and OLTP processing to meet different use cases. An OLAP process that produces a canonical model for analytics purposes and an OLTP process that feeds the web applications for Eligibility data management, failed file review, and system auditability
• Design and govern data quality, reconciliation, validation, duplicate detection, exception handling, and intake control frameworks to ensure data accuracy and operational reliability
• Design and integrate Azure AI Document Intelligence or equivalent solutions for automated extraction and processing of structured, semi-structured, and unstructured data
• Design and govern the Security and compliance side: who can see what, how sensitive health data is protected, how everything is logged, and how data is retained for seven years
• Design how the platform copes with roughly ten different file layouts per data provider, so that new layouts can be added by configuration rather than new code
• Write down every significant technical decision so the design survives beyond any one person; Serve as the primary technical advisor to client architecture, security, platform, and business leadership teams, driving architecture decisions, managing technical risks, and providing clear recommendations on trade-offs and solution direction
• Design secure operating models that enable global delivery while maintaining compliance with HIPAA and US PHI handling requirements
• Lead architecture reviews, establish engineering standards, document key design decisions, and provide technical governance across all workstreams
• Partner with client and delivery teams to define data consumption patterns, integration standards, and modernization roadmaps, ensuring successful program delivery and scope governance
• Communicate effectively with stakeholders; Use clear verbal, written (emails, documentation), and instant messaging approaches to ensure alignment
• Build and maintain productive relationships across cross-functional teams; Provide constructive feedback during requirement workshops and be open to stakeholder input
• Strong analytical mindset to evaluate process flows; Ability to troubleshoot requirement gaps, compliance risks, and process inefficiencies
• Experience working in Agile/Scrum projects with tools like Jira or Azure DevOps; Provide regular updates, demonstrate proactivity, and show due diligence in carrying out responsibilities
• Skilled in facilitating workshops, UAT sessions, and requirement walkthroughs; Act as liaison between business and technical teams, ensuring clarity and consensus
• What Success Looks Like / Expected Outcome – Successful delivery and adoption of Phases I of the Claims Management Platform, meeting business objectives, quality standards, and project timelines