Data Architecture & Engineering

• Design and optimize data models (OLTP, OLAP, star schema, wide tables, normalized and denormalized structures).
• Architect and manage SQL Server instances, including schema design, indexing strategy, query optimization, stored procedures, SSIS/ETL/ELT frameworks.
• Develop scalable data ingestion pipelines using batch, micro‑batch, and streaming patterns.
• Implement data governance, lineage tracking, quality rules, metadata management, role‑based access, and retention.
• Integrate data across EHRs, practice management systems, operational databases, and cloud services.

Application & Integration Architecture

• Architect full‑stack solution designs involving APIs, message queues, microservices, and cloud-native components.
• Oversee the development of custom applications, dashboards, analytic tooling, and automated workflows.