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)
Monitor and support the development of KPIs across Revenue Cycle Initiatives
Partner with clinical, coding, billing, IT, and finance teams to ensure integrated revenue cycle operations
Collaborate with system administrators to ensure the EHR supports required business processes
Serve as a liaison between Guidehouse, DHA, and MTF operational stakeholders
Produce professional deliverables: analytic readouts, executive summaries, methodology documentation, and data dictionaries for cross-DHA collaborations
Perform data validation, lineage analysis, and quality checks across federal data sources to ensure analytical accuracy and audit readiness
Participate in support testing and validation for analytic releases
Investigate and help resolve user-reported issues related to charge capture, billing edits, registration errors, or data discrepancies
Conduct system impact assessments and work with Oracle Health/Cerner, CDAO, and RCMI technical teams to implement fixes
Support upgrades, interface changes, testing, and release validations; communicate operational impacts to stakeholders
Participate in ITSM processes (incident, problem, change management)

Requirements

Must be able to OBTAIN and MAINTAIN a Federal or DoD "SECRET" security clearance
Bachelors Degree
Minimum TWO (2) years of experience providing backend application support
Experience working with Oracle Health (Cerner) revenue cycle backend , data models, and charge services
Expert-level SQL or CCL for data extraction, transformation, and analysis
Experience optimizing query performance to improve system performance.

Benefits

Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
401(k) Retirement Plan
Basic Life & Supplemental Life
Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
Short-Term & Long-Term Disability
Student Loan PayDown
Tuition Reimbursement, Personal Development & Learning Opportunities
Skills Development & Certifications
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Emergency Back-Up Childcare Program
Mobility Stipend

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLCCLPythonTableauPower BIVerticadata validationdata analysisquery optimizationbackend application support

Soft Skills

collaborationcommunicationproblem-solvinganalytical thinkingattention to detailstakeholder managementorganizational skillsinterpersonal skillsmethodology documentationprofessional deliverables

Certifications

Federal or DoD SECRET security clearanceBachelor's Degree