Technical Architect Data Platform

Santa Clara, CA, US • Posted 15 hours ago • Updated 15 hours ago
Full Time
On-site
$150000 - $170000/yr
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

Summary

Technical Architect Data Platform
REMOTE / Work from Home
Salary – Market- Negotiable for right candidate
Start: Immediate


We are hiring Technical Architect to own end-to-end solution architecture for a specialty medical stop loss insurance enterprise''s CEO-prioritized claims data platform modernization. You will design and govern a production-ready Microsoft Fabric Lakehouse — covering the full medallion stack from ingestion through curated Gold layer views — while serving as the primary technical authority in direct engagement with client leadership. This is a hands-on architecture role embedded in the delivery team, with a hard production deadline and real commercial stakes on every design decision.

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.

Skills & Experience
  • 12+ years in data engineering and analytics; 3+ years as a Technical or Solution Architect on enterprise-scale, multi-workstream data programs
  • Hands-on expertise in Microsoft Fabric — OneLake, Fabric Data Factory, Lakehouse, Delta Lake, medallion architecture, and point-in-time reconstruction patterns
  • Tech Stack – MS Fabric (OneLake, Data Factory, Lakehouses, Delta Lake), Azure Document Intelligence, Microsoft Purview, Okta SSO, Python, SQL, Azure AI Services, Azure DevOps, Git and WinAIDM (Ingestion / Quality / Transformation / Reporter Agents – preferred)
  • Proven experience designing data quality and intake control frameworks — schema validation, SLA checks, reconciliation, exception triage queues, and quarantine/reject workflows
  • Deep experience designing canonical data models for complex transactional domains — insurance claims, healthcare, or financial services strongly preferred
  • Hands-on experience with Azure AI Services — Azure Document Intelligence (Form Recognizer) or equivalent for unstructured/semi-structured document extraction integrated into pipelines
  • Strong Python and SQL — you review and write production-grade code, not just diagrams
  • Demonstrated experience leading customer-facing technical engagements with full delivery accountability — you own the outcome, not just the architecture review

Good to Have
  • Experience with Azure Databricks for large-scale historical data processing or complex transformations alongside Fabric
  • Power BI embedded reporting or Fabric Real-Time Intelligence experience
  • Familiarity with medical stop loss insurance, TPA ecosystems, or healthcare claims data formats (837, 835)
  • Microsoft Fabric Analytics Engineer (DP-600) or Azure AI Engineer Associate (AI-102) certification

Architecture & Solution Design –– Design and govern the OneLake medallion architecture (Bronze / Silver / Gold) for claims, eligibility, and policy/contract data across five Phase 1 TPAs; Define the AI-assisted schema registry — versioned alias handling for ~10 TPA format variants each, with drift detection and forward-compatible schema evolution; Architect the canonical claims data model: standardized diagnosis/procedure/revenue codes, member/dependent/ subscriber normalization, and full adjustment/void/reversal handling; Specify all six Gold layer curated 360 views — Insured/Claimant, Policy/Contract, Claim/ Claim Line, Large Claimant, Clinical/Case Signal, and Underwriting/Renewal — and govern delivery to acceptance criteria; Design the custom rule-based MDM claimant mastering service with probabilistic matching, human-in-the-loop review UI, and historical plus current-state coverage

Data Platform & AI Integration –– Govern the Fabric Data Factory pipeline architecture for batch file intake (xlsx, csv, txt) with SLA monitoring, control totals, duplicate detection, and quarantine/reject workflows; Architect the Azure Document Intelligence integration for eligibility PDF and screenshot extraction, including human-in-the-loop validation workflow design; Define Microsoft Purview adoption for data classification, lineage tracking, and 7-year PHI retention compliance; Embed WinWire''s WinAIDM AI accelerators across all pipeline workstreams — Data Ingestion Agent, Data Quality Agent, Data Transformation Agent, and Reporter Agent; Drive the cross-validation strategy comparing new platform outputs against existing platform for accuracy and directional consistency

Governance, Security & Compliance –– Design PHI access controls and data masking patterns enabling offshore development while meeting US-preferred PHI requirements; Establish the four-role RBAC model (Admin, IT Support, Regular User, Read-preferred) across the eligibility portal and all operational UIs; Deliver architecture documentation, runbooks, and the Gold layer consumption specification for the client''s downstream claim creation platform

Technical Leadership –– Lead sprint zero discovery backlog definition, TPA file layout review, RACI, tooling access, and delivery cadence establishment; Conduct architecture decision reviews and set engineering standards across all workstreams and the full offshore team; Mentor the offshore Technical Architect and Technical Lead on Fabric patterns, WinAIDM usage, and medallion implementation best practices

Client Engagement –– Serve as the primary technical voice in stakeholder meetings with client technology and business leadership — translating platform decisions into clear, decision-ready recommendations; Partner with the client''s internal team to define Gold layer consumption spec and integration handoff criteria for the downstream claim creation platform; Proactively surface trade-offs (build vs. configure, performance vs. cost, scope vs. timeline) and guide the client to the right decision — trusted advisor, not order-taker

What Success Looks Like / Expected outcome — OneLake medallion architecture fully operational for five Phase 1 TPAs — Bronze immutable history, Silver canonical current state, Gold curated views consumed by the client''s claim creation team before go-live. AI-assisted schema registry live and handling format drift across all Phase 1 TPA variants without manual intervention; Intake control layer operational with documented DQ rules per TPA, failed files routed to review queue with structured reason codes; A successful implementation of Phase I and II of Claims Management Platform. WinAIDM accelerators deployed and driving measurable reduction in pipeline development and validation effort across the team. Client technology stakeholders describe WinWire as a "trusted architecture guide" — proactive, decision-ready, and commercially aligned
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10117909
  • Position Id: 26-12983
  • Posted 15 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Santa Clara, California

Today

Easy Apply

Full-time, Third Party

Depends on Experience

Mountain View, California

Today

Full-time

USD 119,800.00 - 234,700.00 per year

Mountain View, California

Today

Full-time

USD 142,800.00 - 274,800.00 per year

Mountain View, California

Today

Full-time

USD 168,926.00 - 192,500.00 per year

Search all similar jobs