"The healthcare data integration space is exploding as states modernize Medicaid and patient record systems. Professionals who can bridge EHR platforms with robust analytics are in high demand, especially for time\u2011critical state projects. This senior Technical Specialist role offers a unique chance to lead critical integrations for North Carolina's health ecosystem.\n\n# Job Summary\nThe Senior Technical Specialist will lead technical support for EHR data integrations, enhance the NC HealthConnex Clinical Portal, and manage ETL pipelines. Core duties include developing and optimizing SQL, SAS, and HealthShare queries, performing exploratory data analysis, and ensuring the stability of SAS environments.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|---|---|---|\n| SQL | Powers data extraction, transformation, and reporting across Medicaid systems | Senior |\n| SAS | Enables advanced analytics and reporting for health data | Senior |\n| InterSystems HealthShare | Central to EHR interoperability and real\u2011time health information exchange | Senior |\n\n# Interview Preparation\n1. **Explain how you would design an ETL pipeline to ingest Medicaid claim data from multiple EHR vendors.**\n - *What the interviewer is looking for:* Understanding of data mapping, transformation logic, error handling, and performance tuning.\n2. **Describe a complex SQL query you wrote to reconcile patient records across disparate systems.**\n - *What the interviewer is looking for:* Ability to join large tables, use window functions, and ensure data integrity.\n3. **How do you troubleshoot performance issues in a SAS environment supporting large health datasets?**\n - *What the interviewer is looking for:* Knowledge of SAS server configuration, profiling tools, and optimization techniques.\n4. **What is InterSystems HealthShare, and how have you used it to enable real\u2011time data exchange?**\n - *What the interviewer is looking for:* Practical experience with HealthShare components (e.g., VISTA, OpenHIE) and integration patterns.\n5. **Give an example of a data\u2011driven report you built that impacted Medicaid service delivery.**\n - *What the interviewer is looking for:* Ability to translate analytics into actionable insights for stakeholders.\n\n# Resume Optimization\n- Technical Specialist \u2013 Senior\n- SQL development\n- SAS analytics\n- InterSystems HealthShare\n- EHR integration\n- Medicaid data\n- ETL processes\n- Data extraction & transformation\n- Exploratory Data Analysis (EDA)\n- Healthcare reporting\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email greeting, attach your updated resume, and clearly highlight your top skills. Make sure to mention related skills you possess, such as advanced SQL query optimization, SAS analytics for large health datasets, and hands\u2011on experience with InterSystems HealthShare. Reference specific projects where you led EHR integrations or built Medicaid reporting solutions.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|---|---|---|---|\n| Technical Specialist \u2013 Senior | 5\u20117 years | Data integration, ETL, analytics leadership | Lead Technical Architect |\n| Lead Technical Architect | 8\u201112 years | Enterprise\u2011wide health information architecture | Director of Health IT |\n| Director of Health IT | 12+ years | Strategic IT governance, cross\u2011state initiatives | VP of Healthcare Technology |\n"