Healthcare Data Warehouse Architect

We are moving to Microsoft Fabric and need a hands-on Healthcare Data Warehouse Architect who has designed and built analytics data architectures for healthcare payers or providers, with a focus on claims and revenue cycle data. This contract engagement begins with an architecture assessment and design phase, with potential to extend into a longer-term build and delivery role. You will work directly with our Director of AI Solution Delivery to evaluate our current architecture, identify gaps, and create a modern, scalable data foundation that supports traditional BI reporting as well as emerging AI/ML and agentic workloads. Total Experience - 15+ yrs Work Timings - 8PM - 4AM IST (Flexible) Remote location What You Will Do • Assess our current data architecture and identify structural gaps and technical debt • Design a purpose-built data warehouse hybrid architecture optimized for healthcare revenue cycle analytics — including structured: claims, insurance transactions (Pmt, Adjs, Denials), AR Aging, Payer data, as well as unstructured document storage and retrieval. Document Classification: Public • Architect and implement a clean semantic layer that supports both Power BI reporting and natural language / AI agent query patterns • Consult on existing data pipelines using Azure Data Factory (ADF) and modern Azure data services • Implement best practices around medallion architecture, data modeling (star schema, Kimball, OBT vs. normalized tradeoffs), and incremental loading patterns • Advise on and implement appropriate use of Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Azure SQL, and related services • Bring hands-on experience with document storage, chunking, and vectorization pipelines for unstructured healthcare data (EOBs, remittance advice, clinical notes) feeding AI/RAG workloads • Document architecture decisions, data models, in a way that supports team knowledge transfer What You Should Have: • 10+ years of hands-on data warehouse design and build experience — architecture documents alone are not sufficient; we need someone who has written the code and built the schemas • Deep healthcare domain expertise — specifically in revenue cycle, payer/provider data models, and healthcare financial data • Azure data platform expertise — Fabric, ADLS Gen2, Azure Data Factory, Azure Synapse Analytics, Azure SQL, Azure Blob/Document Storage • Strong SQL and T-SQL skills — including query optimization, indexing strategy, and performance tuning on large datasets • Star schema and dimensional modeling expertise — Kimball methodology, fact/dimension design, SCD handling • Power BI integration experience — designing data models and semantic layers that perform well in Power BI import and DirectQuery modes • Ability to work independently and communicate clearly with both technical and executive stakeholders