Job Description
Job Family : Data Science Consulting Travel Required : Up to 25% Clearance Required : Ability to Obtain Secret Guidehouse is seeking a MHS GENESIS Application Support Analyst to support the Defense Health Agency (DHA) by developing, maintaining, and delivering advanced analytics across Health Data Intelligence (HDI) and Oracle analytics platforms. This role focuses on back-end revenue cycle data extracts, financial and compliance reporting, and uncovering data-driven insights that support Revenue Cycle Modernization and Innovation (RCMI) initiatives. The ideal candidate combines advanced technical skills (Vertica SQL, analytics, database engineering) with deep domain expertise in healthcare revenue cycle management (RCM). This analyst will play a critical role in supporting DHA leadership by developing reporting capabilities across MHS Data Systems, including across the HDI platform. What You Will Do: : Investigate, triage, and help resolve application/data issues impacting revenue cycle, registration, patient access, and scheduling workflows. Develop, maintain, and optimize Vertica SQL and CCL/Discern queries and reusable extracts to support analytics and operational reporting within MHS GENESIS systems. Conduct back-end configuration reviews and diagnostics to identify root causes affecting billing, claims, or encounter workflows and coordinate durable remediation. Use CCL, SQL, Tableau, Power BI, Python, SAP BO, and other analytics tools to extract, analyze, and interpret financial and operational data across MHS data platforms. Develop, optimize, and maintain Vertica SQL queries, view, and reusable datasets supporting revenue cycle analytics (billing, collections, denials, A/R). Mon