Technical Architect - Data Platform Salary Market- (DOE) Kennesaw, GA 30144 (Onsite) Full-Time / Direct-Hire / FTE 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.
Job / Role Description- 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