Application Support Analyst

This is a fully remote position, open to applicants in Texas, +1 more state.

📋 Description

• Investigate, triage, and assist in resolving application and data issues that affect revenue cycle, registration, patient access, and scheduling workflows.

• Develop, maintain, and enhance Vertica SQL and CCL/Discern queries as well as reusable extracts to facilitate analytics and operational reporting within MHS GENESIS systems.

• Conduct reviews of back-end configurations and diagnostics to pinpoint root causes impacting billing, claims, or encounter workflows, and coordinate sustainable solutions.

• Utilize CCL, SQL, Tableau, Power BI, Python, SAP BO, and various analytics tools to extract, analyze, and interpret financial and operational data across MHS data platforms.

• Create, optimize, and sustain Vertica SQL queries, views, and reusable datasets that support revenue cycle analytics, including billing, collections, denials, and accounts receivable.

• Monitor and assist in the development of Key Performance Indicators (KPIs) for Revenue Cycle Initiatives.

• Collaborate with clinical, coding, billing, IT, and finance teams to ensure cohesive revenue cycle operations.

• Work alongside system administrators to ensure that the Electronic Health Record (EHR) supports necessary business processes.

• Act as a liaison between Guidehouse, DHA, and MTF operational stakeholders.

• Produce high-quality deliverables, including analytic readouts, executive summaries, methodology documentation, and data dictionaries for cross-DHA collaborations.

• Conduct data validation, lineage analysis, and quality checks across federal data sources to guarantee analytical accuracy and readiness for audits.

• Engage in support testing and validation for analytical releases.

• Investigate and aid in resolving user-reported issues related to charge capture, billing edits, registration errors, or data discrepancies.

• Perform system impact assessments and collaborate with Oracle Health/Cerner, CDAO, and RCMI technical teams to implement solutions.

• Support upgrades, interface changes, testing, and release validations, while communicating operational impacts to stakeholders.

• Participate in IT Service Management (ITSM) processes, including incident, problem, and change management.

⛳️ Requirements

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "SECRET" security clearance; candidates must secure approved adjudication of clearance prior to onboarding with Guidehouse.

• Candidates possessing an ACTIVE "SECRET" or higher-level clearance are preferred.

• Bachelor’s Degree.

• Minimum of THREE (3) years of experience providing back-end application support.

• Experience with Oracle Health (Cerner) revenue cycle back-end, data models, and charge services.

• Expert-level proficiency in SQL or CCL for data extraction, transformation, and analysis.

• Experience in optimizing query performance to enhance system efficiency.

🏝️ Benefits

• Medical, Rx, Dental & Vision Insurance.

• Personal and Family Sick Time & Company Paid Holidays.

• Position may be eligible for a discretionary variable incentive bonus.

• Parental Leave and Adoption Assistance.

• 401(k) Retirement Plan.

• Basic Life & Supplemental Life Insurance.

• Health Savings Account, as well as Dental/Vision & Dependent Care Flexible Spending Accounts.

• Short-Term & Long-Term Disability Insurance.

• Student Loan PayDown program.

• Tuition Reimbursement, along with Personal Development & Learning Opportunities.

• Skills Development & Certifications.

• Employee Referral Program.

• Corporate Sponsored Events & Community Outreach initiatives.

• Emergency Back-Up Childcare Program.

• Mobility Stipend.