Sr Decision Support Analyst

Creating Life Better Here starts with you. At San Juan Regional Medical Center, we're more than a healthcare provider—we're a values-driven organization dedicated to delivering exceptional care. As a team member, you help fulfill our mission to make life better here for our community.

Required Behaviors:

• As you go about fulfilling this mission, your work habits and work relationships should embody SJRMC's values. These values are our culture, our identity as an organization. Sacred Trust, Personal Reverence, Thoughtful Anticipation, Team Accountability and Creative Vitality ask more of us than merely completing some list of tasks. Our values ask for a deeper level of commitment, and what is asked of us we freely give because we believe in our mission.

Required Qualifications:

• Bachelor’s degree required in Finance, Mathematics, Statistics, Computer Science, or a related field; equivalent combination of education and relevant work experience may be considered in lieu of a degree
• Demonstrated knowledge of statistical analysis and modeling techniques, with the ability to apply these methods to financial and operational healthcare data
• Advanced analytical skills, proven ability to interpret and explain complicated statistical analysis; proficiency working with complex information management, financial, and analytical systems; Advanced interpersonal and communication skills, Microsoft Office skills (verbal and written)
• Advanced Excel skills, such as data simulation, power pivot, power query, complex data analyses, advanced formulas, charts and graphs, advanced charting, data validation, etc.
• Data mining
• Knowledge of any data visualization tool
• Ability to work autonomously
• Demonstration of critical thinking.
• Validate reports/analyses to ensure accuracy via comparison to internal and external benchmarks
• Thorough knowledge of accounting policies, procedures, controls, and system

Preferred Qualifications:

• SQL knowledge and utilization to create ad-hoc queries against databases
• Knowledge of hospital decision support and EMR systems, StrataJazz Decision , Workday and Cerner preferred
• Understanding of healthcare coding systems (e.g., ICD-10-CM/PCS, UB-04, HCPCS, MS DRG, CPT, etc.)
• Familiarity with commercial HMO/PPO, Medicare, and Medicaid reimbursement mechanisms for hospitals and physicians
• Experience with hospital Medicare cost report preparation

Duties and Responsibilities:

• Budgeting, Forecasting & Financial Planning:
• Directly support leadership in the coordination of the annual operating budget, including volume, revenue, expense, and FTE planning
• Prepare monthly forecasts and long-term financial projections
• Develop revenue models and IBNR analyses across service lines or product lines
• Build financial models to evaluate the impact of government regulations, reimbursement changes, and market conditions on profitability

Strategic Financial Analysis & Proformas:

• Develop financial proformas to evaluate new service lines, capital investments, and cost-saving initiatives
• Support organizational decision-making through ROI analysis and financial feasibility studies
• Assist in establishing and tracking key performance indicators (KPIs) across departments Departmental Support & Performance Analysis:
• Provide ongoing analytic and consultative support to operational and clinical departments
• Partner with leadership to evaluate productivity, workforce planning, and operational efficiency
• Develop and deliver productivity reporting and follow-up analysis
• Support benchmarking initiatives across departments and service lines
   

Variance Analysis, Reporting & Dashboards:

• Prepare variance analysis (budget vs. actual, volume, rate, mix, labor, expense drivers)
• Develop and maintain financial and statistical dashboards to monitor performance at the department and service line level
• Present findings through clear written reports and executive-level presentations
   

Decision Support & Cost Accounting:

• Maintain responsibility for costing processes, reporting, and analysis, ensuring alignment with financial statements
• Prepare costing summaries and audit reports; serve as a backup for costing processes when needed
• Recommend and implement enhancements to cost accounting methodologies and techniques
• Analyze patient-level and financial data, identifying and resolving discrepancies with source systems
   

Month-End Close & Financial Reporting:

• Participate in the month-end close process, including validation of financial results and preparation of supporting analyses
• Partner with Accounting to ensure accurate financial reporting and reconciliation across systems
   

Systems, Data Governance & Process Improvement:

• Support and enhance decision support systems, ensuring data quality, integrity, and consistency
• Assist in maintaining and optimizing budgeting and planning systems
• Identify opportunities to automate processes and reduce manual effort using advanced analytics tools
• Lead or support system enhancements and integrations (e.g., Workday, Cerner, Strata)
   

Regulatory Reporting & Compliance:

• Prepare and submit required regulatory reports (local, state, federal)
• Prepare Medicare and Medicaid cost reports in compliance with applicable regulations
• Respond to and manage third-party audit requests and correspondence